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

michael_aussie gravatar 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

    michael_aussie gravatar 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:

    x68

    asked: May 13, 2010 at 12:55 AM

    Seen: 840 times

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