After the SQL Server changes the name

SQL after the server changes the name

Author : CC Abba

2014-6-15

in Daily SQL 2005 database operation, sometimes after the database is installed, and then renamed, causing some SQL Service is not working properly (in SQL2000 , you don't want to change your name.)

Select serverproperty(' servername '), @ @servername

See if the names of instances are equal . Modify if not equal .

Sp_helpserver

sp_dropserver ' DBSLCQB '

sp_addserver ' dbsljta',' LOCAL '

If the hint already exists can sp_dropserver ' Dbsljta ' Span style= "Color:gray", and add the

Restarting resolves the issue . Thanks !