Utilizing sp_dropserver and sp_addserver system procedures we will change local SQL Server name to a specified one, or, by default, to the WINS machine name.
Just another utility in my DBAservice toolbox database.
1.Tested in SQL Server7.
2. In some cases it is necessary to rerun sql server setup in order to start the server after renaming. Neither data nor version is affected.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.