INF: ????? ????? ???????? ???????? ????? ????????? ???? ?? SQL Server 2000 Service Pack 3

?????? ????????? ?????? ?????????
???? ???????: 810474 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ???? ?????? Service Pack 3 (SP3) Microsoft SQL Server ???? ????? ?????? ???????? ?????? ?????? ????? ????? ???????? ??? ????? ????? ????? ???????? ???????? ??????? ????? ??????? ????? ????? ?????? ????? ???????. ?????? ??? ??????? ????? ????? ???????? ??? ????? ?????? ?? SQL Server 2000 SP3. ???????? ??? ??????? ????? ????? ?????? ?? ?? ???? ????? ????? ????? ???????? ????????. ?? ????? ??? ?????? ???? ???????. ???? Microsoft ???????? ?????? ????????? ???? ???? ???? ????? ???????? ???? ??????.

??????? ????

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

???? ???????? ????? ???? ?????? ????? ???????? ?????. ????? ???? ???? ??? ????? ??? ?? ????? ???? ?? ???? ????? ?? ??? ???????? ???? ???, ??? ????? ????? ??? ?????. ??? ???? ??????? ???? ????? ?? ??? ??? ????????. ??? ?????? ???????? ??? ?????? ?????? ? ????? ????? ?? ??????? ?????? ?? ?????? ??????? ?? ??? ???????? ???? ??????? ???????? (??????? ??????? ?? ??? ????? ?? ?????? ????) ? ????? ??????? ???? ?? ??????. ?? ???? ?????? ????? ??????? ????? SQL Server ???????? ??? ?????? ?????? ???? ??? ??? ???????? ?????.

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

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

??? ??? ???? ???? ?? ????? ???????? ????????? ?????? ????? ?? ?? ??????? ??????? ????????? ????????? ??????? ?? ??? ????? ?? ????? ?????? ????? ??? ???????? ?? ????? ?????? ???? ?? ??? - ????? ????? ???????. ?? ???? ????????? ???? ????? ??? ????? ????? ????? ???????? ???????? ?? ??? ??????? ??? ?? ????? ????? ????? ???????? ???????? ??????? ????? ?????? ?????.

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

???? ???? Microsoft ?????? ????? ????? ???????? ??? ????? ?????? ???? ?? ????????? ???? ???? ??????? ????? ???? ???????? ??????????:
  • ???? ????? ????? ?????? ????? ?????? db_ddladmin ?? ??????? ????? ???????? db_owners ???????? ???? ?????? ?????????? ???????. ???? ??? ???????? ???? ?? ??????? ?? ???? ??????? ???????? ?? ????? ???????? ??????. ??? ???? ??? ??? ??? ?????? ????? ?????? ??? ??????? ????? ??? ?? ???? ???? ??? ????? ?????????? ?? ???????? ?? ???? ????? ????????. ????? ????? db_ddladmin ???????? db_owners ?? ????? ???????? ??????? ?? ????? SQL ???????? ??????? ???????:
    exec sp_helprolemember 'db_ddladmin' exec sp_helprolemember 'db_owner'
  • ???? ????? ????? ?????? ????? ?????????? ????? ????? ??? "????? ????? ??????" ?? ????? ????? ?????? ??????. ??? ?? ????? ????? ????? ????? ???????? ???????? ???? ?????? ?????????? ?????? ??? ???????? ?? ????? ???????? ?????? ?? ????? ???????? ??????? ?????? ?? ???????.
??? ????? ?? ?? Microsoft ???? ????? ????? ????? ????? ???????? ???????? ?????? ???? ?????? ? ???? ??? ????? ??? ????? ???? ???? ????? ?????????? ????? ???? ????????; ????, ????? ????? ????? ?????? ?????? ??????? ?????? ?????? ????? ??????? ?????????.

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

