Post reply

Finding out who did what in SQL Server ?

  • April 17, 2014 at 3:23 am

    #290401

    Hi

    Is there a way to look in sequel server to find out if somebody ran a script against one of my servers after the fact has happened ? I know that a script has been run because a table has been altered with a new column added, but I would like to find out at what exact time it was run as I suspect it has negatively effected our replication.

    We are running sql2008 standard edition.

    Would the default traces reveal anything ?

    Thanks

  • April 17, 2014 at 3:29 am

    #1706678

    Schema changes are in the default trace, though only for a while. It keeps 5 files of 20MB each. On some servers I've seen that overwritten within 4 hours.

    Otherwise, unless you have some trace or audit already set up, no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 17, 2014 at 4:07 am

    #1706687

    Ok thanks Gail.

    Looks like iv'e missed the boat then as the default trace is not going back to the day I need.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply