Post reply

How to check which user changed the compatibility level of database?

  • April 15, 2009 at 9:26 pm

    #384366

    I tried searching this info in the sql server log, no joy there? Is it stored somewhere else?

  • April 16, 2009 at 4:01 am

    #978689

    It might be in the default trace (set of .trc files in the SQL log directory). If not, then no, it won't be stored anywhere.

    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

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

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