Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Change Instance Name

Author  Topic 

chriztoph
Posting Yak Master

184 Posts

Posted - 2009-07-31 : 02:41:49
Hi!

Just a Simple question..

How to change the instance name of SQL Server 2005?

Sample:
127-160\TRIACSSVR

Remove 127-160(Computer Name), so the server Name should be like this 'TRIACSSVR'

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-08-01 : 02:49:01
hint: sp_Dropserver and sp_Addserver... check out books online for more info.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -