The key is the below statements.
sp_dropserver 'old_name' go sp_addserver 'new_name','local' go
How To: Change Instance Name Of SQL Server [via]
Friday, December 05, 2008
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
-
The Google Adsense made a blog post with a video to help us understand the concept behind eCPM (Effective Cost Per Thousand Impressions). ...
-
An efficient method to find out the total record counts of all tables in an Oracle database. select table_name, to_number(extractvalue(xm...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.