I need to change the server name of a live SQL server. Aside for re-creating
ODBC connections; are there any issues doing this?
Hi,
You could use sp_dropserver and sp_addserver system procedures to change
server name. There wil not be any issues
apart from changes in connection strings . But this change require a restart
of SQL Server service.
No need to restart the server.
Thanks
hari
SQL Server MVP
"Peretz Stern" <peretzstern@.optonline.net> wrote in message
news:eECNEvHmFHA.3780@.tk2msftngp13.phx.gbl...
>I need to change the server name of a live SQL server. Aside for
>re-creating ODBC connections; are there any issues doing this?
>
Sunday, March 11, 2012
Changing server name
Labels:
changing,
connections,
database,
live,
microsoft,
mysql,
oracle,
re-creatingodbc,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment