Solved

tsql server 2000 when was table last updated

Posted on 2009-04-02
1
317 Views
Last Modified: 2012-06-27
Hi all,

I have a table and would like to know when it was last updated. Unfortunately the person that built the table hasnt put anything in place to capture this?
0
Comment
Question by:9772885
1 Comment
 
LVL 11

Accepted Solution

by:
bmatumbura earned 500 total points
ID: 24047653
f you are asking for change in table structure then In SQL Server 2005 you can get it. modify_date in sys.tables table will give you the details.

If you want to know the latest date the table records are updated (insert, update, delete) there is no such built in functionality; you'd have to design your own auditing solution (e.g. using additional columns, auditing tables, triggers etc.).
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question