Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identify Table Update Date

Status
Not open for further replies.
Skittle

Skittle

ISP
Sep 10, 2002
1,528
US
Is there a way to identify the last time a table was updated ( i.e. any change made to the data in the table )
in SQL Server 2000?



Dazed and confused
 
Sort by date Sort by votes
Unless you have set up your own audit trail,then no.
 
Upvote 0 Downvote
Didn't think so....but you never can be sure. :eek:)

Dazed and confused
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

intel233
  • Locked
  • Question
Update field
Replies
2
Views
78
intel233
intel233
Skittle
  • Locked
  • Question
SQL Server Profiler To Identify A Fault
Replies
3
Views
120
yelworcm
yelworcm
AndrewWiggins99
  • Locked
  • Question
Read Only access on a specific table 1
Replies
3
Views
95
fredericofonseca
fredericofonseca
djj55
  • Locked
  • Question
Unable to update the database IDs error.
Replies
5
Views
152
djj55
djj55
dgillz
  • Locked
  • Question
How to create login that has access to only certain tables in a database
Replies
4
Views
84
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top