???? ID: 303774 - ????? ???????: 04 ?????? 2010 - ??????: 2.0

BUG: "?? ??? ??? ??? ??? ?????" ???? ?? ??? SQL Server ???????? ?????? ?? Incomplete

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
BUG #: 354825 (SHILOH_BUGS)
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?????? SQL Server 2000 ???????? ?????? ???? ??? "?? ????? ?? ??? ?????" ?????? ??? ?????? "???????" ?? ?????? ?? ???????? ???

SQL ????? ???????? ?????? ?????? ???:

sp_dropserver old_name
go
sp_addserver new_name
go
??? ?????? ??:

sp_dropserver 'old_name' 
go 
sp_addserver 'new_name', 'local' 
go

?? ???sp_dropserver?? ?????? ????? ??? ???? ??? ?? ?? ?????? ????? ??? ?? ???????????? ?? ?????? ?? ?? ???? ????? ?? ???????? ????????? ?????? ???? ?????? ????? ????? ?? ?? ??????? ?????? ????? ???? ?? ???? ?? ?????? ?? ???? ??? ?? ????? ?? ??? ?????? ??????? ?? ??? ??? ?????? ?? ???? ????? ?? ??? ???? ??? ?? ????? ????? ????? ?? ??????? ???, ?? ?????droplogins????:

sp_dropserver 'old_name', 'droplogins' 
go 
sp_addserver 'new_name', 'local' 
go

???:????? ?? ???sp_addserver???????? ????????? ???????? ???? ?????? ???????? ???? ?? ??? SQL ????? ????@@ SERVERNAME?????? ????

SQL ????? ???????? ?????? ?? ????? ?????:

You do not have to run Setup again to reset the computer name.
????? ??? ???? ??? ?? ??????? ????? ???? ?? ??? ??? ??? ?? ??????? ???? ????, ?? ???? ??? ??????? ????? ?? ???????????? ???? ?? ??? ???? ??? DO ??????? ????? ?? ??? ??? ???
????? ?? ???? ????

????

???? ??? ?????? ?? ????? ??? SQL ?????Servernamemay be NULL or not match the current Microsoft Windows NT machine name:
  • The computer was renamed.

  • An image was taken of the SQL Server computer, and then copied onto another computer.

  • Thesp_dropserverstored procedure was run for the localSERVERNAME.
????? ?? ???? ????

??????

Microsoft ?? ?????? ?? ?? ?? ?? ???? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?? ?????? ??..
????? ?? ???? ????

???? ???????

To check if you have a mismatch between your SQL Server servername and the computer's machinename, compare the values from the statements that follow. If the values do not match or if@@SERVERNAMEis NULL, you need to rename your SQL Server. ?????? ?? ???::
-- get current SQL Server name\instance name
  SELECT @@SERVERNAME
-- get current machine name and instance name
  SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')
????? ?? ???? ????

??????

SQL Server 7.0 ?? ??? ????? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
195759  (http://support.microsoft.com/kb/195759/EN-US/ ) INF: ????????????? ??? - SQL Server 7.0 - ?????? SQL ?????
????? ?? ???? ????
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
????? ?? ???? ????
??????: 
kbbug kbpending kbmt KB303774 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:303774  (http://support.microsoft.com/kb/303774/en-us/ )
????? ?? ???? ????