???? ?? SQL Server 2000 Service Pack 2: 9 ??????, 2001

?????? ????????? ?????? ?????????
???? ???????: 889552 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? Microsoft SQL Server 2000 Service Pack 2 (SP2) ????????? ?? ??? ?????? ????? ???????? ?? ????? SQL Server 2000. ????? ??? ??????? ???????:
  • ??????? ???? ?????? ???? ????? ????? Service Pack 2.
  • ????? ????? ???? ????? ??????? Service Pack 2.
  • ????? ????? Service Pack 2.
  • ????? ????? ????? ?????? ????? ???????? ?? ?????? ?????? ?? Service Pack 2.
  • ????? ?????? ?????? ???? ???? ??? ??????? ???????? ??? ?????? ???? ????? Service Pack 2.

?????????

??????? ????

1. ???????

??? ????? ??? ??????? ?? Service Pack 2 (SP2) ?? Microsoft SQL Server 2000 ?? ????? ?????:
  • SP2 ?????? ????? ???????? ????? ????????? ?? ??? ?????? ????? ?????? ????? SQL Server 2000? ???????? ?????? ?? SQL Server 2000 Desktop Engine. ????? SP2 ?????? ????? ?????? ??????? ???:
    • ???? ??????.
    • ????? ?????? ????? ???????? ???????? ??? SQL Server Enterprise Manager ? osql.
    • ????? ??????? ?????? ??? Microsoft OLE DB ?? ?? SQL Server 2000 ?? ?????? ????? SQL Server ODBC 2000 ??????? Net-Libraries ???????.
  • ???? ????? ??????? SP2 ??????? ?? ?????? SQL Server 2000 Analysis Services ?? ????? SQL Server 2000 ??? ?? ???:
    • ????? ???????.
    • ????? ????? ?????? ??????? ????? ????? ?????? ????? Microsoft OLE DB ?? Analysis Services.
    • ????? ??????? ?????? ??? Microsoft OLE DB ?? ?? SQL Server 2000 ?? ?????? ????? SQL Server ODBC 2000 ??????? Net-Libraries ???????.
  • SP2 Engine ??? ????? ????????? ?? ??? ?????? ????? ???????? ????? SQL Server Desktop Engine (????? ????? MSDE 2000), 2000 ??? ?? ???:
    • ???? ??????.
    • ????? ??????? ?????? ??? Microsoft OLE DB ?? ?? SQL Server 2000 ?? ?????? ????? SQL Server ODBC 2000 ??????? Net-Libraries ???????.
???? ????? ??????? ??????? ??????? ?? SP2 ??? ??? ?? ???????:
  • ????? SQL Server 2000 ????? ??????? SP2 ?????? ????? ???????? ?? ????? ?????? ????? ???????? ?????? ??? ??? ????? ?????? ????? ??????? ?? ?????? ?? SQL Server 2000 Desktop Engine.
  • ????? ????? 2000 ????? ??????? SP2 ????? ??????? ?????? ?????? ????? ??????? ??? ??? ????? ????? Desktop Engine ?? ?????? ????? ???????? ?????? ???.
  • ????? Engine ??? ??????? SP2 Desktop Engine ?????? ????? Desktop Engine ??? ????? ????? ??????? ?? ???????? ?? ??????? ???? ?? SQL Server 2000.

    ?????? ??? ??? ???? ?????? ?????? ?? Desktop Engine ? ??????? ???? ?? SQL Server ??? ??? ????????? ?????? ???? ?????? ??? ?????? Desktop Engine 2000 ? SP2 ?????? ????? ???????? ??? ???????? ?????? ?? SQL Server 2000 Desktop Engine SP2.
?????? ??? ???? ?? ????????? ??? ????? Desktop Engine, ???? 2.2 ???? " ??? SP2 Engine ??? ??????" ? " 3.7 ????????? SP2 Desktop Engine."

?????? SP2 ????? ??? ?????? ?? ??? ??????? ??? ???? ?????? ??????? ?? ?????????? (????????) ? ?? ???????? ? ?????????, ??? SQL Server 2000 Desktop Engine ?? ??????? ?????? ?? SQL Server 2000 ????? ??? ??????? ??? ???? ???? ??????? ?? ?????????? (????????) ????????, ? ?????????, ??? SQL Server 2000 Desktop Engine ?? ??????? ??? ?? SQL Server 2000 ????? ???. ?? ????? ?????? SQL Server 2000 ???????? ?????? SP2 ?????? ????? ???????? ?? SP2 ????? ??????? ???????? ??? ??????. (????????), ?????????? ????????, ? ????????? ????? ?????? ?? ????? Service Pack 2 ??? ????? ?? SQL Server ??? Desktop Engine ??? ?? ?????? ????? Service Pack 2 ???? ????? ????? ????? ??? ???????? ?????? ?? ??????????-??? ??????? ??????? Service Pack 2 ??? ?? ???? ??? ??????? ?????? ?????????? ?? SQL Server 2000. ???? ??????? ??????? ????? ?? ???? 2.0 " ????? ?? ??????? SP2."
????? ???????? ???????? ????? SP2 ?????? ????? ????????
????? SP2 ?????? ????? ???? ?? ?? ????? ?? SQL Server 2000 ??????? ??? ???? ?? SQL Server 2000 ???????? ??? ???????? ??? ????? ???????? ???? ?? ????? ?? ???? ?????? ???. ???? ??? ????? ???? ??????? ??? ??????? ?????? SQL Server 2000 Standard Edition, ??? ???? ??????? ?? ????? ?????? ???????? ???? ???? ?? SQL Server 2000 Enterprise Edition ???.

???? ????? SP2 ?????? ????? ???????? ??? ???? ??????? ???? ?? ???? ???? ?? SQL Server. ??? ???????? ???????? ?? SQL Server 2000 ????? ??? ????? ??? SP2? ??? ????? SP2 ??? ?? ????. ??? ????? ???? ???? ??? ??????? ?? SQL Server 2000 ????? ???? ?? ???? ??? SP2? ????? ??????? ???? ??????? ??? SP2. ?? ???? ????? ??? ????? ?? ??????? ?? ??? ?? ???? ??? ???????.
????? SP2
??? ????? ???? ??????? ?? ?????? ??????? ??? ????? ?????? ?????? ??????? ??? ??? ????? ????? ????? ?????? ???????? ?????? ???? ?? ????? ???????? ????? ????????. ???? ??? ??? ?????????, ?? ???? ????? SP2 ??????. ?????? ??? ??????? ?? ????? ??? ????? SP2? ??? ????? ????? ?????? ?? SQL Server 2000. ?? ??? ????? ????? ??? ????? SQL Server 2000. ??? ??? ????? SQL Server 2000 SP1 ?? ?? ????? ??? ????? SP1 ??? ??????. ?????? ??? ???? ?? ????????? ??? ????? ????? SP2? ???? 3.13 ???? " ????? ????? SP2."

?????? ??? ????? SP2? ??? ????? ???? ???????? ?? ????? ????????? ??????? ???? , ? msdb ??? ?????? ??? ?? ????? SP2. ?????? ??? ???? ?? ?????????, ???? ?????? 3. " ????? ??? ??????? ????? ???????? SQL Server' ? ???? " 3.2????? ??? ??????? ????? ???????? ????? ???????."
??????? ?????? ??? SP2
??? ????? ????? ?? ????????? ??????? ?? ???? ??????? ??? ?? Microsoft Knowledge Base ??????? Q306908. ??? ?? ????? ???????? ?? 306908 ?????? ??? ????? ????? ??????? ??? the problem ???????? ?????? ???????. ??? ??? ???????? ??????? ?? Microsoft Product Support Services Knowledge Base.
???? ?????????? ??? ???????? FIX ??????? ??????? ??? ?? ?????.

???? ??? ??? ??????? ??? ????? ??? SQL Server 2000 Service Pack 2 ??????? ??? ???????? ?? ????? ??? ??? ??????? ?? ??? ??????? ???????? ??? ?? Q306909 ????? Microsoft Knowledge Base. ????? ??? ??????? ??? Microsoft Product Support Services Knowledge Base.
?? QFE
??? ????? ????? QFE ??? 3, 2001, ?????? ??????? ?? ??? ??????? ?? ??? ??????? ?? SP2. ?????? ??????? ????? ??? ???????? ??? ????? QFE ????? SP2.

???? 1.1 ??????? ?????? ?? SQL Server ?? ????? ???????

??????? ???????? ??????? ?? ??? ????? ?? ????? ?? SQL Server ?? ????? ??????? ??? ??????.
SQL Server
??? ?????? ?? ????? ?? SQL Server 2000 ??? ?????? ?? SELECT @@VERSION ?? ???? ??????? ??? ??????? ?????? ???????? osql ?? isql ?? ?? ???? ????????? ?? ???? ??????? SQL. ???? ?????? ?????? ??????? ??? ????? ????? ?? ??????? ??? ?? ??? @@VERSION ???? ????? SQL Server 2000.
?? ??? ??????????? ??? ??????
@@VERSION????? SQL Server 2000
8.00.194SQL Server 2000 RTM
8.00.384SP1 ?????? ????? ????????
8.00.532SP2 ?????? ????? ????????
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2) Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 2) Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2) Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2) Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2) Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
?????? ????? ????? ??? ????? SQL Server. ??? ?? ?????? ??????? ???? ??????? ??????.

????? ???????
?????? ??? ?????? ????? ?? ????? ???????, ???? ??????? ???????:
  1. ?? ????? ???? " ? ??? ??? Program Files SQL Server 2000 , ????? ??????? , ??? ?? ???? ??? ????? ??????? .
  2. ?? ???? ????? ??????, ???? ??? ?????? ?????? ??? ?????? ?????? ??????? ???? ??? ????? ??????? .
  3. ???? ?????? ?????? ?? ????? ?? ????? ??????? ????.
?? ??? ??????????? ??? ??????
??????? ???????? ????? ???????
8.0.194SQL Server 2000 Analysis Services RTM
8.0.382????? ??????? SP1
8.0.532????? ??????? SP2

????? 2.0 ? ??????? SP2

??? ????? ???? ??????? ??? ???????? ????? ??????:
  • ??? ??? SQL Server 2000 Service Pack 2 ??????? ????? ??? ??? ??????? ???????? ???????:
    • SP2 ?????? ????? ????????
    • ????? ??????? SP2
    • SP2 Engine ??? ??????
    ??? ????? ??????? ????? ????? ??????? ???????? ?????? ????? ???????? Desktop Engine ???????? . ???? ?????? ???? ?????? ?????? ?????? Desktop Engine ?? 16.
  • ?? ???? ????? ????? ????????? ?????? ???? ???? ????? ?? ????????:
    • SQL2KSP2.exe ?????? ????? ???????? (SP2)
    • SQL2KASP2.exe ????? ??????? (SP2)
    • SQL2KDeskSP2.exe Desktop Engine (SP2)
    ?????? ????? SQL2KDeskSP2.exe ????? ?????? ?? ???? ???? ?? Desktop Engine ???? ?? ?????? ??? ?? sqlrun01.msi. ?????? ??? ???? ?? ?????????, ???? 2.2 ???? " ??? SP2 Engine ??? ??????."
  • ??? ??? SQL Server 2000 Desktop Engine Service Pack 2 ??????? (Desktop Engine ???)
????? 2000 ???? SQL Desktop ????? Service Pack 2 ??????? ??? ??? ??????? ??????? ????? ?? ????? msi ???????? ?????? ???? ???? ?? Desktop Engine ???????? .

????? ????? ???????? ? SP2 Analysis Services 2.1

??? ????? ?? ??????? ?????? ????? ?????? ?? ????? ????? SP2 ????? ??????? ?? ????????? ?????? ??????? ????????? ???????.

????? ???? ??????? ???????? ?? ?????? 2.0 ?? ?? ?? ????? ????? ????????? ?????? ??? ???? ??? ????????? ???? ???? ?????? ?????? ?? SQL Server 2000 ???? ???? ?????? ???? ??????? ???. ?? ??? ?????? ?? ????? ?????. ??????? ?????? ????????? ?????? ??? ?????? ??? ???? ??? ????? ???? ???????.

??? ????? ?????? ???? ??? ??????? ???????? ????? ???? ??????? ?????? ??????? ???? ???? ????? ??????? ????? ?? ????? ????? ????????? ??????. ???? ????? ????? ?????? ????? ????? ?????? ????? ???? ??????? ?????????, ? ????? ????? ??????? ???????? ?????? ?????? ????????? ????.

