?
Solved

tsql server 2000 when was table last updated

Posted on 2009-04-02
1
Medium Priority
?
327 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

615 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