Solved

tsql server 2000 when was table last updated

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…

737 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