????? ????? ????? ?????? ???????? ??? ??????? ????????; ???? ?? ??? ???? ?? ????? ??? ??? ?????? ?????? ????? ????? ????????. ????? ??????? ??? ?????? ????? ?? ??? ?? ?? ??????? ???????? ?????; ??? ?? ??????? ?? ?????? ?? ????? ?????.

??? ??????? ????? ????? ????????? ?????? ????? ????? ?? ?????? ?? ??????? ???????? ??? ????????? ????? ?? ?? ????? ???? ?????? ??? ????? ??????? SP2. ??? ???? ??????? SP2 ???? ??? ??????? ??????? ????? ??????? ???? ??????? ??? ?? ????? ?? ????? ?????? ????? ???? SQL.

?? ??? ?????? ????? ???????? ? ????? ??????? ?? ????? ??????? ?? ????? ?? ??? ?? ?? ????? ??????? SP2 ? ????? SP2 ????????.

?????? ??? ?? ??????? ?? ??? ??????? ?? ????? ???? ??? ?? ???? ????? ??? ??? ??? ????? ??? ???????: ???? ??? ????? ??????? ??? , ???? ??? ?????? ??? ?? ??? ???? ???????? ????? ???? ??????? ?? ?????? Windows? ?? ??????? ??? .

??? SP2 Engine 2.2 ??? ??????

??? ????? ?? ??????? ??? ????? SP2 Desktop Engine ?? ????????? ?????? ??????? ????????? ???????.

?? ?????? ?? ??????? ????? Desktop Engine SP2 ??? ?? ???? ????? ?? ??? ?????? ????? ???????? ? ???????? Analysis Services SP2 ?? ??????????? ???????.

??? ??? ????? ????? Desktop Engine SP2 ?? ????????? ????? ????? ???? ??????? ??? ??? ????? Desktop Engine ???? ?? ??????? ?? sqlrun01.msi. ??? ????? ????? ???? ??????? ??? ???????? ???? ?? ??????? ???????? sqlrun16.msi û sqlrun02.msi ?? ????? Setup.exe ???? ?? ??????? ?? ????????? ?????? ???? ??????? ???????:
??????? ??? ???? ??????? ???.. ???? ?? ???? ?????? ??? ???? ????? ?????? ????? ?? ???? ????? ??????? ?????? ?? ????? ???? Windows Installer ????.
??-
??????? ??????? ???? ????? ?????? ???? Windows Installer ???? ?? ???? ???????? ???? ???? ???? ??? ??????? ??????? ?? ?? ????? ??????? ??????? ????? ??? ?? ????????. ?????? ?????? ?? ???? ???????? ??????? ?????? ??? ????? ????? ?????? ????? ??????? ???????..
?????? ????? Desktop Engine ???? ?? ??????? ???????? sqlrun02.msi-sqlrun16.msi, ??? ????? ???? ??????? ?? ????? ??????? Microsoft.

????? ???? ??????? 3.0

?????? SP2, ???? ????????? ??????? ?????. ???? ???? ??????? ??????, ???????? ??? ?? ?? ?????? SQL Server 2000 ?? ??????? ???? ??? ????? ???? ??????? ???????:
  • ?????? ???? ????? ????????
  • ????? ?????? ?????? ??????
  • ????? ???????
  • ????? ??? ??????
  • ???? ?????????
  • ???? ????? ????????
??????? ??? ??????? ??????? ?????? ???????? ????????.

?????? ???? ?????? ?? ??? ?????. ????? ???? ??????? ???? ??? ???? ???? SQL ???? ??? ???? ????????.

?????? ??? ??? ?????? SP2 ??? ??????? ?? Windows NT 4.0 ???????? ????? ?? ???? ????????? ?? ????? ????? ??????? 259484. ????? ?????? ????? ?? ?????? Microsoft Product Support Services Knowledge Base.

??? ??? ???????
????? ?? SP1

???? ??? ????? ??? ???? ????????? ???? ???????? ????? ???????:

????? SP2 ?? ??? ????? ????? ???????? ???????? ??? ????? ?? ???????? ?? ???????? ????? ???????? ???? ????? ?????? ????????. ????? ??? ????? ?? ???????? ?? ???????? ????? ???????? ?? ???? ??? ?????? ?? SP2. ??? ???? ??????::
  • ????? ??????? ???? ???????? ?????? ?????? ?????? ????? SQL Server 2000 ?? SQL Server 2000 SP1 ????? SQL Server 2000.
  • ????? ??????? ???? ???????? ?????? ?????? ?????? ????? SQL Server 2000 SP2 ????? SQL Server 2000 SP2 ??? ???? ???? SQL Server 2000 SP1 ? ?? ??? ???? SQL Server 2000.
  • ????? ??? ????? ?????? ?????? ????? SQL Server 2000 ?? SQL Server 2000 SP1 ?? ?????? ??? ???? SQL Server 2000 SP2.
  • ????? ??? ????? ?????? ?????? ????? SQL Server 2000 SP2 ?? ?????? ??? ???? SQL Server 2000 ?? SQL Server 2000 SP1.
  • ???? ????? ??? ?? ??? ????? ??? ?????? ?? SQL Server 2000 ?? SQL Server 2000 SP1 ?? ? SQL Server 2000 SP2. ????? SP2 ????? ????? ?????? ???????? ???? ?? ????? ???????? ????? ????????.
??? ????? SP2 ?? ???? ?? ?? ???? ???????? ????? ??????? ??? ??? ?????? ????? ???????? ?????? filegroups ????? ???????? ?? ???????. ?????? ??? ???? ?? ????????? ??? ????? SP2 ?????? ????? ?? ???????? ????? ????????, ???? 3.11 ???? " ????? ??? ?????? ??????."

??? ??? ????? SP2 ??? ????? ?????? ???????? ?? filegroups ???? ?? ??? ???? ??????? ?? ???:
  • ????? ????????? ????? ???????? SP2 ??? ???? ????? ???????? ???????? ???????.
  • ???? ????? ?? ????? ?????? ??? ???? ??????? ??? ??? ??????? ??????? ?? winnt\sqlsp.log.
  • ???? ????? ????? ???????:
    ??? ??????? ???? ?? ???? ?????? filegroups ????? ?? ??? ???? ???????.
???? ?? ????? ??? ??????? ?? ?? ????? ???????? ????? ???????? ???? ????? ???????? ???????? ?? ??? ???????. ??? ???? ????? ???????? ????? ???????? ?? ?? ?? ????? ???????? ???????? ?? ??? ??????? ??? ???? ??????? ??? ??? ????? ???????? ??? ??????? ?? ????? ????? ????? SP2 ??? ??? ?????? ?? SQL Server 2000.

?? ???? ??? ??????? ??? ?????? ??????? ??? ??????? ?????? . ?????? ?????? ??? ?????? ??????? ??? ??????? " ? ???? ???? 4.0 " ??????? ??? ??????."

?????? ??? ???? ?? ????????? ??? ??? ????? ?????? ???????? ???? 3.12 ???? " ????? SP2 ??? ?????? ??? ???? ??????? ?? filegroups." ?????? ?????? ??? ????? ????? SP2? ???? 3.14 ???? " ????? ????? SP2."

?????? ????? ???????? ???? Setup ??? ??????? ??? ????? ???????? ??????? ??? ?????? ???????? ??? ?? ???????. ??? ????? ???????? ?????? ?????? ?? filegroup ??????? ?? ?? ?? ?????? ??????? ????? ??????? ???? ?? ????? ?? ???????? ????? ??????, ??? ?? ???? reapplied ???? ??????? ??? ????? ????? ???????? ????? ???????.

???? ?? ???? ??? ????? ?????? ??? ???? ??????? ?????? ??????? ?????? ??????? ?? ??? ????? ?????? ??? ????? ??? ????? ??? ??????? ??? SP2.

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

?? ???? ????? SQL Server 2000 Service Pack 2 ?? ???. ??? ???? ????? ??????? Microsoft Systems Management Server ?????? SP2 ???????? ??? ?????? ?? ????? ????????? ???? ????? Microsoft Windows NT Server 4.0. ?????? ????? ??? ??????? ??? ????? ???? (???) Smssql2ksp2.pdf ???? ???????? ???????? ?????? ?? ???? SQL Server ?? Systems Management Server. ?? ???? ?????? SQL Server ????? ?????? ????? ??? ????? ????????? ???? ????? Systems Management Server. ????? Sms2kdef.bat ????? ?? ??? ???? ???? ?????? ??????? ????? ?????????? ??? ???? ??????? ??????? ?? ?????? ?????.

?? ???? ??????? ???? ????? ??????? ?????? SP2 Desktop Engine.

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

???? ??? ????? ??? ???? ????????? ???? ???????? ?????? ?????? ????? ????????:

??? ????? SP2 ?????? ????? ???????? ?? Desktop Engine SP2? ????????? ????? ???????? msdb , ? ???? ????? . ????? ???? ??????? ???? ????????? ??? ????? ??????? msdb , ? ????? ????????? ???? ????? ??? ?????? ?? ??????? ?? ??? SP2 ?? SQL Server. ????? ????????? ??? ?????? ??? ???? ????? ????? SQL Server 2000 ??? SP2.

??? ????? prudent ????? ????????? ?????? ???????? ????? ?? ?????? ?? SP2 ??? ????? ????????? ?? ????? ???????? ???? ?? ????? ???????? ????? ????????.

????? ??? ??????? ????? ???????? ????? ??????? 3.2

???? ??? ????? ??? ??? ????? ???????:

??? ????? SP2 ????? ??????? ????? ????????? ????? ???????? ????? ??????? ?????? ???? ???? Microsoft ??????? Services\Data ????? ??? ????? ????????? ??? ?????? C:\Program Files. ??? ???? ?? ?? ????? ??????? ????? ??????? ????? ?? ??? SQL Server ????? ???? ???????? ?? ????? Msmdrep.mdb ?? ????? ?? ?????? Microsoft ??????? Services\bin. ????? ????? ??? ??????? ????? ?????? ????? ?????? ????? Regedit.exe ??????? ??????? ?????? ????? ??? ??????? ?? ??????? ????? ?????? ?????
HKEY_LOCAL_MACHINE\SOFTWARE\OLAP Server
??? ??? ????? ?????????.

???? ?? ????? ?????? ?????? ???? ????? ??? ????? 3

???? ??? ????? ??? ???? ????????? ???? ???????? ?????? ?????? ?????? ????? ?????? ???????:

??? ?? ??? ????? ?????? autogrow ?? ??? ????? ??????? ? msdb ????????? ???? ?? ???? ????? ???????? ??? ????? ???? ???? (KB) ?? ??????? ????? 500. ?????? ??? ?? ??? ???????, ????? ?????? sp_spaceused ????? ??????? ?????? ??????? ?? msdb . ??? ??????? ??? ??????? ?? ????? ???????? ??? ?? 500 ???? ???? ?? ??? ?? ????? ??? ?? ????? ????????. ?????? ??? ???? ?? ?????????, ???? ????? " ???????? " ?? ??? SQL Server ??? ?????? .

??? ?? ?? ????? ???? autogrow ?? ??? ????? ??????? ? msdb ????????? ??? ???? ????? ????? ??? ?????? ???????, ????? ???? ??? ??????.

?? ?????? ?? ??? ?? ?? ????? ??? ?????? ?? SQL Server 2000? ???? SQL Server Enterprise Manager, ???? ??? ?????? ?????? ??? ????? ?????? ????????? ?? ???? ??? ?????. ???? ?? ????? ???? ???????? ????? ??? ????? ???????? .

?? ?????? ?? ??? ?? ?? ????? ??? ?????? ?? Desktop Engine ?? ???? ?????? SQL ??????:
  • sp_helpdb ?????
  • msdb sp_helpdb
?? ??????? ?? ??? ????????, ???? ?? ?? ?????? ???????? ?? ??? 0.

????? ??????? ?????????? 3.4 ??? ????? ?????? ????? SP2

????? ??? ???? ???????? ???????:

????? ????? SP2 ??? ????? ???????. ??? ???? ?? ???? ?????? ??????? ???????? ???? ??????? ??? ????? ??????? ??? ?????? ???????. ???? ????? ??????? ?? ????? ??????? ????.

????? ????? SP2 ??? ????? ????? ????????? ??? ????? ????? ?????? ??????? ?????????? ??? ????? ???? ???????:
  • ?? Microsoft Distributed Transaction Coordinator (MS DTC) ?????? Microsoft Search ? MSSQLServerOLAPService.
  • ????? MSSQLServer ? SQLServerAgent ?? ?????? ??? ????? (MSSQL ?????? NamedInstance $).
  • ????? Microsoft Component Microsoft ???? " ??? ??????? ??? ????? ?????? " ? ?? Integrator ?????? Microsoft COM.
  • ???? ?????????? ??? ???? ???? ??????. ?? ??? ?????? ??????? ????? ??? ?????.
?? ???? ????? ??????? ?? ???? ?????? ????????. ?????? ??? ???? ?? ?????????, ???? ?????? 3.10.

3.5 ????? SP2 ?????? ????? ????????

???? ??? ????? ??? ???? ????????? ???? ???????? Desktop Engine ? ????? ???????:

????? ???????? ????? Setup.bat ?? ???? ?? ??? ???????:
  • ?????? ???? ????? ????? ???? ??????? ????????? ?? SQL2KSP2.exe.
  • ???? ?????? ??? SQL Server 2000 SP2 ??????? ??????.
Setup.bat ???? ???? ???? ????? ???? ?????? ?????? ??? ?????????? ??? ?? ??? ??? ???? ??????? ?????? SQL Server ?? ?????? Windows. ??? ????? ?????? SQL Server ? ??? ????? ?????? ??????? ????? ???? ?????? ???? sa. ??? ????? " ?????? Windows " ? ??? ????? ?????? ??????? ????? ????? ?????? ??? Windows ???????? ???? ????? ???? Windows. ??? ?? ???? ????? ?? ????? ?????? sysadmin ????? ??? ?????? ?? ?????? ?? SQL Server 2000 Desktop Engine ???? ???? ???????? ?? ??? ?????? ?????? ??????.

?????? ??????? ??:
  • ?????? SQL Server 2000 Desktop Engine ?? ??????? ???????? ??? ??????? SP2.
  • ???? SQL ???????? ??? ????? ???????? ????? ?????? ?????????? ??????? ??????.
  • ???? ???? ???? ??? ?????? ??? ??? ?? ????? ??????? ?????? ?????? ????? ?????? ????? ?? ???? ???? ????? ?????? ???? sa. ??? ?? sa ????? ?????????? ????? ?? ?????? ??????? ???? ?? SQL Server Desktop Engine ?? ????? ?????? ?????? ?????? ????? ??? ??????; ????? ??????? ?????? ?? ?????? ??? ???? ???? sa ?? ???????? " ?????? Windows. ?????? ?????? ??? ??? ??????? ???? ???? ???? ??? ???????? ?????? ?? ??? ??????.
  • ???? ???? ???? ??? ??? ?? ????? ???????? ?? filegroups ?? ??? ???? ???????. ??? ?? ?? ??? ????? ???????? ?? filegroups ????? ????? ?? ???????? ????? ???????? ??? ??? ??????? ????? ???:
    1. ?? ?????? ????? ???????, ??? ??? ???????? ??????? ?? ??? ???????.
    2. ?????? ????? SP2 ?????? ?? ????? SP2 ?? ??? ???? ??? ????? ??? ???????? ???????.
    ??????? ??????? ?????? ??? ???????? ??? ????? SP2 ??? ????? ?????? ??? ???? ??????? ?? filegroups ???? ????? ????? ?? ???????? ????? ????????. ?????? ??????? ???? SP2 ?? ????? 3.12 ?????? ??? ????? ?????? ???? ??????? ?? Filegroups.
???? ??? ????????

??? ??????? ???? ?????? ??? ?????? ??? ????????? ??????? ?? ??? ???????. ????????? ???? ???? ??:
  • ??????? ????????? ?? ?????? ????? ?????? ????? (??? ???????? ???) ????? ?? ????? ??????? ??? ??? ????? ????????? ???? ???? ?????? Microsoft Windows 98 ?? Windows Millennium Edition. ???? ???? ?????? ?????? ???? ???? ????? ????? ???? sa . ?????? ??????? ??? ??? ?????? ???? ????? ???? ????? ???? ???? ????? ???? sa . ??? ??? ???? ???? ?????? ?????? ?????? ??????? ??????? ? ?? ????? ???? ??????.
  • ??????? ????????? ?? " ?????? Windows ??? ????? ????????? ???? ???? ?????? Windows NT 4.0 ?? Windows 2000. ?????? ???? ?????? ??????? ??? ??? ?????? Windows ?? ??? ?????? ????? ????? ???? ???? sa ????? ???? ??? ?????.
??? ????? ??? ???????? ?? ???? ?????? ?????? ????? ???? sa , ???? ??? ??? ??????? ?? ???? ??? ?????????. ??? ??? ?????? ????? SQL Server ?? ??????? ?????? ????? ?????? ????? ???????? ?????? Windows ???, ??? ???? ??????? ??? ?? ???? ?????? ??? ??????? ??? ??? ????? ??? ???????? ??? ??????? ?????? Windows ????????? ?????? ??????? ???????? ?????? ???? SQL. ?????? ????????? ?? ?????? ??????? ???????? ???? ?????? ??????? ??? ??? ?????? ???? ?????? ?????? ?????? sa ?? ?????? ??? ??????? ??? ???? ?? ??????? ?? ??????? ???? ?????? ???????.

??? ?????? ??????? ??? ?? ????????? ?? ????? ?? ????? Sqlsp.log ?? ???? Windows ?? ????????? ?? ?????? ????. ??? ??? ????? ?????? ??????, ??? ????? ??????? ?????? ??? ?? ??? ?????.

????? SP2 ????? ??????? 3.6

???? ??? ????? ??? ??? ????? ???????:

?????? SP2 ????? ??????? ????? Setup.exe ?? ?? ?? ??????? ???????:
  • ?????? ?????? Msolap\Install ?? ?????? ???? ????? ??? ??? SP2 ????? ??????? ????????? ?? SQL2KASP2.exe.
  • ?????? Msolap\Install ??? ????? ??????? SP2.
Setup.exe ???? ???? ???? ????? ?????? ???????? ????? ?? ?????? ???????.

3.7 ????? SP2 Desktop Engine

???? ??? ????? ??? ??? Desktop Engine:

???? ????? ?? SQL Server 2000 Desktop Engine (????? ????? MSDE 2000) ??????? ???????? ????? ?????? ?????? ??????? ??????? ?????? Desktop Engine. ??? ??? ???? ?????? ????? ?????? Desktop Engine, ???? ????? ???????? ?????? ??? ??????? ??? ????? ????? Desktop Engine ??????? ?????? ??? ?????????. ?????? ??? ???? ?? ?????????? ???? ????? Distributing " SQL Server 2000 Desktop Engine " ?? ??? SQL Server ??? ?????? .

??? ????? ???? ???? ?? Desktop Engine ?? ??????? ??????:
  • SQL Server 2000 Service Pack 2 ??????? : ????? ???????? ????? ??????? ???????? ?????? ????? ???????? Desktop Engine. ???? ?????? ???? ?????? ?????? ?????? Desktop Engine ?? 16. ?? ????? ??? ????? ??????? ????? ??????? ?? ????? msi ???????? ?????? ???? ???? ?? Desktop Engine.
  • SQL2KdeskSP2.exe : ????? ??? ????? ?????? ?? ???? ???? ?? ????? ??? ?????? ???? ?? ??????? ?????? sqlrun01.msi. ?? ???? ??????? ??????? ?????? ????? Desktop Engine ???? ?? ??????? ???????? ?? ?? ????? msi ?????? (sqlrun02.msi ???? sqlrun16.msi). ?? ????? ????? ????? ??????? ?? ????? msi ???????? ?????? ???? ???? ?? Desktop Engine. ?????? ??? ???? ?? ?????????, ???? 2.2 ???? " ??? SP2 Engine ??? ??????."

    ??? ????? ????? ????? ???.msi ???? ?? ???????? ?????? ???? ?? MSDE ? ?????? ?????? ????????? ??? ????? ????? ????? Q311762. ????? ?????? ????? ?? ?????? Microsoft Product Support Services Knowledge Base.
  • ????? ??? ????? ??????? ??? ???? ????????? Universal MSDN ??? 2000 ???? SQL Desktop ????? Service Pack 2 ??????? : Microsoft Product Support. ?????? ?? ?? ??????? ???????? ?????? ????? ???????? Desktop Engine. ???????? ??? ???? ????? ???.msi ????? ??????? ???????? ???????? ?????? ???? ???? ?? Desktop Engine. ??? ????? ??? ????? ??????? ???????? ????? ?????? ?????? ????????? ???? ????? Desktop Engine. ?????? ??? ???? ?? ?????????, ???? Distributing " SQL ????????? " ?? ??? SQL Server ??? ?????? Server.

    2000 ???? SQL Desktop ????? Service Pack 2 ??????? ?????? ?? ????? ???? ??????? ?? SQL Server ?? ????? ???????.
??????? ?? ??? ????? ????? ????? ?? Desktop Engine ????? ????????? ??? ?? ?? ????????? ?????? ?? ???????? SP2 ???? ?????????? ?? ????? ????? ??????? ?? ?????? (??? ???? ??????? ??????) ???? ????? ????? ???????. ??? ????? Desktop Engine, ??? ?? ??? ????? ???? ??????? Desktop Engine ??? ?? ????? Desktop Engine.

?????????

?????? Setup.exe ?????? ???? ??????? ???. Setup.exe ?? SP2 Desktop Engine ???? ?????? ????? ??? SQL Server 2000 Desktop ????? Setup.exe ?????? ?? SQL Server 2000. ???? ?????? ??? ?????? ???????? ?? Setup.exe ??:
  • ??????? " SQL Server Desktop ????? ????? " ?? SQL Server 2000 ????? ??????? 2000.
  • ??????? ??????? ?? ????? Readme.txt SQL Server 2000 ??????:
    • 3.1.4
    • 3.1.23
    • 3.1.28
    • 3.1.29
    • 3.1.30
????? ????? ????? ?? ???? ????? ?????? ?? ?????? ???? ????? ?? ??? ?????. ????? ?????? ??????? Desktop Engine ??????? ??????? ????????? ?????? Desktop Engine (??? ???? ??????? ?????? ????? ??????? ?? ?????? ????????). ????? ??? ????? Desktop Engine ?? ??? ????? ??? ?? ??????? ?????? ???????:
  • ?? ??????? ?????? ?? Desktop Engine ??? ????? ?? ??? ?????.
  • ??? ????? ????? ??????? ????? ?? ?? ??? ????? SP2? ??? ?? ???? ????? ???? ??????? ??? ????? ??????? SQL2KSP2. ??? ??? ?????? ??????? ??????? (ISV) ????? ??? ????? ?????? Desktop Engine ?? ???? ??????? ????? ??? ?????? ??? ?? ???? ????? ???? ??????? ???????? ?????? ??? ????? VolumeLabel ?? ?????? ??????? ?? Windows ???? ???? (*.MSI).
??? ?? ????? Desktop Engine ?? ??? ????? ?? ?? ?????? ???? ????? ???? ????, ????? ??? ?????? ?????? MSDE ?? 2000 ???? SQL ??? ?????? ????? Service Pack 2 ??????? ??? ???? ??????? ??????? ?? ??? ?????? ???? ??????? ?????? Setup.exe.

??? ????? ??? ????? Service Pack 2 ?????? ?? ????? ???????, ????? ??? ????? Windows Installer ??? ????? 2.0.2600.0 ?? ????. ?????? ??? ??????? ???? ??? ????? ????? ?????????.

?????? Windows Installer:
  1. ???? ?????? ?? ?????? ?????? ??????? ??????? ??????.
  2. ????? InstMsi20.exe.
  3. ???? ???? ???? ?? ??????? ?????? ?? ???? ????.
Setup.exe ??? ?????? ?? ?? ?? ???????? ????????:
  • ??????? ?? ?????? ???? ????? ????? ???? ??????? ????????? ?? SQL2KDeskSP2.exe ?????? MSDE.
  • ?????? ??? ????? ?????? ?? ?????? ???? ??????? ???? ??? ???? ?????? ?????? MSDE ?? SQL Server 2000 SP2 ???????.
????? ??????? ????? ??? ??? ?????? Desktop Engine ?? ???? ????? ??? ???????? . ???? ????? ???????? ?????? ??? ???? ?? ????????? ??? ????? Desktop Engine.

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

????? ?????? ????? ??????? ?????? ?? ???? ??????? ??? ????????? ????? ?????? ?? MSDE (01-16) ?????? ?? ????? ??????? SQL Server 2000. ?????? ????? MSDE? ??? ????? ??????? ???????? ?????? ??. ??? ???? ??????? ?????? ???? ????? ???? ?? SqlRun03.msi, ???? ??????? SQLRun03.msp.

?????? ??? ???? ??? ??????? ?????? ???? ?? ????? ??? ??????? ??????? ??????? ?? ???? ??????? ??? ???? ??????? ???? ???: SQLRun01.msp. ????? 15 ????? ?????? ?????? ??? ??? SQL Server 2000 Service Pack 2 ???????.

?????? Setup.exe ?? ??? ??????? ?????? ???? ????????? ????? ????? MSDE. ??? ??? ???? ???? ??????? ?? ?? ???????? ?????? ??????? ????? Desktop Engine? ????? ????? ??????? Setup.exe ??????? ???????? ?? ?????? & ‎ /p & ‎. ??? ???? ??????::
Setup /p SQLRun03.msp
??? ?? ??? ???? ???? ????? ?? ?? ????????, ???? SQLRUN ??? ???? /p . The SQLRUN ???? ??????? Setup.exe ??????? ???? ????????? ?????? ????. ??? ??? ????? ??? ?? ??????? ?????? ???????:
  • All of the .msp files are located in a folder named Setup directly under the folder containing Setup.exe. This requires the SQL Server 2000 Service Pack 2 CD.
  • When the instance to be upgraded is not the default instance, its instance name is specified with the INSTANCENAME variable.
???? ????? ?????? ??? ???? ??????? ???? ????? Setup.exe ????? ??? ???? ???? MyInstance:
Setup /p SQLRUN INSTANCENAME=MyInstance
??? ???? ????? ??? ?????? ?? ???.ini. ?????? ??? ???? ?? ?????????? ???? ????? ????? " ??? ?????? Setup.exe " ?? ??? SQL Server ??? ?????? ?????.

?????? ??? ?????? ??? ?? ????? ?????? ???????? ??? ??? ??????.

??? ????? ?? ???? ?????? ??? ???? ????????? ??????, ????? ????? ????? ??????.

?????? ??? ??????? setup.exe ?????? MSDE SP2 ??? ??????? ???? ?????? Windows 98 ?? Windows Millennium Edition? ???? ??????? ??? ??????? UPGRADEUSER ?????? ????? ???? ???? ???? ????? ?? ??? ?????? ????? ????? ?????? sysadmin. ?????? ??? ??????? ??? UPGRADEUSER , ???? ?????? 3.1.23 ?? ????? Readme.txt SQL Server 2000 ??????.
redistributing ???? ??????

???? ??? ???? ????? ??????? ????????? (ISVs) ????? ???? ????? ????? ???? ??????? ??? ???????:
  1. ????? ???? ??????? ??? ???? ?? Desktop Engine ??????? ??? ?????? ?? ??? ?????? ????????.
  2. ????? ???? ??????? ?????? ?? ????? ?????????? ???????? ??? ??????? ??????? ????????.
  3. ????? ??????? ?????? ????? ?? ??? ???????.
?????? ??? ??????? ??? ????? ????? ??? ??????? ???? ????? ??????? Windows ?? ????? Software Development Kit (SDK), ????? ???? ????? ?? Microsoft Platform SDK Web site.

?????? ?? ?? redistribute ???? ????? ?? SP2.

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

??? ?????, 2000 ???? SQL Desktop ????? Service Pack 2 ??????? ????? ??????? ?????? ??????? ??? ?? \MSDE. ?????? ??? ????? ????? ?????? ???? ???????? " SQL Server Desktop ????? ??? Modules " ?? ??? SQL Server ??? ?????? .

????? ????? ????? 3.8

????? ??? ???? ???????? ???????:

??? ?????? ?????? ??????? " ? ???? ?? ?????? ??? ????? ????? ??????. ??? ????? ????? ?????? (?? ??? ?????? ?????? ??? ??? ????? ????? ?? ???????) ? ?????? ????? ??????? ?? ???? ?????? ?????? ?? ??????? ? Microsoft Search MSSQLServer MS DTC MSSQLServerOLAPService, ? SQLServerAgent, ?? ??????? ??????-???? ??? ????. ????? ??? ??????? ????? ????? ???????? ???????? ?????? msdb.

??? ????? ??????? 3.9

????? ??? ???? ???????? ???????:

??? ????? ??????? ????? ??? ????? ??????? ???? ???????.

????? 3.10 ??? ???? ?????

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

?????? ???? ??????? ??? ??? ???? ???:
  • ????? ???? ??????? ??? ?? ?????? ???? ???? ?????? ????? ??? ?????? ??????? ??? ??????? ???????. ????? ??? ?????? ????? ???? ??????? ??? ???? ??? ?????? ????? ?????.
  • ?? ???? ?????? " ????? " ? ???? ??? ?? ?????? ??????? ???? ???? ????????.
  • ???????? ?????? ?? ?????? ?????? ????? ???????. ??? ???? ??? ??? ????? ????? ??????? ??? ?? ???? ?? ??????.
????? SP2 2000 ???? SQL ?????? ?? ????? ????? ??????? ??? ?????? ????? ?????. ?????? ??? ??????? ???? ???? ??? ????????? ????? SQL Server 2000 SP2 ??????? ?? ??????? ???????.

??? ??? ???? ?????? ???? (???? clustered) ??????? ?? SQL Server ??? ???? ?????, ???? ????? ????? ????? ??????? ?? ???? ???????? ??? ???? ?????, ?? ?? ???? SQL Server 2000 SP2. ?????? ??? ???? ?? ????????? ??? ???????? ???? " How to ??????? ?? ???? ???????? ??? ???? ???? ??????? ?? SQL Server 2000 (???????) " ?? ??? SQL Server ??? ??????

??? ??? ????? ??? ????? ????? ???? ?? ?????? ????? ?????, ???:
  • ????? ????? ???? ?? ?????? ????? ?????. ?????? ??? ??????? ??? ????? ????? ????, ???? " How to ??????? ?? ??? ?????? ????? ????? ?? ????????? 1 " ?? ??? SQL Server ??? ?????? .
  • ????? ?????? SQL Server 2000 ??????? ?????? ?????? ?????? ??? ?????? ????? ?????.
  • ???? ?????? ??????? SQL Server 2000 SP2.

????? 3.11 ??? ?????? ??????

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

??? ???? ??????? ??? ??? ?????? ?????? ???????? ???:
  1. ???? (?? ??? ??????? ?? ??????)
  2. Publisher
  3. ?????
???? ? Publisher ?? ???? ???????, ????? ?? ????? ???????? ??? ????????? ??? ??? ?????? ???? ??? ????? ?? ??? ?????.

?? ????? ???????? ??? ??? ??????? ????? ???????? ??????? ??? ?????? ??????? ??????. ????????? ?????? ????? ??????? ??? ??? ????????? ?????? ????? ???????? ???? ?? ?????. ??? ???? ?? ?????? ???? ????? ????? ???? ????? ???????? ????? ?? ??????? ????? ?????? ????? ????? ??????? ???? ?????.

?? ?? ???? ?????? ??? ????? ???? ???????? ???????? ?? ???????? ????? ?????? ??????; ????, ?????? ????? ?????? ????? ???????? ??? ???????? ???? ?????? ?????? ?? SQL Server 2000 ? ???? ??????? ???. ??? ????? ??????????? ?? ??? ?? ???? 5.3.7 " ??????? ????? ???????? ???????? ?? ??????? ?????? ?? SQL Server."

????? SP2 ?????? ????? ????? ?????? ???????? ???? ?? ????? ???????? ????? ????????. ??? ???? ?? ?? ????? ???????? ???? ?? ????? ???????? ????? ???????? ??? ???? ??????? ?? ?????? SP2 ??? ??? ????? ??? ????? ????? ??????? ?? ????? ????? ????? SP2. ?????? ??? ???? ?? ????????? ??? ??? ????? ?????? ???????? ???? 3.12 ???? " ????? SP2 ??? ?????? ??? ???? ??????? ?? filegroups." ?????? ?????? ??? ????? ????? SP2? ???? 3.14 ???? "????? ????? SP2."

????? ??????? ????? ?????? ??? ???? ?????? ??? ??????? SP2 ?? ???? ???? ??? ???? ?????? ???????? ?????? ???? ?????? ????? ????????. ??? ????? SP2 ????? ?? ????? ?????? ????? ???? ????? ????????? ???????? ?????? ?? ?? ???????? ????? ?????? ?????. ???? ???????? ?? ???? ???? ??? ?? ????? ?????? ????? ???????? ?? ???? SP2 ???? ????? ????? ??? ??? ??????? ????? ????????.

????? 3.12 SP2 ??? ????? ???????? ??? ???? ??????? ?? filegroups

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

?????? ??????? ??? ????? ???????? ??? ???? ??????? ?? filegroups ??????? ??? ???? ??????? ???????:
??? ??????? ???? ?? ???? ?????? filegroups ????? ?? ??? ???? ???????.
????? ???? ???? ?? ????? ??? ??????? ??????? ???????. ??? ???? ??? ???? ????? ???????? ????? ???????? ?? ?? ?? ????? ???????? ???????? ?? ??? ??????? ??? ???? ??????? ??? ??? ????? ???????? ??? ??????? ?? ????? ????? ????? SP2 ??? ??? ?????? ?? SQL Server 2000.

?? ???? ??? ??????? ??? ?????? ??????? ??? ??????? ?????? . ?????? ?????? ??? ?????? ??????? ??? ??????? " ? ???? ???? ??????? ??? ??????? 4.0.

?????? ????? ???????? ???? Setup ??? ??????? ??? ????? ??? ???? ??????? ?????? ???????? ??? ?? ???????. ??? ?????? ?????? ?? filegroup ?????? ?? ?? ?? ?????? ??????? ????? ???????? ???? ??? reapplied ???? ???????. ?????? ??? ???? ?? ????????? ??? ?????? ??? ??? ????? ?????? ??? ????????? ???? ????? " Attaching ? Detaching ???????? " ?? ??? SQL Server ??? ?????? , ??????? ??? ???? ?? ????????? ??? ????? ??????? ????? ? ???? ? " ???? Troubleshooting " ?? ??? SQL Server ??? ?????? ????? ????????.

?????? SP2 ??? ????? ?????? ??????? ???:
  1. ??? ????? ?????? ??????? ??? ??????? ???????? ????? ALTER DATABASE ??? ???:
    ALTER DATABASE ????? ????????
    SET READ_WRITE 
  2. ??? ?????? 2 ?? ??? ???? ????? ???????? ??????? ???.
  3. ??? ????? (?? ?????) ???? ???????.
  4. ??? ??? ?????? ??? ????? ???????? ??????? ??? ??? ???? ???????? ????? ALTER DATABASE ??? ???:
    ALTER DATABASE ????? ????????
    SET READ_ONLY 
?????? SP2 ??? filegroup ??????? ???:
  1. ??? filegroup ??????? ??? ??????? ???????? ????? ALTER DATABASE ??? ???:
    ALTER DATABASE ????? ????????
    MODIFY FILEGROUP filegroup_name READWRITE 
  2. ??? ?????? 1 ?? ??? ???? filegroups ??????? ???.
  3. ??? ????? (?? ?????) ???? ???????.
  4. ??? filegroup ??????? ??? ??? ???? ???????? ????? ALTER DATABASE ??? ???:
    ALTER DATABASE ????? ????????
    MODIFY FILEGROUP filegroup_name
    READONLY 
?????? ?????? ??? DATABASE ALTER, ???? ????? ?????? " DATABASE ALTER " ?? ??? SQL Server ??? ?????? . ?????? ?????? ??? ????? ????? SP2? ???? 3.14 ???? " ????? ????? SP2."

????? ????? SP2 3.13

???? ??? ????? ??? ???? ???????? ???????? ????? ???????:

???? ?????? ??? ????? ?? ??? SP2 ?? SQL Server 2000 ????????? ??? ???? ???? ???????? ?? ????? ???????? ???????? msdb , ? ???? ??? ?? ????? SP2. ?????? ??? ???? ?? ?????????, ???? ?????? 3. " ????? ??? ??????? ????? ???????? SQL Server."

?????? If ?? ?? ?? ????? ???????? ???????? ?? ????? ???????? ???? ????? ?????.
  1. ?????? ?????: ???? ??? ?????? ?????? ??? ?????? ????? ???????? ?????? ???? ?? SQL Server Enterprise Manager? ????? ?????? SQL Server ?? ?? ???? ??? ????? ????? Subscribers , ?? ????? .
  2. ??? ????? ??????? ????? ???????? ????? .
  3. ???? ???? ???????? ??? ?? ????? ???????? ???? ??? ???????? ?? ????? ????????. ????? ??? ????? ????? ???????.
