wrong @@SERVERNAME

来源:互联网 发布:5g 知乎 编辑:程序博客网 时间:2024/06/06 00:43

http://msdn.microsoft.com/en-us/library/aa933172(v=sql.80).aspx



USE masterGOEXEC sp_dropserver 'OLDSERVERNAME' -- This is the wrong name you got from @@SERVERNAMEGOEXEC SP_addserver 'NEWNETWORKNAME','LOCAL' -- This is the correct hostname of the box which you can get from windows.GO


0 0