x
login about faq Site discussion (meta-askssc)

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 '10 at 12:55 AM in Default

michael_aussie gravatar image

michael_aussie
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 '10 at 01:47 AM

michael_aussie gravatar image

michael_aussie
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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x57

asked: May 13 '10 at 12:55 AM

Seen: 453 times

Last Updated: May 13 '10 at 12:55 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.