question

michael_aussie avatar image
michael_aussie asked

a log of table modifications/updates in SQL Server 2005

I am looking for some sort of log table that tells me where my data has "gone" in SQL Server2005. In the application that runs on top of the SQL DB we enter information, but I can't find there it is going? I assume there must be a logging file that lists at the least the table that has been modifed.

regards, Michael.

transaction-log
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
michael_aussie avatar image
michael_aussie answered

nathans answered this from me. I needed to use Profiler, a seperate program to Server Management Studio. ty nathans

Originally posted by nathans You can find under Tools menu in Mgmt Studio. This has some great screenshots to guide you:

http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm

  • dont use against production system without first reading up :)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.