October 10, 2007 at 10:16 am
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
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 @sqlscribeOctober 10, 2007 at 11:22 am
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
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