I have a script that will rename the server using the difference between the select @@Servername and the select SERVERPROPERTY('ServerName')

http://www.brinnenterprises.com/rename-server.aspx

Please let me know if this is useful, I...

This thread has been really useful but I need to run a weekly trace (mon - fri) without causing a major performance overhead on the server. I am currently starting...