Post reply

Finding out who changed SQL server name

  • October 10, 2007 at 10:16 am

    #119033

    Someone in the organization changed the SQL server name :crazy:. i want to find out who changed the server name. Someone having sa rights might have changed the server name using sp_dropserver and addserver statement.

    Is there a way to find out who did it or when it was done?

    thank you

  • October 10, 2007 at 10:23 am

    #740893

    Not sure if a sp_dropserver gets logged in the default trace as an ObjectCreated/Deleted, worth a look though - trace files are in C:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\*.trc

    Tommy

    Follow @sqlscribe

  • October 10, 2007 at 11:22 am

    #740924

    Hi Tommy,

    Thank you for your reply but i am working with SQL server 2000. To my knowledge only SQL server 2005 creates default *.trc files. Please correct me if i am wrong.

    thank you

  • October 10, 2007 at 11:29 am

    #740925

    vrkc (10/10/2007)

    Thank you for your reply but i am working with SQL server 2000. To my knowledge only SQL server 2005 creates default *.trc files. Please correct me if i am wrong.

    You are correct. Unfortunately, if you did not have a trace running, I don't believe you have a way of going back and determining, as I don't remember this being logged in the SQL Server logs, either.

    K. Brian Kelley
    @kbriankelley

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

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