Tips and scripts relating to database administration. Mainly SQL Server but some MySQL and every now and again something different. Posts are brief and to the point.It's as much a place to make notes for my own use as anything else.
Friday, 20 May 2011
Changing a SQL Server 2008 Instance Name
To change the name of a SQL server instance.
EXEC sp_dropserver 'oldname' GO EXEC sp_addserver 'newname', 'local' GO
No comments:
Post a Comment