Solved

tsql server 2000 when was table last updated

Posted on 2009-04-02
1
314 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 …
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now