???? ??? ??????? ?????? ??? ??????? ??-SP2 ?? SQL Server:
  1. ??? ???? ????? ???????? ????????. ?????? ??? ???? ?? ?????????, ???? " How to ????? ?? ??? ????? ?????? (Enterprise Manager) " ?? ??? SQL Server ??? ?????? .
  2. ????? ????? SQL Server. ?? ???? ??????? ???? ????? ??????? ??? ????? / ????? ??????? " ? ??? ?? ??? ?????? ?? SQL Server ???? ???? ?? ????? ?????.
  3. ????? SQL Server 2000 ?? ????? ??????? ?? ???? ??? ?? ????? ????? SQL Server.
  4. ??????? ???????? ????? ??????, ????? msdb, ?? ????? ????????? ?????? ???? ?? ?????? ??? ????? SP2. ??? ???????? ????? ??? ????? ?????? ?? ???? ?? ????? ???? ?? ?????? ?????? ??????????.
  5. ????? ?? ????? ???????? ???????? ???? ?? ??????? ??? ????? ????????? ?????? ?? ????? ???????? ???????.
  6. ????? ????? ???????? ??? ??? ?????.

    ??????? ??? ??? ??? ????? ?? ??? SP2 ?? SQL Server? ??? ????? ???? ????????? ??? ???????? ????? ??????, ????? msdb, ??? ????? SP2.

????? ????? 3.14 SP2

????? ??? ???? ???????? ???????:

?? ??????? ???????, ????? ??????? ????? SQL Server 2000 SP2:
  • ??? ????? ?????? ????? SQL Server 2000 ??? ????? ?? ????? SP2.
  • ????? ??? ??? ??????? ????? ???????? ?? filegroups ???? ????? ????? ?? ???????? ????? ???????? ????? ?? ??????? ??? ????? ??????? ?????? ?? ???? ???????.
?????? ????? SP2? ???? ??????? ?? ???? 3.0 " ????? ???? ??????."

?????? ??????? ??? ??????? 4.0

???? ????? SP2 ?????? ????? ???????? ??? ???? ?? SQL Server 2000 ???? ???? ??? ??????? ?? ????? ??? ???????. ????? ??? ??????? ???? ???? ????????? ?????? setups SP2 ????? ISS CD-ROM SP2 ?????? ????? ????????. ??? ??????? ?? ???????? ?? ?????? ????? ??? ????? ??????? ??? ???? ????????? ????? ?????? ?? ????????? ??????:
  • sql2kdef.iss ?? ??? ?????? ??????? ??? ??????? ??????? ?????? SP2 ?????? ????? ???????? ??? ???? ??????? ?? SQL Server 2000 ????? ???? ??????? Windows 2000 ?? Windows NT 4.0. ??? ???? ??????? ???????? ??? Sql2kdef.bat.
  • sql2knm.iss ?? ??? ??????? ??????? ?????? SP2 ?????? ????? ???????? ??? ???? ???? ?? SQL Server 2000 ????? ???? ??????? Windows 2000 ?? Windows NT 4.0. ??? ????? ??? ?????? ?? ????? ISS ?????? ?????? ???? ??? ?????.
  • sql2ktls.iss ?? ??? ??????? ??????? ?????? SP2 ?????? ????? ???????? ??? ????? ??????-???. ???? ??????? ??? ????? ?? ??? ??????? ???? ?? ???????.
  • sql2k9x.iss ?? ??? ??????? ??????? ?????? SP2 ?????? ????? ???????? ??? ??????? ????? ???? ??????? Windows 98 ?? Windows Millennium Edition. ?????? ??? ???? ????? ?????? ???? ??? ????? ??? ??????.
  • sql2kcli.iss ?? ??? ??????? ??????? ?????? SP2 ?????? ????? ???????? ??? ????? ?????? ???? ??? ??????? ?????? ???? ??????? Windows 95.
  • msolap.iss ?? ??? ??????? ???? ????? ????? ???????? ?? ??? ????? ?????? ????? ??? ????? ?? SP2 ????? ???????.
??? ??????? ?????? ?? ?? ????? ??? ???? ??????? ?? filegroups, ????? ????? ??? ????? ?? ?????? ??? ????? ??? ????????? ?? ??? ??????? ?????? ??????? ??? ???????. ??? ???? ????? ???????? ????? ???????? ?? ?? ?? ????? ???????? ???????? ?? ??? ??????? ??? ???? ??????? ??? ??? ????? ???????? ??? ??????? ?? ????? ????? ????? SP2 ??? ??? ?????? ?? SQL Server 2000. ?????? ??? ???? ?? ????????? ??? ??? ????? ?????? ???????? ???? 3.12 ???? " ????? SP2 ??? ?????? ??? ???? ??????? ?? filegroups." ?????? ?????? ??? ????? ????? SP2? ???? 3.14 ???? " ????? ????? SP2 ."

4.1 redistributing Data Access Components SP2

????? ??? ????? ????????? ?????? ?? Sqlredis.exe, ? ????? ?? Redist.txt ???? ??????? ???. ??? ??????? ?? ?? SP2 ?????? ????? ????????. ???? ???????? ??? ????? Sqlredis.exe, ????:
  1. ????? ?? Mdac_typ.exe ?? Microsoft Data Access Components (MDAC) 2.62. ??? ?????? ?? ???????? ???????? 2.62 MDAC ?????????? ?? ???? ????? ???????? ???? ???? SQL Server Desktop Engine ? ?? ???? ??????? ???.
  2. ???? Microsoft Jet ODBC ?????? ?????? ?????.
???? ???? ?? redistribute ????? Sqlredis.exe ??? ???? ? ???? ????? ?? ????? Redist.txt ????? ???? ?????? ???.

??????? ????? 5.0

???? ??? ?????? ??????? ???? ?? ???? ????? ??????? ??????? ???? ?????? ??? ????? ???? ??????? ???. ??? ??????? ????? ??? ????? ???? ??????? ??? SQL Server 2000 ?? SQL Server 2000 SP1 ??? ??? ????? ?? ????????? ??????? ?? ???? ??????? ???.

?? ??? ????? ????? ????? ??????? ?????? ?????? ??????? ?? ??? ????? ??? ?????? ??????? ??? Desktop Engine.

??????? ?????? Desktop Engine ??????? 5.1

?????? ??????? ????? ??? ???? SQL Server 2000 ???? ?? ????? SP2 ?????? ????? ???????? ?? ??????? Desktop Engine ??????? ???? ?? ????? SP2 Desktop Engine.

????? 5.1.1 ????? ???? Desktop Engine

??????? ?? SP1

???? ??? ????????? ??? ????? ???? ????? ?? Desktop Engine ??? ????? SP2.
  1. ?? ?????? \Program Files\Microsoft Server\80\Tools\Binn\Resources\1033 SQL ????? ??????? ??????? ??? *.rdl:
    • semnt.rll
    • sqlsvc.rll
  2. ?? ?????? \Program Files\Microsoft Server\80\Tools\Binn SQL ????? ??????? ??????? ??? *.dld:
    • semnt.dll
    • sqlsvc.dll
    • sqlresld.dll
  3. ????? ????? Desktop ??? SP2.
  4. ????? ????? ??????? ?? ?????? \Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 semnt.rdl ? sqlsvc.rdl ??? *.rll.
  5. ????? ????? semnt.dld, sqlsvc.dld, sqlresld.dld ??????? ?? ?????? \Program Files\Microsoft SQL Server\80\Tools\Binn ??? *.dll.
???? ?????? ??????? ?????? ?? Desktop Engine SP2.

??????? ???? ???????? ?? ?????????? ?? ??????? 5.1.2 ?? SP2 ?????? ????? ????????

??????? ?? SP1

????? Windows 2000 ??? ??? ?????? SP2 ?????? ????? ???????? ??? ???? ???? ?????? ???? ??????? Windows NT 4.0 ?? Windows 98 ??? ????? ???? ??? Windows 2000? ?????? ??? ????? ??????. ????? ?????? ??? ?????? ????? ???? ??????? ?? ?????????? ?? ???????. ??? ??? ?????? ???? ??????? ?? ?????????, ?? ??????? ?? ????? ?????? SQL Server? ??????? ??? ????? ????? Sqlredis.exe ???? ???? ?? SP2 ??? ????? ??????? ??? Windows 2000. ?????? ??? ???? ?? ????????? ??? ????? Sqlredis.exe, ???? 4.1 ???? "redistributing SP2 Data Access Components."

??? ???? ?????? ?????? ????? Sqlredis.exe ??? ????? ????????? ??????? ?? ??? ???????? ???? ??? ????? ????? ?????? ????? ??? ???? ???????? ?? ?????????? ?? ???????.

????? ????? 5.1.3 ???????

??????? ?? SP1

??? ????? ????? ???????. ????? ??????? ????? ??????? ????? ??? SQL Server 2000 ?? ?? ??? ????? ????? ???? ??? ??????? ?? SQL Server ??????? 7.0. ???????? ??? ???? ????? ????? ??????? ??? SQL Server 2000 ???? ????.

????? ??????? ???? ?? ??? ???? ??? ????????? ???????? ????? ???????.

????? ????? ??????? ??? ????? ?????? ?? ???? ????????? ??? ?????? ???? ????. ????? ??? ????????? ??????? ???? ????? ????? ???? ?????? ????? ???? ????????? ??? ????? ??????? ?????? ??.

????? ???? ????? 5.1.4 ???????

??????? ?? SP1

??? ??? ????? ????? ???? ????? ????? ??? ???? ??????? ???.

????? ??????? ???? ??????? / ???????

?? ????? ??????? ???? ????? ????? ????? ???????? ???????? (CPUs) ???? ??????? ?????? ?????? ??????? ?????? ????? / ????? ?????. ??? ??????? ????? ??????? ??? ????????? ?? ?????? ???? ????? . ?????? ??? ???? ?? ?????????, ???? 298402 ?? Microsoft Product Support Services Knowledge Base.

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

?? ???? ??????? ???? ????? ????? ????? ????? ???????? ?? (VIA) ???? ????????? SQL Server ?? ?????? ?????? ????? ??? ??????? ?? ?????? ?? ????????? ????? ???????. ??? ??????? ????? ??????? ??? ????????? ?? ?????? ???? ????? . ?????? ??? ???? ?? ?????????, ???? 299641 ?? Microsoft Product Support Services Knowledge Base.

???? ???? SQL 5.1.5 ?????? ??????? ??????

??????? ?? SP2

SQL Server ???? ?????? History ???? ??????? ???? Windows ??? ?? ???? ?? ?? ????? ??????. ????? ??? ????????? ????????? ?????? ????? ???? ?????? ???????? " ? ??? ???? ?????? ???????? ???????? ??????? ????? ???????? ??????? ????? ????? ????????.

????? 5.1.6 ????? ??? ??????

??????? ?? SP2

???? ?????? ??? ??? ??? ??? ?? ????? ??????? 355069 ??? ????? ?? ??????? 306467, ????? ????? Microsoft SQL Server 2000 ??? ???? ????? ?????????? ????? ??? ?????? ????? ??????? ????????. ??? ???????? ??? ????? ??? ???????, ????? ???? ??????? ??? ?? ???? ???? ??????? ???????? ??? ?? re-created. ?????? ??? ???? ?? ?????????, ???? 306467 ?? Microsoft Product Support Services Knowledge Base.

??????? ????? ??????? 5.2

????? ????????? ????? ??????? ?? SP2:
  • ????? ???????.
  • ?????? ????? ???? ??????? ????? ???????.
  • ????? ????? ???????? ??????? ?? ?????? ??????.
  • ?????? ??? ????? ????? ??????? ??? ??????? ?? ??????? ??????? ??????.
????? 5.2.1 ???????

??????? ?? SP1

?????? ?????? ??? ????? ??? ????? ??? ???? ????? ???? ????? ??? SP1 ?? ????? ???? ???? on it, ??? ??????? ???? ?????? ???? ???? ?????? ?????? ?????? ??? ?????? ????? ??? ?????? ??????. ?? ???? ???????? ???? ???? ????? ???????? Administrators OLAP ??? ?????? ?????? ????? ?????? ?????? ??????.

