To change the name in the O/S:
** If joining a domain, do it all at once, if at ALL possible **
To then change the name of the already installed SQL Instance:
select @@servername -- wasgo sp_helpserver -- was go select serverproperty('servername') -- was go select * from sys.servers; -- was go sp_dropserver ' '; GO sp_addserver ' ', local; GO select @@servername -- is now go sp_helpserver -- is now go select serverproperty('servername') -- was already go select * from sys.servers; -- is now go
No comments:
Post a Comment