BUG: ?? ????? "????? ????? ???? A" ?? "??? SQL Server ???????" ??????

?????? ????????? ?????? ?????????
???? ???????: 303774 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 354825 (SHILOH_BUGS)
????? ???? | ?? ????

???????

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

????? ?????? "??? SQL Server ???????":

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 Server ??? @@ SERVERNAME ????? ???????.

??? SQL Server ??????? ????? ???? ?? ???:

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

?????

???? ??? ??? ????? ????? ?? SQL Server SERVERNAME ???? ????? ?? ?? ????? ??? ?????? ?????? ?? Microsoft Windows NT:
  • ??? ????? ????? ?????????.

  • ???? ?? ???????? ?? ????????? SQL Server ??? ?? ????? ??? ??????? ???.

  • ?? ????? ??????? sp_dropserver ????? ???? SERVERNAME.

?????

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

??????? ????

?????? ?? ???? ??? ????? ??? SQL Server servername ? machinename ????????? ?????? ????? ?? ???????? ???????. ?? ???? ??? ????? ????? ?? ??? @@ SERVERNAME ?? NULL ? ????? ??? ????? ????? ???? SQL. ??? ???? ??????:
-- 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:
195759INF: ????? SQL - SQL Server 7.0 - ??????? ?????????

???????

???? ???????: 303774 - ????? ??? ??????: 08/????/1424 - ??????: 4.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbpending KB303774 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????303774

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com