?
Solved

tsql server 2000 when was table last updated

Posted on 2009-04-02
1
Medium Priority
?
322 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

719 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