???????? ??? ???? ??? ?? ???? ??? ??? ?????? ?????? SP1 ????? ??? it, RADIUS ?????? ????? ??? SP1 ????? ??? ??? ??? ????? ?? ????? ?? ????? ??????? ???????.

????? ???? ??????? ????? ??????? 5.2.2 ??????

??????? ?? SP1

SP1 ????? ??????? ?????????? ?????? ????????? ??????? ?? ????? ??????? ??????? ?????? ???????:
  • PTSLite.exe
  • PTSFull.exe
???? ??? ??????? ?? ?????? \msolap\install\PTS ?? ?????? ????? SP2.

?????? ????? PTSFull.exe MDAC; ?? PTSLite.exe.

?????? ??? ????? ??????? ?????? ?????? ?? ????????? ?? ??? ??? ?? ?? ????? ??????? ?????? ???? ?? ????? ??? ??????? ????? ??????? ? Microsoft Office XP.

?? ???????? ??? ??????? ????? ??????? ?? Office XP? ????? ?????? ????.

????? ??? 5.2.3 ????? ???????? ??????? ?? ?????? ??????

??????? ?? SP1

????? ??????? ?? SP1 ???? ?????? ????? ????? ????? ???????? ??? ?????? ??????. ?????? ??? ???? ?? ????????? ??? ????? ???????? ???? ??? ??? ?????? ???? ?????? ??????? " Third ???? Data Mining ???????? " ? ?? ?? OLE DB ?? Data Mining Resource Kit , ????? ????? ????? ?? ??? ??? ?????? ???? ???? ??? ?? Microsoft ???????? Data Access and Storage Development Center.

5.2.4 ????? ????? ??????? ??? ??????? ?? ??????? ??????? ??????

??????? ?? SP1

??? ??? ?????? SQL Server 2000 Analysis Services ??? ??????? ????? ??? ????? ????? ?????? ??? SQL Server 2000 SP1 ?? Office XP ?? ???? ????? ???? ??? ?????? ???? ???? ???? ?? ??? ????? ??????? ?????? ??? ????? SP1 ????? ???????.

??????? 5.3 ????? ????????

????? ????????? ????? ???????? ?? SP2:
  • ????? ????????? ??? ?????? ????????? ???? ????
  • ??? ?????? ????????? ????????? ??? ??????? ?????
  • ???? ?????? ?? ???????? ????????? ????
  • ?????? ??? ??????? ?????? ??? ???? ??????? ?? ????? ???????? ?????????
  • ??? ?????? ??????? retention-????? ????? ???????? ?????
  • ??????? ????? ???????? ???????? ?? ??????? ?????? ?? SQL Server
  • ???????-MaxCmdsInTran ??????? ?? ???? ?????? ???
????? ??? ?????? ????????? 5.3.1 UPDATE ??????? ????

??????? ?? SP1

????? ????? ???????? ????????? ???????? ????????? ??????? ????? ?? ??? ????? ?? ??? ?????? ????? ??????? ??????? ?? ????? ?????? ????????. ??????? ?????? ????? ??????? ??? ????? ?? ??? ??????? ????? ????? UPDATE ???? ????? ???? ??????? ?? ?????? ????????. ?????? ????? ??? ????? ?? ???? ????? ?? ????? ??? ??? ????? ???????? ??? ???????. ??? ??????? ????? ??????, ???? ??? ?????. ??? ???? ??? ???? ???? ?? ??? ??????? ???????? ?? ????? ????? ??? ???? ?? ??????.

????? ????? ??????? ???? ??? ??? ?????? ????? ???????? ????????? ???? ???? ?????? ?? ??????? ?? ?????? ???????? ???? ???? ?????? ??? ??????? ????? ??? ???? ?? ????????? ?? ???? ???? ???? ????? ????? ??? ????? ????????? ?? ??? ???????. ????? ?????? ?????? ????? ??? ???????? ?????? ??????? ??? ???? ??????? ???? ?? ???? ?????? ?? ??????? ???? ?? ????? ???????? ???????. ?? ????? ???? ?????? ???? ??????? UPDATE ?? ??? ???????. ???? ??????? ?????? ??????? ???? ?? ???????, ???????? ????? ????? UPDATE ?????? ???.

????? ???? ?????? ??? ????? ???? ????? sp_scriptdynamicupdproc , ???? ???? ????? ????? ????? ???? ????? ????????? ?? ???? ??????? ??????? ????? ??? ??????? ???? ???? ?? ??? ???????. ??? ???? ???? ???????? ?????? ?????? ????? ??? ??????? ??? ????? UPDATE ??????? ?? ????.

sp_scriptdynamicupdproc

???? ????? CREATE PROCEDURE ???? ????? ????? ???? ???????. ????? UPDATE ???? ??????? ?????? ??????? ????? ????? ????? ???? MCALL ???? ??? ????? ??????? ????. ?????? ??? ??????? ?????? ??? ?? ????? ??? ??????? ?? ?????? ?????? ??? ??? ??????? ???? ??? ??????? ?????. ??? ????? ??? ??????? ?????? ?? ????? ???????? ??????? ?? ??????.

???? ??????

sp_scriptdynamicupdproc @ artid = [] artid

?????

@ artid = [] Is artid ????? ??????. artid ?? int ?? ?? ?? ?????????.

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

????? ?????? ????? ???? ????? ?? ???? ???? nvarchar(4000) . ??????? ????? ????? ????? CREATE PROCEDURE ????? ????????? ?? ????? ????? ???? ???????.

?????????

??? ??????? sp_scriptdynamicupdproc ?? ????? ???????? ?????????. ???? ??????? MCALL ????????? ????? ???? ??????? ???? ????? UPDATE ????? ???????? ???? ????? ?????? ??????? ???? ?? ???????. ?????? ??? ?? ??? ?????? ???? ?? ??? ????? ?????? ??? ????? ????? ???? ???? ?? ?????. ??? ???? ??? ????? ??????, ???? ?????? ??????. ??????? ?? ??????? ?????? ?????? ????? ?????: ??? ????? ??? ??????? ???? ?? ???????, ????? ???? ????? UPDATE ????. ??? ???? ?????? ?????? ???????? ????? ??? ??????? ??? ????? ????? UPDATE ???????. ?? ???????? ?? ?????? ??????? ????? ????? ??????? ? ??????? ?????????? ????, ?? ?? ???? ???? ?????? ?????????? ????.

????? ????? ????? ?????? ????? ????? sp_scriptdynamicupdproc .

?????

??? ?????? ???? ???? (?? artid ??????? ??? 1 ) ??? ?????? ??????? ?? ????? ?????? pubs ?????? ?? ????? UPDATE ?? ?????? ??????? ?????? ???????:
'MCALL sp_mupd_authors'
????? ????????? ??????? ??????? ??????? ?????? ???? ??????? ?? ??? ??????? ?????? ????? ??????? ?????? ?????? ??? ??????:
EXEC sp_scriptdynamicupdproc @artid = '1' 
The statement returns: 
create procedure [sp_mupd_authors] @c1 varchar(11),@c2 varchar(40),@c3 varchar(20),@c4 char(12),@c5 varchar(40),@c6 varchar(20), @c7 char(2),@c8 char(5),@c9 bit,@pkc1 varchar(11),@bitmap binary(2) as declare @stmt nvarchar(4000), @spacer nvarchar(1) 
select @spacer =N'' 
select @stmt = N'update [authors] set ' 
if substring(@bitmap,1,1) & 2 = 2 begin 
select @stmt = @stmt + @spacer + N'[au_lname]' + N'=@2' 
select @spacer = N',' 
end if substring(@bitmap,1,1) & 4 = 4 begin 
select @stmt = @stmt + @spacer + N'[au_fname]' + N'=@3' 
select @spacer = N',' 
end if substring(@bitmap,1,1) & 8 = 8 begin 
select @stmt = @stmt + @spacer + N'[phone]' + N'=@4' select @spacer = N',' 
end if substring(@bitmap,1,1) & 16 = 16 begin 
select @stmt = @stmt + @spacer + N'[address]' + N'=@5' 
select @spacer = N',' 
end if substring(@bitmap,1,1) & 32 = 32 begin 
select @stmt = @stmt + @spacer + N'[city]' + N'=@6' select @spacer = N',' 
end if substring(@bitmap,1,1) & 64 = 64 begin 
select @stmt = @stmt + @spacer + N'[state]' + N'=@7' 
select @spacer = N',' 
end if substring(@bitmap,1,1) & 128 = 128 begin 
select @stmt = @stmt + @spacer + N'[zip]' + N'=@8' select @spacer = N',' 
end if substring(@bitmap,2,1) & 1 = 1 begin 
select @stmt = @stmt + @spacer + N'[contract]' + N'=@9' 
select @spacer = N',' end 
select @stmt = @stmt + N' 
where [au_id] = @1' exec sp_executesql @stmt, N' @1 varchar(11),@2 varchar(40),@3 varchar(20),@4 char(12),@5 varchar(40), @6 varchar(20),@7 char(2),@8 char(5),@9 bit',@pkc1,@c2,@c3,@c4,@c5,@c6,@c7,@c8,@c9 
if @@rowcount = 0 if @@microsoftversion>0x07320000 
exec sp_MSreplraiserror 20598
??? ????? ??? ??????? ??????, ????? ??????? ???????? ?????? ?????? ????? ???? ?? Subscribers ??????.

??? ?????? ????????? 5.3.2 ?????? UPDATE ??? ??????? ?????

??????? ?? SP1

?? ????? ???????? ????????? ????? ??? ?????? UPDATE ?? ?????????. ???? ??? ???? ??????? ?????? ??? ???? ???? ????? ?? ???? ???? ?? ???? ?????? ????????? ?? ??????? ????? ??? ????, ??? ????? ??????? ?? ????? DELETE ??????? ????? INSERT ??? ???????. ??? ??? ??? ??? ???? ??? ??? ????? ?? ????? ??? ???? ??? ???? ???? ?? ?????? ???? ??? ?? ????? ????????? ?? ?? ??????.

??? ???? ??? ???? ??????? ?? ???? ???, ???? ??? ???? ?? ?????? ????. ???? ??? ????? ????? ???? 8207 ??? ???? ??????? ??? ?????? ????????? ?? ?? ???? ????? ????? ???? ??? ?? ???? ??? ???? ?????? UPDATE ??? ???. ??? ????? ??? ???????? ?????? ?? ??? ????????? ???? ????? ?????? UPDATE ??????? ?? ??? ???????? ?? ??? ??????? ????? ????? ??? ???????? ?? ????? ????????? ???? ???? ??? ?? ???? ??? ?? ???? ?????.

???????? ??????? ???? 8207, ?????? ?? ???? ??????? (sqlservr.exe-T8207) ?? ?? ??? ???????? TRACEON(8207,-1) DBCC ??? ??? ????? ???? ?????? ???.

??? Typically, ??? ??????? ????? ???? 8207 ?? ??? ?????? ????????? ??????? ???. ?? ?????? ??? ??????? ???? ?? ?????????? ??????? ??? ??? ??????? ??????? UPDATE ???? ?? ???? ??? ???????.

????? ??????? 5.3.3 ?? ???????? ????????? ????

??????? ?? SP1

?? SQL Server 2000, ?? ??? ?????? ?????? ???? ????????? ??? ??? ??? ?????? ????? ???? ???? ???? ???? ??? ??????? ??????? ?? ????? ?????. ????? ???????? ??? ??? ????? ??????? ???????? ??? ????? ????? ????? ??? ????? ???? ???????, ?? ???? ?? ??? ????? ???? ??? ????? ?????? ????????? ??? ?????. ?? ????? ??????? ???? ???? ??? ??? ??????? ??? ??????? ???????? ????????? ??????.

??? ?????? ????????? 5.3.4 ??????? ??????? ????????? ???????

??????? ?? SP1

??? ????? ?????????? nosync (???? ????? ?????????? ????? ?? ????? ?????? ???????) ?? ????????? ??????? ????? ?? INSERT ???? ?????? UPDATE ?DELETE ??? ??????? ??????. ????????? ??? ????? ??? ???????? ????? ??? ????? ?????? ?????? ?? ???????. ??? ????? ????? ???? ????? sp_scriptpublicationcustomprocs , ?????? ??????? ?????? ?????? ????????? ??????? ??????? ??? ????? ???????. ?? ???? ??? ??????? ??????? ????? ?????????? nosync.

sp_scriptpublicationcustomprocs

