Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsn1966
Starting Member
9 Posts |
 Posted - 2009-02-02 : 19:14:33
|
| I was wondering if it was possible to find out whether a table has been updated in Sql Server 2000? Does Sql Server keep logs of changes (add, delete, or changed/updated) records? If so, what system tables or stored procedures could I use to look up the changes? Thanks.Stephen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rsn1966
Starting Member
9 Posts |
Posted - 2009-02-02 : 19:38:57
|
| What tools could you recommend that I look up the transaction log? |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-02-03 : 15:22:00
|
| I have used APEX SQL in the past. I can verify it will show you wat the tlogs say in SQL code.I believe there was a free trial at the time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Logs for table updates