BUG: ?? ???? DBO ???????? ?? "????? ???????

?????? ????????? ?????? ?????????
???? ???????: 305711 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???????? ?????? (dbo) ????? ???????? ?? ????? ?????? ?????? ??? ????? ?? ???? "??????????" ?? "????? ???????. ???????? ??? ???? ??? ??? ????? ?? ????? ???? ?? ?????? Logins ?? "????? ??????? ?? ????? ????? ????? ???????:
??? 21776: [SQL-DMO ??? 'dbo' ?? ??? ?????? ??? ?????? Users. ??? ??? ??? ??? ???? ??????? [] ???? ????? ?????? ?? ????? ?? ???? ??? ????.
???? ??? ??????? ??? ??? ????? SQL Server 2000 Service Pack 1 (SP1) ??? ??????. ??? ??? Service Pack 1? ??? ???????? dbo ?? "??? ????? ??????" ?????.

?????

??? ????? ????? ??????? ???? ??? ???? ???? ????? ?????????? ???? ?? ????? ??? ??????? ?????? ?????? ?? ??? ??? ???????? dbo ????? ???? ??????. ??????? ???????? ????? ???? ?????? ????:
  • ??? ?? ????? ????? ?????? ?????? ????? ???? ?????? Microsoft Windows NT ???? ?? ???? ?? ?????? ??? ????????? ???? ?????? SQL Server ?? ???? ????? ???????? (??? BUILTIN\Administrators) ? ??? ????? ?????? (SID) ??????? ?? ???? ?????? sysusers ?? ????? ???????? ?? ????? SID ????? ?? ?????? ?????? syslogins.
  • ??? ??? ??? ??????? ????? ?????? ??? SID ???????? dbo ?? ???? ?????? sysusers ?? ?????? ?? SID ??????? ?? ???? ?????? syslogins.

???? ??????

??? ?? ??? ???????? dbo ???? ????? ????? ???? ????? ???????? ??? ?????? ???? ???? ?????. ??? ???? ??????? ????? ???? ????? ???????? ??? ????? ?????? (sa) ??? ?? ????? ????????? ???????? ???????:
exec sp_changedbowner 'sa'
					

?????

???? Microsoft ??? ???? ????? ?? SQL Server 2000 Service Pack 1 (SP1).

??????? ????

?????? ?? ??? ??? ???????? dbo ??? ??????? ?? ????? ?????? ?????? ????? ????????? ??????:

Use <User_Database>

GO

SELECT u.name AS "Name", ISNULL(l.name, 'dbo is unmatched') AS "Matched Login"

FROM sysusers u

     LEFT JOIN master.dbo.syslogins l ON u.sid = l.sid

WHERE u.name = 'dbo'

GO

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
218172PRB: ?? ???? ????? ???? ???? SA ?? "????? ???????
274188PRB: ??????? "??????? ????? ?????????? ???" ?? ???????? ??? ?????
168001PRB: ???????? ????? ?????? ?/?? ??? ????? ??? ??????? ?????
246133????? ??? ?????? ????? ?????? ?????? ?????? ??? ?????? SQL Server
298758PRB: ??????? ?????? Auto_Fix ?? sp_change_users_login ???? ??? ??????? ???????

???????

???? ???????: 305711 - ????? ??? ??????: 29/???? ??????/1426 - ??????: 5.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbpending KB305711 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????305711

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

 

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