?? ????? ??? ????? ?????? ??????? ??????? ????? ???? ????? ???? ??? ????? ??????? ?????? ??????? UPDATE ?? INSERT ????? ??? DELETE ????????? ?????? ????? ???????? ??????. ?????? sp_scriptpublicationcustomprocs ???? ?? ????? ?????????? ?? ????? ??? ????? ?????? ??????.

???? ??????

sp_scriptpublicationcustomprocs [@publication] = publication_name

?????

[@publication] = publication_name

?? ??? ???????. publication_name ?? sysname ?? ?? ?????????.

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

0 (??????) ?? 1 (???)

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

????? ?????? ????? ???? ????? ?? ???? ???? nvarchar(4000) . ??????? ????? ????? ????? CREATE PROCEDURE ????? ???????? ?????? ??????? ?????? ???????.

?????????

????????? ??????? ?? ??? ??????? ?? ?????? ???? ??????? ????? ???? ?????? ??????? ?????? (0x2).

??????

????? ?? ??? ????? ??? ????? ; ??? ????? ????? ????? ???? ??????? ???? ??????? ?????? ?????? ?????? ??? ????? ?????? ????? ?????? sysadmin ???? ??? ?????? ?? ????? ?????? ????? ????? db_owner ?? ????? ???????? ???????.

????

??? ?????? ???? ?????? ??? ?? ????????? ??????? ??????? ?? ????? ???? Northwind.
exec Northwind.dbo.sp_scriptpublicationcustomprocs @publication = N'Northwind'
????? ??? 5.3.5 retention-????? ?????? ??????? ????? ????????

??????? ?? SP1

??? ???? ???? ????? ?? ???????? ?? ????? ???? ????? ???????? ??? meta ????? ?????? ??????? ?????? ??????. ??? ??? SQL Server 2000 SP1 ?? ?? ???? ????? ?????? ??????? ??? ?????? ????? sp_mergecleanupmetadata . ??? ???? SQL Server 2000 SP1 ?????? ?????? retention-????? ???????? ????? ?? ????? ??? ???? ?? ???????? ???? ??? ?????? ??????? ?? ????? ?????? ???????:
  • MSmerge_contents
  • MSmerge_tombstone
  • MSmerge_genhistory
  • ?? ??? ???????? ?????? ?? ???? ??????
?????? Before ???? ?????? ??????? ??? ?? ????? ?????? ?????? ???????? @keep_partition_changes ??? ???????.

????? ?????? ??????? retention-????? ???? ??? ???:
  • ??? ?? ????? ??????? ???? ??? ûMetadataRetentionCleanup ??? 1? ??? ??? ???? ???????? ????? ???? ??? ????? ??????? ?? ?????? ???? ???? ???????? ?? ????? ????????.
  • ??? ?? ????? ??????? ûMetadataRetentionCleanup ??? 0? ?? ???? ??????? ????????. ??? ??? ??????? ?????? ??? ????? ?????? ??????? retention-????? ?????? ????? sp_mergemetadataretentioncleanup . ???? ??? ????? ??? ??????? ?????? ??? ?? ?????? ???????? ???? ??? ?? ???? ?????. ??????? ????? ??? ?????, ???? ?? Publisher ? Subscribers ????? ??? ???? ?????? ?? ????? (???? ?????? ?? ??? ?????? Preventing ????????? ???).

    ?????? ????? ûMetadataRetentionCleanup 1 ?? ???? ??? ?? ???? ??? ???? ????????? ???????? ???? ???? ?? SQL Server 2000 SP1 ?? ????. ??? ??? ????? ???? ??? SP1 ?? SP2 ???? ?? ?? ?????? ????????? ??? ??? ????? ??????? ??????? ???? ??? ?????? ??? ??????? ????????. ??? ??? ??????? ??? SP1 ?? SP2 ???? ????? ?????? ??? ???????? ??? ????? ???? ??? ??? ???????? ??? ????? ??????? ???????; ????? ??????? ??????? ?? ???? ????? sp_add_agent_parameter (???? " ????? ?????? ?? sp_add_agent_parameter" ????? ?????? ?? ??? ??????).
??? ???? ???????? ?????????? ?? ??????? ?? 14 ?????. ??? ??? ????? ???? ??? ?????????? ??? ??? ???? ??????? ?????? ??????. ?? ??? ??????? ??? ??????? ???? ???????? ?????? ?????? ?? ???? ??? cleanup ??? ???? ??????. ???? ??????? ?????? ?? ????? ?????? ?? ??? ??? ???? ?? ??? ????????? ??????? ???? ?????? ????? ???????? (@ ?????? = 0) ? ??? ?????? ??????? ?? ???? ??? ????? ????? ???????? ?? ??? ????????. ???? ?????? ??? ?????? ?????? ??????? ???????? ????.

????? ?????? ?? sp_add_agent_parameter

????? ?????? sp_add_agent_parameter ???? ??? ?????? MetadataRetentionCleanup ????? ???? ?? ????? ?? ????? ????? ?????? ?????? ??????? ?? ????????? ???????? ??? ????. ????? ???? ?? 1 ??? ??? ?? ????? ??????? ??????? ????? ???????? ????? ?? 0 ??? ??? ??? ?? ???? ??? ?? ????? ???????. ??? ???? ??????? ?????? ????? ?????? ?????? ??????? ??? ????? ????? ?????:
EXEC sp_add_agent_parameter @profile_id=<my_profile_id>, @parameter_name='MetadataRetentionCleanup', @parameter_value=1
????? ?????? ??????? ?? ???????? ?? ????????? ???????? ?? SQL Server

??????? ??????? retention-????? ???????? ???? ???? ?? ????? ?????? ????? ????????? ??? ?? ????? ???????? ????????? ???? ??? ??? ?? ???? ??? ???????? ???? ?????? SQL Server 2000 SP1 ?? ??????? ??????. ??? ???? ??????::
  • ??? ??????? SQL Server 7.0 ?? ???? ????? ????? ?? SQL Server 2000 SP1 Publisher.
  • ??? SQL Server 2000 SP1 ??? ???? ?? ???? ????? ????? ?? ????? ?????? ????? SQL Server 2000 (???? SP1).
  • ??? SQL Server 2000 SP1 ??? ???? ????? ??????? ?? ????? ?????? SQL Server 2000 SP1 Publisher ??? ??? ??? ???? ????????? ???? ?? SQL Server 2000 ?? ?? ????.
??????? ???????? ??? ??? ???????? ??? ???? ??????? ????? ???????? false ??? ???? ???? ???? ??? ?? ???? ???????. ?? ??? ???????? ????? ??????? SQL Server ??????? ?? SQL Server 2000 SP1 ?? ???? ????? ????? ???? ??????? sp_mergemetadatacleanup ??? ???? ???????? ???? ???? ????? ??? ????????.

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

???? ????? ?????? ??????? retention-????? non-convergence ????? silent ??????? ??? ?? ????????? ??? ????? ??????. ???? ???? ?? ???? ????????? false ??? ?? ??????? ?? ?? ?????? ???????:
  • ??? ????? ?????? ??????? ??? ???? ????? ? ?? ???.
  • ????? ????? ?? ???? cleaned-up ???? ??? ?? ?? ??? ?????? ??????? ??.
??? ???? ??????, ??? ?? ????? ?????? ??????? ??? ?????? ???? ??? ??? ???????, ?? ??? ????? ????? ????? ??? ?????? ?? ????? ????? ??? ??? ???? ???????? ?????? ???????.

???? ??? ???????? ???? ?? ?? ????? ?????? ??????? ??? ??? ???????? ??? ??? ???? ?????. ??? ??? -??????? MetadataRetentionCleanup 1, ?? ?? ?? ?????? ???????? ????? ???????? ??? ??? ????? ?????, ???????? ????? ?? ??? ????? ????? ?? ??? ?????. ??? ???? ?????? ??????? ???? ????? ????? ???????? ??? ?????? ?????? ??????? ?????? ?? ??????? ??? ??? ?????.

??? ???? ????? ??? ?????? ?? ??????? ?? ??? ??????? republishing ??? ??????? ?? ????? ??????? ?????? ?? ?? ???? ??? ?????? ????????. ??? ????? ?????? ?? ????? ?????? ??????? ??? ???? ???? ???? ??? ?????? ???? ?? ???????? ?? ??????? ?????? ?????? ???? ???????? ????.

?????? ??? ??? ???? ??? ???? ?? ????? ???????? ?? ????? ?????? ????? ???? ??? ?????, ??? ?????? ???? ?????? ????? ?????. ????? ?????? ??????? ??? ??? ????? ??? ??? ??? ???????.

????? ????? ???????? ??? 5.3.6 ????? ????????? ??????????

??????? ?? SP1

??? ???????? ?? ????? ?????? ?????? ????? ??? ?????? ?????? (???? ????? ?????? ?????? ???? ?????? ?????) ????? ????? ????? ???? ??? ??????? ?? ???? ???????? ????? ???? ??????? ?????? ????? ???? ??????? ??????. ???? ???????? ???? ??? ????? ????? ????????? ???? ?? ????? ?? ????? ???????? ??????? ???? ???? ????? ????????? ????.

??? ????? ????? ??????? ?? ????? ?????? ?????? ????? ??? ?????? ?????. ???? ??? ???? ?????? ??????? ????? ?????? ????????? ??? ????? ?????? ??????? ?????????? ?????? ?? ???? ??? ???????? ??? ??? ???? convergence ????????.

??? ???? ??? ????? ????? ????????? ?? ????????? ??????? ????? ???????? ?????, ???? ???????? ?????? ???????? ???????:
  • ??????? ????? ???????? ???????? ?? ????? ????????? ???? ?? ??? ???? ???? ????????.

    ??????? ????? ?????? ?????? ?? ???? ???????? ??? ??? ?? ?????? ?????????? ???? ?? ???? ???????? ?????? ??????? ???????? ?? ???? ????????? ????. ??? ???????? ????? ??? ???? ????????? ???????? ????? ?????? ?? ??????? 10 ? 20 ? ? 30 ???????? ??? ???? ??????? ??? ?? ?? ???? ???? ?? 10 ???? ??????? ?????? ?????????? ????????? ?? ??????? ????? ????????.
  • ?????? ??? ????? ???? ????????.

    ?? ???????? ?? ????? ?????? ?? ?????? ??? ????? ???? ????????. ?????? ???? ??? ?? ?????? ???? ???? ??? ??????? ??????? ?? ?????? ?????????? ???. ?????? ?? ?? ???? ??? ????? ????????? ???? ?????? ????? ???? ??????? ??????? ??? ???? ???? ???????? ???????? ??????? ?? Publisher. ??? ???? ??????? ???? ????? ????? ???? ?????? ?? 10 ????. ??? ????? ???????? ??????? 8 ?????? ???, ?? ??? ????? ????? ????????? ????. ??????? ?????? ??? ?? ????? ????? ????? ????????? 4 ???? ???? ???? ???? 12 ?????? ???, ??? ??? ???? ????????. ??? ??? ??? ??????? ?????? ?? ??? ????? ?????????? ????? ????? ?????? ???????? ??? ???? ??????.
  • ????? ??????? ??? ??? ?????? ?????? ?????? ???????.

    ??? ??? ????? ??? ????? ??????? ?????? ??????? ?????? ????? ??????? ????? ??? ???? convergence ????????. ?????? ??????? ????? retention-????? ???? ??? ?????? ??????? ????? ?? ??? ????? ?????? ??? ?????? ??? ???? ???????? ???????.

    ??? ??????? ?????? ?????? ??????? ?????? ??? ??? ?? ????? ???????? ?????????? ?? ???????? ??? ???? ??????. ??? ??? ????? ?????????? ??? ????? ???? ???????? ??????? ??? ?????? ????? ????? ?? ?????? (????? ?????? ??? ?????? ???????) ? ?????? ??? ?????? ???????? ????? ?????? ????? ??????. Publisher ????? ??? ???? ??? ?????? ??????? ????? ?????? ????????? ??? ???????, ???? ???? ??? convergence non-.
  • ?????? ????? ?????? ??????? ???? ??????? ????? ???????? ? ??? ????? ???????? ????. ?? ???? ??? convergence non-???????? ??? ??????.
5.3.7 ??????? ????? ???????? ???????? ?? ??????? ?????? ?? SQL Server

??????? ?? SP1

