x

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.

more ▼

asked May 13, 2010 at 12:55 AM in Default

avatar image

michael_aussie
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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 :)

more ▼

answered May 13, 2010 at 01:47 AM

avatar image

michael_aussie
1 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x79

asked: May 13, 2010 at 12:55 AM

Seen: 927 times

Last Updated: May 13, 2010 at 12:55 AM

Copyright 2016 Redgate Software. Privacy Policy