Wednesday, June 14, 2017

change sql server hostname

select @@servername -- view servername
EXEC sp_DROPSERVER 'oldservername'
EXEC sp_ADDSERVER 'newservername', 'local'
restart server
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)