??????? ???? ???????? ??? ??? ?????? ? databaseùrunning ??? ????? ??????? createdùwill ?? ?????? ?????????? ??? ??? ??????? ????? ????????. ??? ??? ???? ???????? ????? ?????? ?????? ??? ????? ?? SQL Server ???? ????? ?? ????? ????????? ?? ????? ??? ??????? ????? ????????? ?? ???? ???????? ?????? ???????:
  • ??? ??? ???? ???????? ??? SQL Server 2000 SP2 ?? ????? ??????? ?? ??????? ?????? SQL Server 2000? ????? ???????? ??? ??????? ????? ???????? ??? ????? sp_vupgrade_replication . ????? sp_vupgrade_replication ???? ??? ??? ????? ?????? ??????? ????? ????????. ?? ???? ??? ????? sp_vupgrade_replication , ???? ?? ???? ??? ?????? ??????? ????? ???????? ?? ???? ??? ??????.
  • ??? ?? ??? ??? ?????? ?? SQL Server 2000 ?? ????? ??????? ?? ??????? ?????? SQL Server 7.0 ??? ??? (???? ???? ????? ??????? ?? Service Pack 1 ?? Service Pack 2, ?? Service Pack 3) ?? ???? ???? ?? ???????? ??? ??????? ????? ???????? ????? ?? ????? ?????? ?????????? ??? ????? ??? ???????. ?? ?? ???????? ???????? ?????? ??? SQL Server 2000 SP2 ?? ???? ???????? ?? ????? ?????? ?????? ?? ??????? ?? SQL Server 7.0 ?? ???? ???? ??? ???? ???????? ??????? ????? ????????.
5.3.8 ????-????? MaxCmdsInTran ?? ???? ?????? ???

??????? ?? SP1

???? ?? SP1? ?????? ???? ????? ???? -MaxCmdsInTran ??? ????? , ?? ??? ???? ?????? ???. ?? ??? ????????? ??????? ??? ??? ???? ?? ????? ????????? ????????? ???? (?? ???) ??? ????? ???? ????? ???? ?????? ??? ?????? ???????? ??????? ??? ????? ???????? ??????? ??? ???? ????? ????? ??? ???????? ??? ???????. ??? ??????? ??? ???? ????? ????? ?? parallelism ??? ????? ???????.

???? ?????? ??? ???????? ûMaxCmdsInTran ?? ????? ????????? ????? ??? ??? ???? ?? ?????? ?? ???? ???? ?? ??????? ??? ?? -MaxCmdsInTran ???????. ???? ????? ????? ????? ??? ?????? ??? ???? ?? ?????? ????? ?? ???? ???? ???? ?????? ??? ??? ??? ?????? ?? ??? ???????.

??? ????? ?? parallelism ???? ???? ?????? ??? ???? ????? ????? ?? ???? ????????? ????? ???????? ?????. ????, ??? ???? ?? ??? ???????? ?? ???????? ??? ??????? ?? ?????????? ??????? ????? ????? ??????? ACID ?? atomicity. ??? ??????? ??? ?? ????? ?? ???? ???????, ?? ??? ???????? ?? ?????? ??? ?????? ?? ??.

????? ??????? ûMaxCmdsInTran

????? ????? ?????? ?????? ????? (?? 1) ?? -MaxCmdsInTran ???? ???????. ????? ???? ??? 0 ?? ?????? ?? ?????? ??????? ??? ???????. ??? ?????? ???? ??? ??????? ??? ????? ???? ???????? ????? ???? ?? ???? ?? 5000 ?? ???? ?? ??? ??? ??????? ?? ?????????. ??? ???? ??????::
logread.exe -MaxCmdsInTran 10000.
?????? ???????? ??? ???????? ??? ????? SQL Server 2000 SP1 ?? ??????? ??????? ??? ??? ????? ????? ???????? ??? ???? ?????? ?????? ??? ???? ??????? ???. ????? -MaxCmdsInTran ??? ????? .

????? 5.3.9 ??? ???? ?????? ???????? ??? ?????

??????? ?? SP2 (????? ??? ????? ???????? ??????? ???).

?? ???? ????? ???? ???? ??? ???? ?? ???? ??? ???? ????? ???????? ?????????. ??? ????? ?????? ??? ????? ????? ?? ????? ????? ??????.

5.3.10 new-MaxNetworkOptimization ????? ??? ??????? ?? ??? ???? ????

??? ????? ???????? ????? ?????? ??????? ?? ????? ????? ??????? DELETE ??? Subscribers ?? ?????? ???? ?? ????? ??? ??? ??????? ?????. ??? ??????? ????? DELETE ?? ??? ????? ??? ??? ???? irrelevant. ??? irrelevant ?? ???? ?????? ????????? ?? ?????, ???? ???? ?? ???? ???? ???? ???? ??????? ??? ????????.

??? ????? ???? ???? ?????? ?? ??? irrelevant, ????? ??????? ??????? ???? ??????? ??????? -MaxNetworkOptimization ?? ??????? ????? ????? ????????. ????? ??????? ??? 1 ???? ?? ???????? ???? irrelevant, ????? ????? ?????? ??????.

?????? ????? ??? ??????? ??? 1 ???? ????? ?? ????? ?????? ?????? ???????? ?? ????? ??? ??? true (@keep_partition_changes ??????? ?? sp_addmergepublication) ???.

?????? ?????????? ?? 0 ??? ????? ??????? ??? 1 ????? ????? ?????? ?? ?????? ??????? ??? ????? ????? ?????? ??? ?????? ??? ???? ??????? ?????? ?? ??? ????? ?????? ????? ?????. ???? ?????? ????? ???????? ????? ???????? ??????? ?????? ????? ???-MaxNetworkOptimization ??? 1 ??? ???? ???? ???? ??????? ?? ??? irrelevant ??????? unacceptably.

????? ????? ??? ??????? ??? ??????? ??????? ???? ??????? ?????? ????? ??????? ?????? ?? sp_add_agent_parameter :
EXEC sp_add_agent_parameter 1, 'MaxNetworkOptimization', 1

????? ?????? ??????? 5.4

??????? ??????? ????? ??? SQL Server 2000 Services ?????? ???????.
????? ?????? ??????? 5.4.1 ???????? ?? Unicode

??????? ?? SP1

?????? ?????? ??????? ???? ????? ?????? ??????? ????? ??? XML ?? Unicode. ???????? ??? SQL Server 2000 SP1 ?? ??????? ????????? ANSI ????? ?? ????? ???? ??? ??????????. ???? ??? ??????? ?????? ??????? ????????. ???? ?? ??? ??????? SP2 ?? ????? ????? ????????? ???????? ?? Unicode. ????? ????? ????? ?? ????????? ???????? ANSI ?????? ????? ???? ????? ??????? HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Repository\Engine\XMLExport ?? " 0 ". ???? ??????? ??????? ????? ???? ????? ??????? ????? ????? ??????? ???:
  • NOOBJID = 1
  • NOHEADER = 2
  • INDENTATION = 4
  • UNICODE = 8
  • LOGUNMAPPEDTAGS 16 =
  • EXPORTBASE = 32
?????? ??? ??????? ??? ?? ?????, ???? " ??????? IExport::Export ?? ??? SQL Server ??? ?????? ".

????? ????? ???????? 5.5

??????? ??????? ????? ???? SQL ??? 2000 ???????? ??????? ??????? ??????? (DTS).
??? ????? DTS 5.5.1 ??? ????? ??????? ??? 255

??????? ?? SP2

????? ????? ??????? DTS ??? ????? ???????? ??? ??? ???, ???? ?????? ?????? ?????? ???? ??? ??? 8000 ?? ?? ???? ????? ??? ?????? ????? ???? ??? ???.

???? ?????? 5.5.2 ????? ?? ??? DTS ??????? ?? ??? ???? SQL Server

??????? ?? SP2

???? ?????? ???? ???? ????? ?? ???? ?? ???? ???? ???? SQL Server. ????? SP2? ???? ???? ???? ?? ???? ?????? ??????? ??????. ???? ???? SQL ??? ????? ???? DTS ?? ???? ?? ??????? ????? ???? ???????? ????? ????? ??????. ????? ??? ????????? ????????? ?????? ???????? ??? ?????? ??????? ???? ???? ????? ??? ????? ????? DTS ??? ???? ??? ????.

??????? 5.5.3 SQL Server ???? ???? ??????

??????? ?? SP2

??? ??? SP2? ????? ??? DTS ????? ??? ?????? ????? ??? ????? ???????? ?? SQL Server ???? ???? ?????? ?? ?????? ?????? ???? ?? ?????? ??? ?????? TEMP ???????? ????? ?????? ??? ?? ????? ?????? (?? ???? ???? ???? ??????? ?? xp_cmdshell ) ? ?? ?????? (?? ???? ???? ???? ??????). ????? ???? ?????? ????????? ?????????? ???? ?????? ???? TEMP ?? ???? SQL Server ?? ???? SQL ??? ??????? ??? ???? ???? ?? ?????? ??? ??? ????? ?? ?? ? ???????? ??????, ??? C:\TEMP. DTS ?? SP2, ?? ????? ???????? ?????? TEMP ?????? ??? ??? ?????? TEMP ???????? ?? ?????? ????? ?????? ??? ??? ????????? ???? ????.

??????? 5.6 ??? ?????? Backup Virtual API

??? ????? ?????? ?????? ??? SQL Server 2000 Virtual Backup ??????? API.
?????? 5.6.1 ????? ?????? ?????? ?? ???? ????

??????? ?? SP2

???? API ???? ????? ????????? Virtual ????? ??????? ????????? ??? SQL Server 2000 ?? ????????. ?? engineered ??? API ?????? ???? ?????? ????????? ???????. ???? ???? ????? ????? ????????? ?????????? ?? SQL Server 2000, ??? ?? ??? ???? ???? ?? ????? ?????????? ??????? ??? snapshot ???? ????.

?? SP1 ?? ????????? ??????? ??? ???? ??? ?????? ??? ????? ?????? ??? ??????? ???? ?? ????? ????? ?? ????? ???????. SP2 ???? ???? ????? server-side ?? ????? ? ???????? ????? ?????? ?????? ?? ???? ????? ??? ??? VDC_PrepareToFreeze .

????? ??? ??????? ?????? ??? ????? VDC_PrepareToFreeze ??????? ???? ????? ????????? ?? SP2 ????????. ???? ?????? ????? ???? ?? ??? ????? ????? ?????? ??????? (vdi.h) ??? ??? \devtools\include ?? ?????? ????? SP2.

????? ????????? ?????????? 6.0

??????? ?? SP1

??? ????? Microsoft ????? ???? ????????? ????????? ??????????. ?? ??? ????? ??? ????? ???? ?? ???? ???????. ??? ???? ???? ?? ???????? ???? ??? ?????? ??? ??? ??? ?????? ??????? ??????????. ??? ?? ????? ?????? ??? ????? ??????? SP2 ?? \EQHotfix ??????. ????? ?????? ??? ????? ????????? ?????????? ?? Microsoft Product Support Services Knowledge Base. ????? ?? ???? 297105 ????? ?????.

?????-DB 7.0 ? SQL ??????? ?? C

??????? ?? SP1

?? ????????? ?????????? ?? SQL Server ????? ?????-DB ? SQL ??????? ?????? ???????? C ????? ?????? (API) ?? ???? ?????? ?? SQL Server 2000? ?????? ??????? ???????? ?????? ?????? ??????? ?? ????????? ???? ?????? ??? API. ????? ??? ?? ??????? ?????? ?? ???? SQL? ?? ???? ????????? ?? ????????? ?????? ???????? ?????-DB ? SQL ??????? ?? C ???? ??? ???? ????? ??? ????? ?? ????? ???????. ???? ??????? ??? ???????? ??? ????? ??????? ?????. ??? ????? ?????????? ???????? ??? ???? ????? ?????? ???????? ??? ??? ????????. ????? ?? ?????-DB ?? SQL ??????? ?? C, ????? ??????? OLE DB ?? ADO ?? ODBC ??? ???? ??? ???????? ?? SQL Server. ?????? ?????? ??? ??? SQL Server ??? ?????? ?????? ??? ???? ?? ????????? ??? ??? ????????.

???????

???? ???????: 889552 - ????? ??? ??????: 06/?? ??????/1428 - ??????: 1.1
????? ???
  • Microsoft SQL Server 2000 Service Pack 2
????? ??????: 
kbdatabase kbservicepack kbhowto kbinfo KB889552 KbMtar kbmt
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????. ??? ?? ???? ??? ??????? ????? ?? ???????? ?? ??? ???????? ?????? ????? ????????? ??????? ???? ??? ???????
???? ??? ????? ??????? ?????? ??????????889552

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

 

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