Renaming SQL SERVER

When you need to change the name of the server in the operating system and you need to change the name of the SQL Server

1. First of all Backup your databases
2. select @@SERVERNAME then it returns the the name of the SQL Server
3. sp_dropserver 'jmc-pc' name of the server
4. go
5. sp_addserver 'ws-jmc', local
   
6. go
7. repeat step 2 after restarting SQL Server to check if the name of SQL Server is OK
8. More Information in http://msdn.microsoft.com/en-us/library/ms143799.aspx
   

Related Posts:

• Stored procedure to copy files

• SQL date manipulation

• Database Triggers

• Create SP with Cursor