?? ?????? ????? ???? ?????? Service Pack 3 (SP3) Microsoft SQL Server ? ?? ????? ???? ???? "????" ?????? ????? ?????? ?? ?? ????? ????? ????? ?????? ?????? ??? ??? ?????? ???????. ??? ??? ?????? "????? ????? ???????? ???????? ??????? ????? ??????? ????? ????? ??????" ????? ????? SQL Server 2000 SP3 ??? ????? ??? ?????? ??? ???? ????? ????????. ??? ?? ?????? ????????? ??? SQL Server 2000 SP3. ??? ????? ?? ?????? ???? ??? ?????? ????? ??????? ????? ????? ????? ?????? ?????? ????? ????? ????? ???????? ???????? ???????? ????? SQL ???????? ?? ?? ????? SQL Server ??????? ????? ??????.

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

?????? ????? ?????? ????? ????? ???????? ??? ??????? ?????? ????? ?? sp_configure ???????? sp_dboption ?????.

?????? ?? ???? ??? ?? ????? ????? ????? ?????? ??? ?? ????? ????? ????? ????? ????? ???????? ????????.
  • ????? ????? ????? ????? ???????? ???????? ???????? ????? SQL ????????:
    • ????? ????? ?????? ???? SQL Server ?? ?????? ??????? DB ??? ????? ????? ?? sp_configure ????? ????? ???????? ????????. ??? ????? ??? ?????? ??? 0? ???? ?????? ?? ????? ????? ????? ???????? ???????? ?? ????? ????? ???????? ???????? sp_dboption. ??? ????? ??? ?????? ??? 1 ? ?? ????? ????? ????? ????? ????? ???????? ????????. ??? ?? ?????? SP3 ????? ?? ??? ????? SQL Server 2000. ??? ??? ?????? ??? ?????? ????? ???? ????? ????? ?????? ??? ?????? ??? ????? ??????. ??? ???? ??????? ?????? ????? ?????? ?????? ????? ????? ????? ???????? ???????? ?? ???? ????? ????????:
      EXEC sp_configure 'Cross DB Ownership Chaining', '1'; RECONFIGURE 
      
    • ????? ????? ????? ????? ???????? ???????? ?? ????? ????? ???????? ?? ?????? ????? ????? ?????? ????? ?? sp_dboption. ??? ????? ??? ?????? ??? false "? ?? ???? ?? ????? ????? ???????? ?? ????? ???????? ???????? ??????? ????? ?????? ?? ????? ???????? ?????. ??? ????? ??? ?????? ??? true? ????? ???????? ????? ???????? ?? ????? ????? ????? ???????? ????????. ??? ?????? ???? ??????? false ??????? ????? ????? ?????? ???????? ??? ????? SQL Server 2000 SP3. ????? ????? ?????? ?? ????? ????? ????? ???????? ???????? ????? ?????? Northwind:
      EXEC sp_dboption 'Northwind', 'db chaining', 'true'

    ??? ?? ??????? sp_dboption ??? ??? ????? sp_configure ?????? ?????? ????? ??????? DB ??? 0. ?????? ?????? ????? ????? ???????? ??? ????? ????? ????? ???????? ??? ????? ??? ?????? ??? ?? ?? ?????? ????? ???????? ?????.
  • ????? ????? ????? ????? ???????? ???????? ???????? ????? ??????? SQL:
    • ?????? ??? ?????? ?? ??? ???? ????? ???????? "? ???? ??????? ???????:
      1. ???? ??? ?????? ?????? ??? <server>.
      2. ???? ??? ?????.
      3. ???? ??? ??????.
      4. ???? ?????? ?????? ??? - ????? ????? ??????? ?? ????? ??????? ??????.
      5. ???? ??? ?????. ??? ??????? ?? ?????? ?????? ????? ????? SQL Server.
      6. ???? ??? ?????.
    • ?????? ??? ?????? ????? ????? ???????? "? ???? ??????? ???????:
      1. ???? ??? ?????? ?????? ??? <database>.
      2. ???? ??? ?????.
      3. ???? ??? ??????.
      4. ???? ?????? ?????? ????? ?????? ?????? ????? ??????? ?? ?????? ???????

???????

???? ???????: 810474 - ????? ??? ??????: 17/????/1428 - ??????: 4.3
????? ???
  • Microsoft SQL Server 2000 Service Pack 3
????? ??????: 
kbmt kbproductlink kbinfo kbsysadmin kbupgrade kbsqlserv2000sp3fea KB810474 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????810474

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

 

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