All about technology and cool stuff.
sp_dropserver 'old SQL Server server name'
GO
sp_addserver 'new computer name', 'local'
GO
Stop and Restart SQL Server service
Now Run
SELECT @@SERVERNAME
to verify the changes
Posted by
Charles Vaz
at
6:21 AM
Note: Thanks to all the above authors/publishers for the above public educational links/material. All the above links are copyright material by the respective authors. Individual Copyrights are not displayed here due to space restrictions. The links/material displayed here, is not for commercial use, but for personal reading only. Certain names/titles may have been written in abbreviation format just to enable easy viewing and is in no way designed to infringe any trademark. No responsibility is hereby undertaken with regard to the validity/[accuracy of the content] of the links/material. All the above links were found by online searches and were provided as public material by the respective sites. Thanks again, to all the above authors/publishers for the above public educational links/material.
No comments:
Post a Comment