a? ???? ???? ?? Microsoft SQL Server 2000 ????? 9 ? 2003

?????? ????????? ?????? ?????????
???? ???????: 889551 - ??? ???????? ???? ????? ????? ??? ???????.
a? ???? ???? ?? Microsoft SQL Server 2000
? ????? ????
???? ????? Microsoft Corporation? 2003. ???? ?????? ??????. ?? ???? ??? ??? ????? ????? ?????? ?????? ????? SQL Server ???? welcomes ???????? ?????????? ??? ??? ??????? ????????. ????? ????? ?? ????? ??????? ?????? ?????????? ???????? ???????? ??????? ????? ???????. ??? ?? ???? ???? ????????? ?????? ??????????. ????? ??????? ?????? ??? ??? ???????, ???? ???:
????? ???? | ?? ????

?? ??? ??????

1.0 ????? ???

a? Microsoft SQL Server 2000 Service Pack ????????? ??? SQL Server 2000 SP3 ???? ?????? ?????? ?????? ??????? ??????? Slammer ???? (SP3a):
  • ???? ????? SP3a ??? SQL Server 2000 Enterprise ????? Edition ?????? ????????? ??? ?????? ?? ??? ??????? ?? SQL Server.
  • SP3a ???????? ??????? ??? ??????? ???? ?? ??? ????? ?????? ?????? ??????? Microsoft "(MDAC) ?? SQL Server 2000 SP3
  • ?????? ???????? MSDE 2000 SP3a ??????? ????????? ???? ????? ????? ????? ???????? ???? ??????? ??? ????? ???? ?????? MSDE 2000. ???? ??????? ???? ??????? ??????? ??? ??? ????? ??? ????? ?????? ??? SP3a.
  • ????? ??? ????? ???? ?? SQL Server 2000 SP3a ?? MSDE 2000 SP3a ?? ????? ??????? ???? ??????? ? ?????? ????? ????? ??????? ???? UDP 1434.
??? ???? ????????? ???? ?? ??????? ?? SP3a ?????? ????? ?? ????? ??? ????? SP3a ??? ?????? ?? SQL Server 2000 ?? MSDE 2000 ?????? ?? ???????? ??? SP3. ??? ??? ???? ?????? ?? ??? ?? ???????? ??? SP3 ??? ????? ?? ???? ???? ?????? ??????? ??? ???????? ?????? ??? SP3a ????? ?? SP3. ??? ??? ???? ?? ??? ????? ??????? SP3 ???? ?? ??????? ???????? ?????? ?????????? ??? ??? ??? ??? ??? ????? ?? ??????? ??? SP3a ????? ??????? ?? ??????? SP3a ????????. "?????????" ???? ?????? ????? MSDE 2000 SP3a ????? ?? SP3. ????? ????? ????? SP3a ?????? SQL Server 2000 SP3 ?? MSDE 2000 SP3 ?????? ???? ????? ???? ??? ?????? ???.

??? ??????? ?? "???? ???????" a? (SP3a) ?? Microsoft SQL Server 2000 ??????? ?? ????? ?????:
  • ???? SP3a ?????? ????? ???????? ??????? ??????? ????? ???????? ???? SQL Server 2000? ???????? ?????? SQL Server 2000 Desktop Engine. ????? ????? ?????? ?????? SP3a ????????? ???:
    • ???? ????? ????????.
    • ????? ?????? ????? ???????? ????? ????? ?????? ??? ????? SQL Server ??????? ??????? ???????? osql.
    • ????? ?????? ?????? ??????? ?????? ??? ???? Microsoft OLE DB ?? SQL Server 2000 ?????? ????? SQL Server 2000 ODBC ?????? ?????? Net.
  • ???? SP3a ????? ??????? ????????? ?????? ??????? ????? ????? SQL Server 2000 ?? ????? SQL Server 2000 ? ??? ?? ???:
    • ????? ???????.
    • ????? ????? ?????? ??????, ???? ????? ????? ????? ? ???? Microsoft OLE DB ?????? ?????.
    • ????? ?????? ?????? ??????? ?????? ??? ???? Microsoft OLE DB ?? SQL Server 2000 ?????? ????? SQL Server 2000 ODBC ?????? ?????? Net.
  • ???? SP3a ???? ??? ?????? ????????? ?????? ????? ?????? ?? ???? SQL Server 2000 Desktop Engine (MSDE 2000) ? ??? ????:
    • ???? ????? ????????.
    • ???????? ???? ??????? ????? ???????? ???? ???? ?? MSDE 2000 ??? ??????? ???????? osql ? bcp.
    • ????? ?????? ?????? ??????? ?????? ??? ???? Microsoft OLE DB ?? SQL Server 2000 ?????? ????? SQL Server 2000 ODBC ?????? ?????? Net.
???? ????? ??? ??????? ??????? SP3a ???? ???? ? ??? ???:
  • ???? ?? ?????? ????? SQL Server 2000 SP3a ?????? ????? ?????? ???????? ????? ???????? ?????? ??? ??? ????? "????? ???????" ?????? ??? ?????? ?? ?????? SQL Server 2000 Desktop Engine.
  • ???? ??????? ????? 2000 ????? ??????? SP3a ????? ????? ????? ???????? ?????? ??? Analysis Services ??? ????? ?????? Desktop Engine ?? ???????? ????? ???????? ?????? ???.
  • ???? ?? ?????? ????? MSDE 2000 Desktop Engine SP3a ?????? ?????? MSDE 2000 ??? ????? Analysis Services ?? ?????? ?? ???? ????? ?????? SQL Server 2000.
???????? ???? ????? ?????? ?????? ?? MSDE 2000 ? ????????? ?????? ?? ???? ????? ?????? SQL Server 2000 ??? ????????? ????? ??? ????? Desktop Engine SP3a ??? ?????? MSDE 2000 ? SP3a ?????? ????? ???????? ??? ?????? ???? ????? ?????? SQL Server 2000 ??? ??????? ??????? Standard Edition ?? Enterprise Edition.

????????? ?????? SP3a ???? ????? ??? ?? ???? ?????? ???? ????? ?? ?????????? (????????) ???????? ????????? ? ??? SQL Server 2000 Desktop Engine (MSDE 2000) ?? ??????? ?????? ?? SQL Server 2000 ????? ???? ??????. ?? ????? ?????? SQL Server 2000 ????? SP3a ?????? ????? ???????? ?? SP3a ????? ??????? ?? ??? ??????. ?????????? (????????) ???????? ? ????????? ?????????? ????? ???? ?? ????? SP3a ??? ????? SQL Server ?????? ?? ??? ????? Desktop Engine SP3a ?? ??????? ???? ????? ??? ????? ?????? ?? ???????. ??? ???? ??????? ??? ????? ??????? SP3a ????? ?????????? ?????? ????? ?????????? ????? ???? ????? ?????? SQL Server 2000. ?????? ??? ??????? ??? ????? ????? ???? ?????? ???? ???? ??????? 2.0 ? ??????? SP3a.

1.1 ???? ???? ??? ??????? SP3a ?????? ????? ????????

??? ?????? "??????? SP3a ?????? ????? ????????" ???????? ???? ????? SQL Server 2000 ??? ???? SQL Server 2000 ??????. ?????? ??????? ?????? ???????? ??????? ???? ??????. ??? ???? ??????? ??? ??? ?????? ???? ?????? ??? ??????? ?????? SQL Server 2000 Standard Edition ???? ?????? ?? ????? ????? ???????? ???? ?? ??????? ?? SQL Server 2000 Enterprise Edition ???.

????? ????? SP3a ?????? ????? ???????? ??? ???? ???????? ??????? ?? ???? SQL Server ?????. ??? ??? ???? ?????? ?????? ?????? ?? SQL Server 2000 ??? SP3a ??? ????? SP3a ??? ?? ????. ??? ????? ???? ???? ??? ??????? ???? ?? ???? ?? ?????? SQL Server 2000 SP3a ??? ????? ???? ??????? ??? SP3a. ?? ???? ??? ?????? ?? ??????? ??? ????.

1.2 ???? ???? ??? ??????? SP3a ???? (MSDE 2000) ??? ??????

???? ??????? SP3a ???? ??? ?????? ???:
  • ????? ????? ????? ?? SQL Server 2000 Desktop Engine (MSDE 2000) ??? SP3a.
  • ????? ???? ???? ?? MSDE 2000 SP3a ? ???? ?? ???? ????? ????? MSDE 2000 ???? ???? ?? ?????? ?????? MSDE 2000.
  • ????? ???? MSDE 1.0 MSDE 2000 ???????? ???? ????? MSDE 2000 ???? ?? ?????? ?????? MSDE 2000.
  • ???? ??????? ???????? ???? ??????? ???? ????? ????? ???? ???? ????? ???? MSDE 2000 SP3a ???? ?? ????? ???????. ??? ?? ???? ??? ?????? ????? ?????? MSDE ?? ?????????.
????? ?? ????????? ??? ????? MSDE 2000 ???? Uses of MSDE 2000.

????? ????????? ?????? ?????? ???? ???? ?? SQL Server 2000 a? ????? ????? ?? MSDE 2000 ??? ????? ????? ??????. ??????? SP3a ???? Desktop ???? ??? ??????? ??????? ?? Microsoft ?????? SP3a ?????? ?MSDE 2000 ???? ?? ????? MSDE 2000 ???????? ?????? ????????. ????? ???? ????????? ???????? ??? ????? ????? MSDE 2000:
  • ???????? ???? ??????? ???????? ??????? ?????? ???????? ?????? MSDE 2000 ????? ???????. ????? ?????? MSDE 2000 ????? ???? ??????? ??? SP3a ???????? ????? SP3a ???? ??? ??????.
  • ??? ??? ?????? ???? ??????? ???????? ??????? ????? ???? Windows Microsoft ? ???? ?? ?????? ???? ??????? ???????? ??????? ??????? ??? MSDE 2000 ??????. ?? ???? ????? ?????? MSDE 2000 ????? ???? ??????? ?????? ??????? SP3a ???? ??? ??????. ??? ??????? ????? ??????? ?????? ??? ??? ?????. ???? SP3a ???? (MSDE 2000) ??? ?????? ??????? ??????? ??? ???? ????????? ???????? ???? ?????? ??????? ??????? ?????. ??? ?? ??? ????? ??????? ???????? ????? ??????? ????? ??????? ?????? ???????? ????? MSDE 2000 ????? ?? ??????? ??????? ??????? ??? MSDE 2000 ??????.
??????? ?????? ?? ??? ??? ???? ?????? ???? MSDE 2000 SP3a ???????? Desktop Engine SP3a ?? ?? ?????? 2.1 ????? ? SP3a ??????? Desktop Engine (MSDE 2000). ??? ??? ??? ???? ?????? Desktop Engine SP3a ?? ????? SP3a ????? ?? SQL Server 2000 ????? ????????? ???????? ?? ????? 2.1 ?????? ?? ??? ??? ????? ????? Desktop Engine SP3a ?? ??? ??????? ????? ????? ?????? ??? ??? ?????.

?? ???? ?????? ?????? ?? MSDE 2000 ??? ???? ??????? ??? ?? ??? ????? ?? ???? ???? ???? ?????? ?? ??? ??? ????? ????? SP3a ???? ??? ??????. ??? ??? ?? ????? SP3a ???? ????? ??? ????.

?????? ?????? ?? ??????? 1 ? 2 ?? ??? ????? ???????? ?? ?? ???? ????????? ???? ???? ?? ?????? 3 ???:
  • ?? ???? ?? ???? ????? ????? Desktop Engine SP3a ????? ???????? ?? MSDE.
  • ???? ?????? ???? ????? ?? MSDE 2000.
  • ??? ????? ??????? Desktop Engine SP3a ??? ???? ??????? ???????? ?? ??? ?????????.
????? ??? ??????? ??????? ??????????? ?????? ?????? ??????? ????? ????? ?? MSDE ??? SP3a ?? ????? ???? ???? ?? MSDE 2000 SP3a:
  • 3.7.4 ????? ?????? MSDE 2000 ????? ??? SP3a
  • 3.7.5 ????? ???? ???? ?? MSDE 2000 SP3a
  • 3.7.6 ??????? MSDE 1.0 ??? MSDE 2000 SP3a

1.3 ????? SP3a

????? ????? ????? SQL Server 2000 SP3a ??? ?????? SQL Server 2000 SP3a ???? ???? ????????.

????? SQL Server ?????? ????? ???????? "?" SP3a ???? ??? ??????

??? ????? SP3a ?????? ????? ?????? ???? SQL ?? Desktop Engine SP3a ????? ??????? ?? ????? ?????? ????? ????? ?? ?????? ????? ????? ????? ???????? ???????? ???????? ??????? ?? ???????? ????? ????????. ????? ??? ????????? ?? ???? ????? SP3a ??????. ?????? ??? ?????? ???? ???? ??? ??????? ??? ????? SP3a ?????? ??? ????? ????? ???? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000; ?? ??? ????? ????? ???? ??????. ??? ???? ??? ??????? ??? ?? ???? ???? SQL Server 2000 ?? ????? ??? ??????? ????? ??????? ?????? (QFE) ? ??? ?? ???? ????? ???? ?????? ??? ???????? ??? ??? ??????? QFE ??? ??????.

?????? ?????? SP3a ??? ?? ???? ???? ??? ???????? ?? ????? ??????? ? ???? ? ????? ?????? msdb ?? ???????? ?????? ??? ??? ????? SP3a. ????? ?? ?????????? ???? ????? ???? 3.1 ?????? ????? Your SQL Server ?????? "?" ????? ???? 3.2 ?????? ????? Your Analysis Services ?????? "?" ??????.

????? ?? ?????????? ???? ????? ????? ?????? 2000 ???? SQL ? SP3a ???? ??? ??????.

????? SQL Server Analysis Services ?????? SP3a

????? ?????? ??? ????? SQL Server Analysis Services ??? ????? SP3a ??? ????? ???? ??? ???? ??? ???? ???????? ?? ????? ?????
HK_LOCAL_MACHINE\Software\Microsoft\OLAP Server
????? sub-keys ?????? ??? ??? ????? SP3a. ??? ????? ????? SP3a ? ??? ??? ????? ??????? ??? ?? ??????? ????? ???? SP3a ?? ????? ?????????.

?????? ?? ???? ????? ????? ??????? MDAC 2.7 SP1a ???? ??? ??????? ????? ??????? SP3a.

????? ?? ?????????? ???? 3.1.4 ????? ????? SP3a ????? ??????? ?? SQL Server 2000.

1.4 ????? ??????? ?????? ?? SQL Server ?? ????? ?????

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

???? SQL?????? ????? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000 ????? ???? SELECT @@ VERSION ?? SERVERPROPERTY('ProductVersion') ?? ???? ??????? ???????? ?????? ???????? osql ?? isql ?? ?? ???? ??????? ?? ???? ??????? SQL.

????? ?????? ???? ????? ????? ?????? ?????? ??? ????? ???? ?? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000 ?????? ????? SERVERPROPERTY('ProductLevel') SELECT.

???? ?????? ?????? ??????? ??? ????? SQL Server 2000 ? ????? ??? ??????? ???? ?? ?????? ?????? @@ VERSION ?????? ????? ????? ?????? ??? SERVERPROPERTY('ProductLevel').
?? ??? ??????????? ??? ??????
????? SQL Server 2000 ??????@@ ?????ProductLevel
??????? ?????? ?? SQL Server 20008.00.194rtm
????? ?????? ?????? SP1 ?? ???? ??? ?????? SP18.00.384???? ??????
SP2 ?????? ????? ???????? ?? ???? ??? ?????? SP28.00.534?????? ????? ?????? SP2
????? ?????? ?????? SP3 ?? SP3a, ?? SP3 ???? ??? ?????? ?? SP3a8.00.760?????? ????? ?????? SP3
??? ?? ??? ??????? ?? ????? ???? ????? ?????? 2000 SQL Server ?? MSDE 2000 ?? ???? ????? ??? ????? ?????? ?? ??????? ???? ?? ??????? ?????? SELECT @@ VERSION. ??? ?? ????? ????? ?????? ??? ????????? ???????:
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 ???? ????? ?????? ?? MSDE 2000. ??? ??????? ??????? ???? ??????? ??????.

????? ????? ????? ??????? ?????? SERVERPROPERTY('Edition') SELECT ?? ???? ??????? ???????? ?????? ???????? osql ?? isql ?? ?? ???? ??????? ?? ???? ??????? SQL.

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

?????? ????? "????? ???????" ???? ??? ???????? ???? ??????? ???????:
  1. ?? ??????? ???? ? ???? ??? ????? ??????? ???? ??? SQL Server 2000 ? ??? ??? ????? ????? ?? ?? ???? ??? ????? ?????.
  2. ?? ???? ????? ????? ???? ??? ?????? ?????? ??? ???? "????? ?????" ??? ?? ???? ??? "???" ????? ?????.
  3. ?????? ?????? ?????? ?????? ?? ????? ?? "????? ?????" ????.
?? ??? ??????????? ??? ??????
????? ????? ?????????? ??? ?? ????????? ???
????? SQL Server 2000 Analysis Services ??????8.0.194
SP1 ????? ?????8.0.382
SP2 ????? ?????8.0.534
SP3 ????? ??????? ?? SP3a8.0.760
??????? ??? SP3 ? SP3a

?????? ?? ??? ??? ???? SP3 ?? SP3a ????? ???? ??? ????? ??? ????? Net Ssnetlib.dll. ??? ??? ??? ????? ??? ????? 2000.80.760.0 ? ???? SP3; ???? ??? ????? ??? ????? ??? 2000.80.766.0 ???? SP3a.

????????? ?? ?? ????? ???? ???????? ????????? ??????????, ????? ?????? ??? ????? Ssnetlib.dll ?? ??? ??? ???????:
  • ?????? ?????????: SQL Files\Microsoft C:\Program Server\Binn\Ssnetlib.dll
  • ???? ??????: SQL Files\Microsoft C:\Program Server\MSSQL$<instancename>\Binn\Ssnetlib.dll
?????? ?? ??? ??? ???? ?????? ??????? SP3 ?? SP3a ??? ??? SP3Readme.htm ?????? ?????? ??????. ??? ??? ????? ???? ??????? SP3a ?? SP3? ?? ???? ?????? ??????.

1.5 ??????? ?????? ??? SP3a

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

????? ?? ????? ?? "????? ???????
  1. ??? ?? ??????? ??? ?????? MicrosoftSQL Server 2000.
  2. ?? ????? ????? ?? ? ???? ??? ??????? ???? ??????.
  3. ??? ??? ????? ??? ????? ????.
  4. ???? ??? ???? ??????.
???? ??? ??? ??????? ????? a? ???? ???? ?? SQL Server 2000 ??? ?????? ?? ????? ??? ??? ??????? ?? ??? ????? ???????? ?? ????? "????? ??????? ?? Microsoft" 816502.

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

Microsoft Data Access Components

????? ???? ?????? ??? ????????? ??? Microsoft Data Access Components (MDAC) ? ??? ?? ??? ??????? ?? MSXML.

????? ?? ?????????? ???? ?????? 5.5.1 ????????? ??? ?????? Microsoft Access Components.

????? QFE

?? ??? ????? ???? ????? ???? SQL Server 2000 ?????? ????? ?????? SP2 ?? ??????? ???? ??? ?? SP3a. ??? ????? ??????? ???? SQL Server 2000 ??? 14 ??????, 2002 ? ??? ??????? ?????? ??? ??????? ?? ??? ??????? ?? SP3a.

???? ????? ????? ??????? ??? ????? ?????? ??? ??????? ?????? ??? SQL Server 2000 SP3a.

SQL Server CE Server ????? ?????????

??????? Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) ??? ????? ????? ????? ????? ???????? ?? ???? ?????? SQL Server 2000 ????? ?????? ???? ??????? ??? SP3 ?? ???? ?????? ????? ???????? ???? ??? ?????? ????? ??????? ?????? ?? Microsoft (IIS). ????? ???? ????? ???? SQL Server CE ?????? ?? Microsoft Web site ???.

1-6 ??????? ????? Online ????? ????????

????? ????? ??????? SP3 ? SP3a. ????? SQL Server 2000 ???????? (Updated - SP3) ????????? ???????? ???????? ??? ????????? ??????? ???? ????? SP3 ? SP3a.

????? ????? "??? SQL Server 2000 ???????" (Updated - SP3) ?? Microsoft Web site.

1.7 ????? SQL Server ? ??? ????? Analysis Services ????????

????? ?? SQL Server 2000 ????? ???????? ????? ?????? ??????? ???? ?? ??????? ?? SP3 ? SP3a ????. ????? ????? ??? ????? ?? ????? ??? ?? ???? Microsoft ??? ?????.

2.0 ????? ? ??????? SP3a

??? ????? SP3a ?????? ???????:
  • ??? a? ???? ???? ?? SQL Server 2000 ??????? ???? ????? ??? ???? ??? ???????? ???????:
    • SP3a ?????? ????? ????????
    • SP3a ????? ?????
    • SP3a ???? ??? ??????
  • ?? ???? ????????? ?????? ??????? ???? ????? ??????? ?? ???????? ?? Microsoft SQL Server Downloads Web site:
    • Sql2ksp3.exe (SP3a ?????? ????? ????????)
    • Sql2kasp3.exe (SP3a ????? ???????)
    • Sql2kdesksp3.exe (SP3a ???? ??? ??????)
?????? ???? ???? ?? SQL Server 2000 a? ???????? ? Sql2kdesksp3.exe ????? ??? ???? ??????? ???????? ?????? ???? ???? ?? Desktop Engine.

?????? ???? ????? ??????? ?????? SP3a ??? ??????? ??? ??????? ?? SP3. ??? ??? ???? ??? ????? SP3a ????? ????? SP3a ?????? ?? ????? ???????.

??? ?? ??? ???? ??? ????? SP3a ???? ?????? ????? ??????? ?? ?? ??????. ??? ????? ??? ??????? ??? ????????? ????? ?? ????? ?????? ?????? ?? ???????? ??? ??????? ???????? ??? ????? ???? ??? ??? ??????? ??? ???????? ???????? ??? ????? ??????? SP3a. ??? ????? ??? ??????? ??????? ????? ????? ????? SP3a ?? ???????? ??? ????? ????? ??.

??? ????? ??????? ????? ??????? SP3a ?? ???????? "? ?????? ????????? ???????:
  • ?? ?????? ??? ??????? ??????? ?? ??? 2.0 ?? ??? ??? ??????? ???? ??? ?? ???? ??? ??????? ???? ?????? ?????? SQL Server 2000 ???? ???? ???????? ??? SP3a ?? ?? ???? ??? ?????? ??? ????. ?? ??? ?????? ????? ?????. ?????? ?????? self-extraction ??? ?????? ???? ???? ??? ????? ???? ???????.

    ????????? ??????? ???? ??????? ??? ???? ????? ?????? ? ?????? ??? ?????? ???? ????? ?? ???? ??? ???? ??? ?????? ?????? self-extraction.
  • ??? ???? ??????? ?????? ?? ?????? ???? ??????? ???? ???? ?????? ????? ????? ???? ?????? ??? ?? ???? ???? ????? ??? ??????? ?? ??? ???? ???? ??? ????????? ??????. ????? ??? ????? ?????? ??? ??????? ???? ? ????? ?????? ????? ???? ??????? ????????? ? ????? ????? ????? ???????? ?? ??? ??? ???????? self-extraction.
  • ???? ????? ????? ?? ??? ?????? ??? ??????? ????????; ??? ???? ???? ?? ?? ??? ???? ?????? ?? ????? ??? ?????? ?????. ????? ??????? ??? ?????? ????? ??? ?? ????? ??????? ????; ????? ?? ??????? ??? ????? ????? ?? ?????? ?? ????? ?????.
  • ??? ??????? ????? ??????? ???? ?????? ?????? ?? ??????? ???????? ???? ?? ????? ??? ??? ????? ??????? SP3a. ?? ???? ????? SP3a ??? ?? ??????? ??????? ?????? ??????? ???? ???? ??? ?? ????? ?? ????? ????? SQL Server.
  • ??????? SP3a ?????? ????? ?????? Analysis Services SP3a ????? ??????? ?? ???? ??? ?? ????? ??????? ? ??????? ?????????.
?????? ??? ??????? ?? ??? ??????? ????? ????. ?? ???? ????? ??? ??? ???? ??? ???????: ?? ?????? Windows? ??? ??????? ???? ???? ??? ?????? ? ???? ??? ????? ??????? ??? ??? ?? ??? ????? ???? ??????? ???? ????????.

????? ????? ????? ???? SQL ???? ????? ?????? Server 2000 ?? MSDE 2000

??? ???? SQL Server 2000 ???? ???? ?????. ?????? SQL Server 2000 ??? ????? ??? ?????? ???? ?????? ????? ????? ??? ??? ????? ??????? SQL Server 2000. ??? ???? ??????? ??? ??? ???? ?????? ???? MSDE 2000 ?????? ????????? ??? ????? ??????? ???????? ?? SP3a ???? ??? ??????.
  • ???? ??? ???? ? ?? ???? ??? ?????.
  • ?? ?????? ???? ???? Regedit ?? ???? ??? ?????
  • ??? ???? ?? ??? ??? ???????? ???????:
    • ??????? ????? ??????? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000 ???? ?? ??? ??? ???????:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
    • ???? ???? ?? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000 ? ??? ???? ?? ??? ??? ???????:

      ??? ???? ??? ?????? ?? ??? ?????? Server\InstanceName\CurrentVersion SQL HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
  • ?? ????? ??????? ????? ???? ????? ?????. ?????? ??? ?????? ??? ?????? ?????? ?????? ????? ?????? ?? ???? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000:
    ?? ??? ??????????? ??? ??????
    ???? ??????? ????? (??????? ???? ????)??? ???? ??????? (??????? ???? ????)???? ??????? ????? (??????? ???? ????)
    0x000004041028??????? ?????????
    0x000004071031?????????
    0x000004091033??????????
    0x0000040a1034?????????
    0x0000040c1036????????
    0x000004101040?????????
    0x000004111041?????????
    0x000004121042???????
    0x000004131043?????????
    0x000004161046?????????? (????????)
    0x0000041d1053????????
    0x000008052053 ??????? ???????
?????? ????? ???????? ?????? SP3a ????? ?????

?????? ????? ???????? "?" ????? ????? ??????? ??? ????? ????? ??????? ??????? ??????? ???? ???? ?????? ???? ???? ?????? ??? "???????" ????? ??????? SP3a. ?? ??? ????? ??? ??????? ??????? ?? SQL Server 2000 ???????? ???? ?????? ??? ???? ????????? ????? ??. ?????? ??? ??????? ??? ????? ?????? ??? ????? ???? ?? "??? SQL Server ???????" ???? "?????? 1-6 ????? ??????? OnlineDocumentation ?? ????????". ??? ??? ???? ?? ?????? ??? ????? SQL Server 2000 SP3a ??????? ??????? ???? ????? "??? SQL Server ???????" ????? ??? Setupsql.chm. ???? Setupsql.chm ?? ?????? ?????? \Books ?????? ??? ????? ??????? SP3a ?????? ?????? ?? ?????? ???? ??????? ???? ????? ??? ????? ???? ??????? ????????.

2.1 ????? ?? ??????? SP3a ???? (MSDE 2000) ??? ??????

??? ?? ???? ?????????? ????? ????? ????? ????? ?? MSDE 2000 ????? ????? ???? MSDE 2000 ????? ??? ??? ????? ????? ????? ????. ????? ????? ??? ?? ????????? ??????? ?????? ProductCode ?? ????? ????? ?????? ????????? ???????? ?? 311762 ????? ????? ????? Microsoft ".
  • ??? ??? ??? ?????? ??????? ????? ProductCode SqlRun01.msi ???? SqlRun16.msi ? ????? ????? ???? MSDE 2000 ???????? ????? ??????? SQL Server 2000 SP3a ????? ??. ???? ????? ?????? ??? ??????? ??? ????? ????? ????? ???? MSDE 2000.
  • ??? ??? ??? ?????? ??????? ?? ???? ProductCode ???? ??? ??? ??????? Microsoft ? ???? ???? ??????? ?????? ??? ??????? ??? ????? ????? ???? ?????? ?? MSDE 2000: Microsoft MSDE Applications Web page.
  • ??? ?? ??? ?????? ProductCode ????? ?? ??????? ?? ????? ?????? ?? ???? ???? ??????? ???????? ?? ??? ?????????. ?? ????? ??????? ????? ??????? SQL Server 2000 SP3a ?????? SP3a ??? ?????? MSDE. ????? ?? ???? ??? ?????? ??? ??? ????? ?? ???? ????? ???????. ??? ??? ??????? ?? ???? ???? ??? Microsoft ? ??? ??????? ??? ?????? ???? ?????. ??? ??? ??????? ?? Microsoft ? ???? ???? ??????? ???? ????????? MSDE ?? Microsoft (???? ????? ??? ?????? ??????? ??? ????? ????? ??? ??????? MSDE 2000): Microsoft MSDE Applications Web page.
  • ??? ??? ??? ?????? ??????? ????? ProductCode Sample.msi ?? SampleUpg.msi ? ???? ??????? ??????? 314131.
????? MSDE 2000 SP3a

??? ?? ????? ?????? ?? MSDE 2000 ??????? ?????? ???????? ?????? MSDE (SqlRun01.msi ???? SqlRun16.msi ??? ??? ?????? ??????) ? ????? ????? ?????? ?? MSDE 2000 ???????? ??? ????? SQL Server 2000 SP3a:
  • ????? ??? Microsoft SQL Server Downloads Web site.
  • ?? ??? ???? ????? ?? ?????? ?????? ?? ??? ?????? ? ??? ????? ???? ?????? ?? ????? ????? ?? MSDE 2000 ?? ???? ??? ??????.
  • ?? ?????? ???????? ??? ???? ?????? ??????? ?? ??? ??????? ?? ???? ??????. ???????? ??? ????? ? ??? ??? ??? ???????:
    • ??? ???? ?????????? ?????? ????? SQL2KDeskSP3.exe ??? ???? ??? ????????? ????? ??.
    • ??? ??? ?????? ??? ???? ?????? ????? LLL_SQL2KDeskSP3.exe ??? ????? LLL ??? ?????.
??????? ??????? SP3a MSDE 2000

??? ????? SQL2KDeskSP3.exe ?? LLL_SQL2KDeskSP3.exe ? ??????? ??????? MSDE 2000 SP3a:
  • ???? "?????? Windows" ?? ????? ??? ?????? ???? ??? ?????? ??? ??????? MSDE 2000 SP3a (SQL2KDeskSP3.exe ?? LLL_SQL2KDeskSP3.exe ??? ????? LLL ??? ?????)
  • ???? ????? ??????? ??? ??? ??????? MSDE SP3a ??????? ???????. ??? ????? ? ??? ?????? ???? ???? ?? ??? ??????? ??????? SP3a.

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

?????? SP3a ?????? ??????? ??????? ?? ??????? ???????. ?????? ??? ???? ??????? ???????? ??? ?? ?? ???????? ??????? ?? SQL Server 2000 ?? ??????? ??? ????? ???? ??????? ???:
  • ?????? ????? ????????
  • ????? ???????
  • ???? ??? ??????
  • ???? ?????? ????? ?????
  • ???? ????? ????????
???? ?????? ????? ?? ?? ?? ??????? ??????? ??? ?????? (????????) ???? ???? ????? ??? ??????.

??? ??? ?????

??? ??? ???? ???? ????? ?????? SQL Server 2000 ?? MSDE 2000 ??????? ?????? ????? ????? ???? ?? ???? ??????? ?????? ?? ??? ??? ???? ?? ???? ????? ?????? ?? MSDE 2000 ????? ???????? ??????? ??? ??? ???????.

??? ???? ????? SP3a ??? ?? ????? ??? ???? ?????? ??????? ??? ??? ?????? ????????:
  • ?????: ???? ????? ?????? ????? ??? ????? ??? ?????? ?????? ?? Windows XP
  • ??? ?????? ?????? ???? ????? ???? ?????? ????? ??? ????? ????? ??????? Windows 2000

    ?? ???? ??????? ??????? "??? ?????? ???????? ??? ?????? ??? ?????? ???? ??? ????? SP3a. ??? ???????? ????? ?????? ????? ??? ?? ??????? ????? ??? ?????? ???????.
???????? ???? ??????? ??? ??????? ????????? ???? ?????? ???.

??? ????? SQL Server 2000 SP3a ??? ??????? ???? ????? ??????? Windows XP ? MDAC 2.7 ??? ?? ??? ????? MDAC 2.7 Service Pack 1a (SP1a). ??? ???? ?????? ?? ?? ????????? ??????? ?? MDAC 2.7 SP1a, ??? ????? ????? ???? ?????? Service Pack 1 ?????? ?? Windows XP ??? ????? SQL Server 2000 SP3a. ???? ????? Windows XP SP1 ???? ????????? ??????? ?? MDAC 2.7 SP1a.

??? ????? ???? ?????? ??? ??? ????? ?????? ?? Microsoft Windows Server 2003 ???? 3683 ?? ???? ? ??? ????? ????? ????? ???????:

???????? ???? ???? ??????? ?? ?????? ?????? ?????? ?? ?????? ?? ??? ??????? ?? Windows ???? Windows. ?? ??? ????? ??? ????????. ???? ?????? ??????.

????? ?????? ????? ??? ???????. ???? ??? "?????" ??????? ???????.

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

??? ????? ???? ?????? ??? ??? ??????? ???? ????? ??????? Windows NT 4.0 Service Pack 6a ? ??? ????? ??????? ?????? ?????? ?? ????? "????? ????? Microsoft" 258437.

??? ????? SP3a ??? ??????? ??????? ?? Windows NT 4.0 ???? ????????? ???????? ?? ????? ??????? 259484. ????? ?????? ??? ????? ??? ??????? ??? ???????? ?? ????? ????? ????? ??? ?????? Microsoft. ?????? ??? ??????? ??? ????? ?? ????? ????? ???? ?????? 1.5 ?????? ??????? ??? SP3a.

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

??? ??? ?????? SP3a ?????? ????? ???????? ??? ???? SQL Server ??? ??????? ??? ?? ????? "????? ???????" ????? ?? ???? ??????? ??? ????? ???????? ????? Sp3_serv_uni.sql. ??? ??? ???? ??? ????? ????????? ?? ????? ??????? ??? ????.
  • ?? ???? ??? ??? ???? SQL Server 2000 ?????? ??? ????? ??? ??????? ????? ?????? ???????? ?? ????? ???? (??????? ?????? ?? ???? ???????) ?? SQL Server 2000 ?? MSDE 2000 ????????? ??? ??? ????? ???????? ????? ???? ????? ?????? ???????? ????? ?? ???????? ????? ????????. ??? ?? ??? ????? ?????? ???????? ????? ?? ???????? ????? ???????? ???? ???? ????? ????????? ?? ???? ?????? ?? ????? SQL Server 2000 ?? MSDE 2000 ?? ??????? ??? ???? ????? ????? ??? ?? SQL Server 2000 ?? MSDE 2000. ???? ???????? ?????? ????? ???????? ?? ????? ?? ????? ????????? ???? 5.3.6 ?????? ??????? ??? ????? ????????.
????? SP3a ?????? ????? ?????? ???????? ???? ????? ?? ???????? ????? ????????. ??? ????? SP3a ? ???? ?? ?? ????? ???????? ????? ???????? ? filegroups ????? ??????? ????? ??? ???? ???????? ???? ??? ????? ?????? "???????" ??? ?????? ??? ????? ????????. ?????? ??? ???? ?? ????????? ??? ????? SP3a ??? ????? ???????? ???? ?? ??????? ?? ???????? ????? ???????? ???? "????? 3.11 ??????" ??? "?????? ?????".

??? ????? ??????? SP3a ????? ???????? ???????? ?? filegroups ????? ??????? ?????, ????:
  • ??? ????? ????????? ????? ???????? SP3a ??? ???? ????? ???????? ???????? ???? ???????.
  • ????? ?????? ??????? ????? ????? ???????? ??? ???? ??????? ??? ??????? ???? ??? ?? Winnt\Sqlsp.log.
  • ???? ????? ??????? ???????:

    ??? ??????? ?? ???? ?? ???? ?? ????? ???????? ? filegroups ????? ??? ???? ???????.
????? ????? ??? ??????? ?? ?? ??? ??? ????? ???????? ???????? ?? ??? ??????? ????? ?? ???????? ????? ????????. ??? ??? ?? ?? ????? ???????? ??? ???? ??????? ?? ??? ??????? ????? ???????? ????? ???????? ??? ?? ?????? ????? ???????? ??? ???? ??????? ?? ????? ????? ????? SP3a ???? ?????? ?? SQL Server 2000.

?????? ?? ???? ??? ??????? ??? ?????? ??????? ??? ???????. ????? ?? ????????? ??? ?????? ??????? ??? ??????? ???? "?????? ??????? ??? ??????? 4.1 ????".

??? ???? ????? ???????? ??? ???? ??????? ?? ??? ??????? ??? ? ?? ??? ???? ?????? ????? ????? ??? ??????? ??? SP3a. ??? ???? ??? ???? ????? ???????? ????? ????? ????? ?????? ???? ????? ??????, ??? ????:
  • ?????? ????? ?????? ??? ????? ??? ????? SP3a.
  • ????? SP3a ??????.
  • ????? ????? ???????? ????? ?????.
  • ????? ?????? ??? "???? ???????" ?????? ???????? ????? ??????:
    USE master
    GO
    EXEC sp_vpupgrade_replication
    GO
    
??? ??? ?????? SP3a ??? ?????? ???????? ??? ????? ???? ????? ???????? ??? ??????? ????? ????? ??? ????? ?????? ??????? ?????? ??? ?????:
??? sp_vpupgrade_replication "????? ??????? ??????" (1)
?? ???? ???? ??? ????? ???? ??????? ?????.

?????? ????? ???????? ???? ????? ?? ???? ??? ??? ????? ???????? ??????? ??? ?????? ???????? ???? ??? ???? ?? ?? ???? ????? ???. ??? ????? ???????? ?????? ?????? ?? filegroup ??? ?? ?? ?? ?????? ??????? ????? ??????? ???????? ?? ???????? ????? ??????, ??? ????? ????? ???? ??????? ??? ????? ????? ???????? ????? ??????? ?????.

Note ??? ???? ????? ???????? ??? ???? ??????? ?? ??? ??????? ??? ? ?? ??? ???? ?????? ????? ????? ??? ??????? ??? SP3a.

??? ???? ????? Systems Management Server ??????? ???????

?? ????? ????? ???? ???? ?? SQL Server 2000 a? ?? ???. ??? ???? ????? ??????? Microsoft Systems Management Server ?????? SP3a ???????? ??? ??? ????? ????????? ???? ????? Windows NT Server 4.0. ?????? ????? ??? ???? ??????? ??? ????? ???? (Smssql2ksp3.pdf) ?????? ????? ???? SQL Server ?? "???? ????? ???????". SQL Server ???? ???? ?? ????? ?????? ?????? ??? ????? ????????? ???? ???? ??? "???? ????? ???????". ????? Sms2kdef.bat ?? ??? ???? ???? ???? ?????? ????? ??? ????? ???????? "???? ????? ???????". ?? ??? ????? ?? ????? ?????? "???????" ???? ?????? ???????? ?? ??????? ?????? ??? ????? ????? ?? ?? ???? ???? ????? ????? ????????.

Note ?? ????? ??????? "???? ????? ???????" ?????? Desktop Engine SP3a.

3.1 ????? ????????? ????? ????? ?????? ???? SQL

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

????? ??? ??????? ???????? msdb ?????? ???? ??? ???????? SP3a ?????? ????? ???????? ?? SP3a ???? ??? ??????. ????? SP3a ????? ????? ??????? ? msdb ? ????? ?????? ???? ?????? ??? ?????? ?? ??????? SQL Server ??? ???? ?????? SP3. ????? ?????????? ??? ?????? ??? ???? ????? ????? SQL Server 2000 SP3 ?? SP3a.

??? ????? prudent ???? ???? ???????? ?? ????? ???????? ???????? ? ??? ????? ?? ?? ???? SP3a ????????? ??? ??? ????? ?????? ???????? ???? ????? ?? ???????? ????? ????????.

3.2 ??? ???? ????? ???? Analysis Services ????? ?????? ? ??????

????? ????????? ??????? ??? ??? Analysis Services.

??? ????? SP3a ????? ????? ? ????? ????????? Analysis Services ????? ???????? ?????? ????? ???? ?? ???? Services\Data ????? Microsoft ???? ??? ??????? ???? ??????? ??? ????? C:\Program ??????. ??? ?? ????? ??????? Analysis Services ??? SQL Server ? ??? ???? ???????? ?? ????? Msmdrep.mdb ??????? ?? ?????? Services\Bin ????? Microsoft. ??? ????? ??? ????? ?? ????? ??????? ??????? ?????? ?? ???? ????? Regedit.exe ???????? ?????? ????? ??? ??????? ?? ??????? ????? ?????? ???????
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAPServer
??? ??? ????? ?????????. ??? ????? ??????? ????? ????? SQL Server ?????? ???? ???????? ?? ????? ???????? ???? ????? ??? ??????? ??? ????? SP3a. ????? ?? ?????????? ???? ????? ????? SP3a ????? ??????? ?? SQL Server 2000.

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

????? ????????? ??????? ??? ???? ?????? ????? ?????? ??? ?????? ?????? ????? ?????? "????? ???????".

??? ?? ??? ????? ?????? autogrow ?????? ?????? ? msdb ??? ?? ???? ????? ???????? 500 ???? ???? ??? ????? ?? ??????? ?????. ?????? ?? ???? ????? ??? ??? ??????? ? ????? ?????? sp_spaceused ????? ??????? ?????? ???????? ???????? ?? msdb. ??? ???? ??????? ??? ??????? ?? ?? ??? ?? 500 ???? ????, ?? ?????? ??? ????? ????????. ????? ?? ?????????? ???? "????? ????? ??????" ?? "??? SQL Server ???????".

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

?????? ?? ????? ?????? autogrow ?? SQL Server 2000 ??? ????? ??????? SQL Server ? ???? ??? ?????? ?????? ??? ??? ????? ???????? ?? ???? ??? Properties.Verify ???? ???????? ????? ??? ????? ???? ????????.

?????? ?? ????? ??? ?????? ?? MSDE 2000 ?????? ?????? ???????? osql ???? ??????? ?????? ?????? SQL ???????:
  • sp_helpdb ????????
  • sp_helpdb msdb
?? ???????? ??? ???????? ???? ?? ?? ???? ?????? ??? ??? 0.

3.4 ????? ??????? ?????????? ??? ????? ??????? SP3a

????? ????????? ??????? ??? ???? ????????. ????? ????? SP3a ??? ????? ????? ???????.

??? ??? ?? ???? ?????? ????? ? ??? ??????? ?????? ????? ???? ????????? ??? ?????? ???????. ??? ????? ?????, ???? ??? ????? ??????? ???????:
  • Microsoft ???? ????????? ??????? (MS DTC) ? Microsoft Search ?????? MSSQLServerOLAPService. .
  • ????? MSSQLServer ? SQLServerAgent ?????? ?????? (??? ???? ??????? MSSQL $ NamedInstance).
  • ????? ???????? Microsoft ? Microsoft ??? ??????? ?? ????? ?????? ? Microsoft COM ?????? ?????????.
  • ???? ?????????? ??? ???? ???? ?????? ". (???????)
????? ????? SP3a ??? ????? ????? ????????? ??? ????? ????? ??? ??????? ?????????? ??? ????? ?? SP3a.

?? ???? ????? ??????? ?? ???? ????? ??? ???. ????? ?? ?????????? ???? "????? 3.10 ??????" ??? ???? ?????? ????? ?????.

3.5 ????? SP3a ?????? ????? ????????

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

????? ???????? ????? Setup.bat ?? ??? ??????? ???????:
  • ?????? ??? ????????? ?????? ???? ????? ??? ????? ???? ??????? ????????? ?? SQL2KSP3.exe.
  • ???? ???? ?????? ??? ???????? SP3a ????? ?? SQL Server 2000.
  • ?????? ??? ?????? ???? ??????? ???? ????? ??? ????? ???? ??????? ????????? ?? SQL2KSP3.exe.
?????? ?????? ?????? ????? ???????? ?? ?????? ??? ???? ???? ??? ????? ???? ??? ????????? ???????:
  • ????? ?????? ?????? ???? ????? ??? ????? ???? ??????? ????????? ??? ??? ???? ????? ?????? ??? ????????? ??????, ????? ??? ?????? ??? ???? ??????? ??????? ???? ????? ??? Setup.bat ?? ?? ?????? Setup.bat.
  • ????? ??????? ?????? ????? ????? Setupsql.exe ?? \X86\Setup ???? ???? ?? ?????? ??? ?????? ???? ??????? ???? ????? ??? ????? ???? ??????? ????????.
???? ?????? ??????? ???? ???? ???? ?????? ??????? ??? ?? ??? ??? ???? ??????? ?????? ???? SQL ?? ?????? Windows. ??? ????? "?????? ???? SQL" ? ??? ????? ?????? "???????" ???????? ???? ???? ????? ?????? sa. ??? ????? "?????? Windows" ? ??? ????? ?????? "???????" ????? ????? ?????? ??? Windows ???????? ???? ????? ???? Windows. ??? ?? ???? ???? ????? ?????? ??? ??? ?? ????? ?????? sysadmin ???? ??? ???? ???? ?? SQL Server 2000 ???? ???? ????????.

?? ???? ?????? ??????? ?????? ?????? ???????:
  • ???? ???? ???? ??? ?????? ??? ??? ?? ??????? ?????? "?????? ????? ??????" ?? ???? ???? ????? ?????? ?????? sa. ??? ???? ???? ????? ?????? sa ????? ???? ?????????? ???? ?????? ??????? ??? SQL Server ?? Desktop Engine ??? ??? ??????; ????? ??????? ?????? ??? ???? ???? sa ?? ?????? ??????? ?????? Windows. ?????? ??? ?????? ?? ????????? ??? ???? ?????? ???, ???? "???? ???? ??? ????????" ?????? ?? ??? ??????.
  • ???? ???? ???? ????? ???? ???? SA ??? ??? ???? ???? ????? ?????? ?????? sa. ??? ????? ?? ??? ????? ?????? ??????? ????? ???? ????? ????? ?????? sa ??????? ???? ???? ?????? ??? ??????? ??? ?????? "?????? ???????" ? ???? ???? ????? ?????? ????? ??? ?????? ? ??? ??????. ??? ??? ???? ?????? ??? ??? ????? ?? ??? ???????? ???????.

    ?????? ????? ??? ??????? ???? ?????? ?????; ??? ?? ???? ??? ????? ?? ???? ??? ????? ???? ??????.
  • ?? ????? ??? ??????? ????? ?????? ??????? ????? ???? ???? ???? ?? ?? ???????? ?? ????????? ??????? ???? ??? ??? ????? ???? ???????. ?????? ??? ?????? ?? ????????? ??? ???? ?????? ???, ???? "????? ??????? ????? ?????? ???? ????" ?????? ?? ??? ??????.
  • ???? ???? ???? ??? ??? ?? ?? ????? ???????? ?? filegroups ??? ???? ???????. ??? ??? ?????? ?? ???? ?? ?? ??? ????? ???????? ?? filegroups ????? ?? ???????? ????? ???????? ????? ???:
    • ????? ????? ??????? ?????? ??? ???????? ???? ??????? ?? ??? ????? ???????.
    • ?????? ????? ??????? SP3a ?????? ?? ?????? ????? SP3a ?? ??? ???? ??? ????? ??? ???????? ???? ???????.

      ?????? ??????? ??????? ??? ??????? ??? ????? SP3a ??? ????? ???????? ??? ???? ??????? ?? filegroups ???? ????? ????? ?? ???????? ????? ????????. ????? ?? ?????????? ???? ?????? SP3a ????? 3.12 ??? ????? ?????? Read-Only ?? Filegroups.
  • ???? ???? ???? ???????? ??? ??????? ??? ????? ????? ???? ??????? ?? SP3a ??????? ?? ??????? ???????. ?????? ??? ???? ?? ????????? ??? ??????? ?? ????? ???? ?????? 5.10 ???????? ???.
  • ????? ?????? MDAC ??? ??? ?????. ????? ?? ?????????? ???? ?????? 5.5.1 ????????? ??? ?????? Microsoft Access Components.
  • ??????? ??????? ???????? ?? SQL Server 2000 SP3a ???????
  • ????? ????? ??????? ?????? Transact-SQL ?????? ???? ????????? ???????
  • ??? ???? ????? ????? ????????? ?? ???? ?????? ???????? ??? ???? ????? ????? ????? ?????.


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

?? ???????? ???? ?????? "??? ??????" ????????? ??????? ?? ??? ???????. ???? ?????? ????????? ??????????:
  • ??? ????? ????????? ???? ????? Windows 98 ?? Windows Millennium ???? ??????? ????????? ?? "?????? ??? ??????" (??? ?????? ??? ?????? ??? ????? ??????? ???). ?????? ???? ?????? ????? ???? ???? ????? ?????? sa. ??? ??? ?????? ???? ????? ?????? ??????? ?????? ???? ???? ????? ?????? sa. ??? ???? ???? ?????? ????? ????? ??????? ??? ????? ???? ??????
  • ??? ????? ????????? ???? ????? Windows NT 4.0 ?? Windows 2000 ??????? ????????? ?? ?????? Windows. ?????? ???? ?????? ??????? ??? ??? ?????? Windows ?? ????? ?????? ?? ???? ????? ???? sa ??? ????.

    ?????? ??? ????? ??? ?????? ?? ???? ?????? ?????? ?????? sa, ???? ?? ?? ?? ???? ??? ??????? ??? ????????? ????????. ??? ???? ??????? ??? ??? ?????? ???? SQL Server ?? ??????? "?????? ????? ??????" ???????? ?????? Windows "? ?? ???? ??????? ????????? ???????? ?????? ??????? ???????? ?????? ???? SQL ??? ??? ????? ??? ???????? ??? ?????? Windows. ?????? ??? ??? ?????? ???? ???? ????? ?????? sa ????????? ?? ???????? ???????? ???????? ???? ?????? ??????? ?? ???? ??????? ??? ????? ???????? ???? ?????? ???????.
??? ?????? ????? ???????? ??? ????? ???? ???? ???? ????? ??? ????? ?????? sa.

??? ?????? "???????" ???? ?? ????????? ???? ?????? ?? ????? Sqlsp.log. ??? ????? ??? ????? ??? ?? Windows ???? ?? ????????? ???? ??? ????? ???????. ??? ??? ???? ???????? ?????? ?????? ????? ??????? ??? ?? ??? ?????.

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

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

?? ???? ?????? ????? ??????? ?? ????????? ??????? ?? ???? ?????? ???:
  • ??? ??????? ?? SP2 ?? ????????? ??????? SP3a ?????? ???? ????? ?? Microsoft ???? ???????? rebuilds ??????? ??????? ???? ?????? ????? ??????? ???????? ??????. ????? ????? ????? ? ????? ???? ?????? ?? ?? ????? ???? ????. ??? ????? ???? ???????? ??? ??? ?????? ???????. ????? ?? ?????????? ???? ?????? 5.1.5 ?? ???? ???????? ?? ????? ??????? ??? ?????? ???????.
  • ??? ????? ???? ??????? ??? ????? ??????? ???? ?????/??? SQL Server 2000. ????????? ??????? ?? SP3a ??????? ?? ???????? ???? ???? ????? ??????? SQL Server 2000 SP3 ?? SP3a ???. ??? ????? ???? ???????? ??? ??? ?????? ???????. ????? ?? ?????????? ???? ?????? 5.4.2 ????????? ??? "??????? ????" ?????/?????.
  • ?? ????? ????? ????? ????? ????? ???????? ???????? ???? ??????? ?? ???? ?????? ???. ??? ???????? ????? ????? ????? ????? ????? ???????? ???????? ?????? ?????? ?????. ???? ????? ???? ???????? ??? ??????? ????? ?? ?????? ????? ????? ???????? ??? ????? ??????? ????? ????? ??????. ????? ?? ?????????? ???? ?????? 5.1.11 ????? ???????? ???????? "??????? ?????".

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

    ?????? ??? ??? ?????? ????? ????? ????? ???????? ??? ????? ??? ????? ?? ??? ????? ?? SP3 (??? ???? 8.00.760) ??? ????? ??? ???? ??? ????? SP3a.

3.6 ????? SP3a ????? ?????

????? ????????? ??????? ??? ??? "????? ???????".

?????? SP3a ????? ????? ????? Setup.exe ?? ?? ?? ??????? ???????:
  • ???? ???? Msolap\Install ?? ?????? ???? ????? ??? ??????? SP3a ????? ????? ????????? ?? SQL2KASP3.exe.
  • ???? Msolap\Install ??? ????? ??????? SP3a.
?? ???? ?????? ??????? ?????? ?????? ???????:
  • ??? ???? ???? "?????" ?????? ?????? ??? ???????. ????? ?? ????????? ??? ??????? ?? ????? ???? ???????? ??? 5.10.
  • ???? ???? ???? ???????? ??? ??????? ??? ????? ????? ???? ????? ?? SP3a ??????? ?? ??????? ???????.
  • ???? ??????? ???????? ?? ?????? ???????


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

??? ????? SP3a ????? ????? ???? ????? ??? ????? ????????? ????????? ?? ??? ??????? ?? ??? ??? SP3 ?? SP3a. ???? ???? ????? ????? ????? ??????? ??? ?????? ??????? ?? ???? ???????? "????? ???????:

???? ??????? ????? ??? ?????? (???_??????) ?? ??? ??? ?????? ????????? OLAP ??? ??????.

??? ????? "????? ?????? ???????" ??? ???? ???? ???? RepositoryUser ? ????? ???? ????????? ?????? ?????? ??????? ??????? ?? ????? ?????? msdb. ?? ????? ??? RepositoryUser ????? ? ????? ? ??? ? ????? ???????? ??? ????? msdb. ?? ??????? ??? ????? ?????? ??? ?????? ? ?? ??? ???????? ??? ??? ???????. ??? ?? ????? ?????? ??????? ?????? ????????? OLAP ??? ?? ??? ?????? ??? ??? RepositoryUser ???? ???? ?????? ??? ???????? ?????? ??????? ??? ????? ???? ??????:
  • ??????? ????? "????? ?????? ???????".
  • ??????? ?????? ????? ?????? msdb.
  • ??????? ?????? ????????? OLAP ?????? ??? ????? ?????? ???????.
?????????? ??? ??????? ????? ??? ???????? ??????? ???? ?????? ?????? ??? "?????? ???????" ??????? Services ??? ???? ??? ?????? ??? SP3 ?? SP3a. ??? ????? ??????? ???? ?????? ?????? ??? ??? RepositoryUser ?????.

?????? ??? ????? ?????? ????????? OLAP ??? ??? RepositoryUser ??? ??????? "????? ?????? ???????" repositorythat ?? ????? ??? ??????? ??? ??? ??????? ??? SP3 ?? SP3a; ????? ????? ????? ?????????.

????? ?? ????????? ??? ????? RepositoryUser ???? ?????? 5.6.3 "??? RepositoryUser ????" ?? "?????? ??? ??????? ?????".

??? ??? "??????? ????? ????????" ?????? ????? ??? ??????? ???? ?? ???? ???? ?????? ?????? ????? ? ??? ???? ????? ???????? ??? ?????? ??? ????? ??????? SP3a. ????? ?? ?????????? ???? "??? ??????" ???? 5.2.10 ??????? ?? "????" ???????? "??????".
3.7.2 ???????? ?????? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

??? ?????? SP3a ???? ????? ??? ?????? ????? ?? ??????? ???????? ?????? ?? ????? ?????? SQL Server 2000 Desktop Engine (MSDE 2000). ???? ????? ???? ??????? ??????? MSDE 2000 ?? ??????? ?? SP3a ???? ??? ??????, ???? ???? ????? ????? ?? ????? ???? MSDE 2000. ????? ?? ????????? ??? ????? MSDE 2000 ???? ????????? MSDE 2000.

?? ?? ????? ?? ????? Desktop Engine SP3a ?????? ?MSDE 2000 ???? ?? ??????? ?????? ??????? ?????? ???????? ?? application.You ???? ??????? ????? ??????? ???? ????? ???? ???? ???????? ?????? ??? ??????? MSDE 2000. ?????? ??? ??????? ??? ????? ????? ?? ??? ??? ???? MSDE 2000 ??? ??? ??? ????? ???? ?????? ????? 2.1 SP3a ??????? Desktop Engine (MSDE 2000).
???? ??????? ??????? ??????? ???? ??? ????? SP3a MSDE 2000:
  • 3.7.1 ????????? ??????? MSDE 2000 SP3a
  • 3.7.2 ???????? ?????? MSDE 2000 SP3a
  • 3.7.3 MSDE 2000 ????? ??????
???? ??????? ??????? ???????????? ?????? ?????? ??????? ????? ????? ?? MSDE ??? SP3a ?? ????? ???? ???? ?? MSDE 2000 SP3a:
  • 3.7.4 ????? ?????? MSDE 2000 ????? ??? SP3a
  • 3.7.5 ????? ???? ???? ?? MSDE 2000 SP3a
  • 3.7.6 ??????? MSDE 1.0 ??? MSDE 2000 SP3a
??? ??? ?? ???? ??? ??????? ?????? ?????? ??????? ??????? ?????? ??? ?????? ??????? MSDE 2000 SP3a ??? SQL Server 2000 ???????? (Updated - SP3). ???? ??? ????????? ???? ????? ??? MSDE 2000 SP3 ? SP3a ?? ????? ???? ???? ?? SQL Server 2000 ???????? (Updated - SP3) ? ??? ????? ??? ??????? ?? ??? ????? ????????. ????? ?? ????????? ??? ????? SQL Server 2000 ???????? (Updated - SP3) ???? ?????? 1-6 "????? ??????? Online ????? ?? ????????".
3.7.1 ????????? ??????? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

????? ????????? ??????? ??? ?????? ??????? SP3a SQL Server 2000 Desktop Engine (MSDE 2000).

??? ????? MSDE 2000 ? ??? ????? Desktop Engine SP3a ???? ????? ??? ?? ???? MSDE 2000.

?????? ?? ???? Microsoft ??????? ??? ???? ???? ?? 16 ?????? ???? ????? ???????? ??? ???? ??????? ????. ????? ??? ?????? SQL Server 6.5 ? SQL Server 7.0 SQL Server 2000 MSDE 1.0 ? MSDE 2000.

????? ??? ????? ????? MSDE 2000 ?? ???? ????? Setup.exe. ?? ??? ?????? ????? ?????? ?????? ??????? ??? ????? .msi MSDE 2000 ??? ?????? ??????? ??? ??? ????? .msi MSDE 2000. ??? ????? ?????? ??????? ?? ???? ??????? ?? ??? ?????? ????? ?? ????? ?? ???? MSDE. ?????? ??? ???? ?? ????????? ??? ???????? ???????? ???? ??????? 3.7.2 ???? 3.7.6.

???? ?? ???? ????? ??? ??? ?????? "????? ?????? ???????" ??????? ????? ?????? ????? ????? ?? MSDE SP3a ?? ????? ???? ???? ?? MSDE 2000 SP3a. ??? ?? ??? ?????? ????? ????? ????? ????? ??????? ?? ????????? ??????.

??? ?? ???? ??? ?????? ????? MSDE ????? ?? ????? ???????? ?????? ????? 2000 SP3a MSDE. ??? ?? ????? ?? ????? ???? ???? MSDE ??? ??????? ??????? INSTANCENAME ?????? ??? ??????. ??? ?? ???? INSTANCENAME ???? ??????? ??? ?????? ????????? MSDE ??? ??? ?????????. ?? ????????? ?? ????? 2000 MSDE ??? SP3 ??????? ?????????? ?????? ??? ????? ??? ???? ??????? .msi ????? ?? ????? ???? MSDE 2000. ?? SP3 ?????????? ??????? ?? ??????? ????? ????? ????? .msi ?? ?? ????? ?????? ??? .msi ????? ?? ????? ????.

????? ????? ????? SP3a MSDE 2000 ?? ???? ????? ?????? ?? ??? ?????? ???? ?? ??? ?????. ??? ????? ???? MSDE 2000 ??? SP3a ? ????? ??? ????? ??????? ?? ?????? ??? ???? ?? ????? ????? ??? ???? ??????? ?????? ???????? ?????? ???? MSDE 2000 ?? ???? ?????? ?? ???? ???? ?????? ????? ??????? ??????. ??? ??? ??????? ?????? ?? ??? ????? ? ????? ??????? MSDE 2000 SP3a ??????? ?????? ????? ???????. ??? ?? ??? ?????? ??????? ??????? ?? ?????? ?????? ?? ??? ?? ????? ????? ??????? ?????? ??? ??? ??????? MSDE 2000 SP3a ??? ???? ????? ?????? ?? ?? ?????? ?????? ??????? ?? ????.

??? ??? ?????? ???????? ?????? ?? ?????? SP3a ??? ?? ???? ????? ???? ??????? ??? ????? ??????? SQL2KSP3. ??? ??? ???? ????? ????? (ISV) ????? ??? ????? ?? ??? ????? Desktop Engine ????? ??????? ????? ?? ??? ?? ???? ????? ???? ??????? ???????? ??????? VolumeLabel ??????? ?? ???? Media ???? Windows Installer (*.msi).
????? ????? ??????? Desktop Engine ?? ????? ????? ??? ??? ??? ?????? ??????? 2.0.2600.0 ????? Windows ?? ??????.??? ????? ??? ????? Windows Installer ? SP3a ????? ??????? ???????? ?????? Windows Installer.

?????? Windows Installer:
  1. ???????? "?????? Windows?" ????? ??? ?????? \MSDE\MSI ??? ?? SQL Server 2000 SP3a ???????? ?? ?? ???????? ???? ??? ???????? ?? SQL2KDeskSP3.exe.
  2. ????? InstMsi20.exe.
  3. ??? ????????? ??? ????? ???? ?????????.
3.7.2 ???????? ?????? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

??? ?? ????? ???? ????? MSDE 2000 ?? SP3a ???? ???? ????????? ?????????? ????? ???? ??????.

????? ??? ?????? SP3a ???? ?????? ????????? ??????? ??????? DISABLENETWORKPROTOCOLS ???? ???? ????? ?????? ????? ?????? ????? MSDE 2000. ??? ??? ?? ???? ????? ??? ??????? ??? ??????? ??? ????? ?? ???? MSDE 2000 ?????? ?? ?? ???? ???? ?????? ??? ??? ???? ??????? ??? prudent ?????? ????? ???? ??? ?????????. SP3a ??? ????? ????? ?????? ?????? ???? ??????? ??? ????? ???? ?????? MSDE 2000. ??? ?? ????? ?????? ???? ??? ????? ???? MSDE 2000 SP3a ????? ????? ????? ?????? ?????? ????? ??????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ?????? ?????????? ???? ????? ??????? 814130.

???? ???????? ??????? MSDE 2000 SP3a ?? ??? ????? ???? ???? ?? MSDE 2000 ??? ??? ??????? ??????? SAPWD ?????? sa ???? ???? ??????. ???? ???????? ??????? MSDE 2000 SP3a ??? ?? ????? ????? ????? ?? MSDE 2000 ??? ??? ?? ????? ???? ???? ???? sa ????? ??????. ??? ????? ???? ???? ????? ?????? ?????? sa ??? ??? ????? ????? ????? ??? ??? ??? ??????? ???? ?????? ?????? MSDE ????? ?????? ??? ???? ???? sa ?????. ??? ??? ???? MSDE 2000 ??? ??????? ?? ??? ?????? Windows ? ???? ????? ?????? sa ????? ?????? ??? ??? ??? ????? ?????? ??? "??? ??????". ?? ??? ??????? ???? ???? sa ????? ?? ?????, ???? ?? ?????? ?????? ??? ?????? ??. ??? ??? ????? ??? ????? ???? ???? ???? sa ??? ??????? ?????? ?? MSDE 2000 ??? SP3a ???? ????? "????? ??????? ?? Microsoft" 322336.

???? ????? ?????? ??? ???? ????? ?????? ?????? Windows ?? ????? MSDE 2000. ?? ???? ???????? ??????? ?? "??? ??????" ??? ??? ?????? Windows ???:
  • ???? ????? ????????? ???? ?????? MSDE 2000 ???????? Windows ????????.
  • ??? ?????? ??????? ?????? ?????? Windows ????? ?????????? ????? ??????? ??? ??????? ??????. ?????? ??? ???? ?? ????????? ??? ????? ??????? ?????? ???? "????? ?????? Windows ?? ?????? ?? SQL Server 2000 ????????".
  • ??? ????? ???? MSDE 2000 ??? ???? ??????? Windows 98 ?? Windows Me.
?????? ??? ???? ?? ????????? ??? ????? ???? MSDE 2000 ?? "??? ??????" ??? ??? ?????? Windows ???? ????? ??????? 322336.
3.7.3 MSDE 2000 ????? ??????
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

????? ????? ?? ??????? MSDE 2000 ???? ??????? ?????? ?????? ????? ???????. ??? ??? MSDE 2000 ??? ?????? ????? ???????. ????? "?????? ???????" MSDE 2000 ????? ???? ????????? ?????? ?????? ?????? ?????? ??????? "? ??? ??? ?????? ??? ??????? ???????? ??????? ???????? ?? ??? ????? ???????. ????? MSDE 2000 ????? ????? ?????:
  • ???? ??????? ???? ??????? ????????. ???? ??????? ???????? ???? ????? ?????? ???? ????? ?????? ????? ???? ???? ????? ????? ?? ???? ???? ???????. ??? ??? ?????? ???????? ?????? MSDE 2000 ????? ?????? ?????? ?????? ????? ?????? ???????? ?? ?????? ??????. ????? ?? ???? ???? ??? ?????? ???????? ???? ?????? ?? ???????? ???? ????? ?????????? ???? ????? ??????? ?????? ????????.
  • ?????? ?? ??????? ??????? ??? Windows Installer. ???? ???????? ????? ??????? ??????? ???????? ??????? ??????? ??? Windows Installer ????????? ???????? ?????? ??? ????? ??????? ?????? ???? MSDE 2000 ?? ???? ???? ?????? ??????? ??????? ??? MSDE 2000. ???? ???????? ?????? ????? ???? ??????? ?????? ????? ????? ???? ??????? ???? ?????? ?? MSDE 2000 ????? ?????? ?????? ????????.
???? ?????????? ??????? ???? ??????? ?????? ???????? ????? MSDE 2000 ??? ???????? ???????? ??????? ?? MSDE ?? ????? ???? ?????? MSDE 2000. ?????? ?????????? ?????? MSDE 2000 Setup ?????? ????? ??????. ???? ????? ?????? ??????? ????? ????????? ?????????:
  • ??? ??? ???????.
  • ?? ??? .ini ??????? ?????? ???? ??????? ????????.
??? ????? ???? ?????? ???????? ?? ??? ????? MSDE 2000 SP3a ??????? ?? ??????? "????? ??? ?????? ???? Setup.exe" ?? SQL Server 2000 ???????? (Updated ? SP3). ????? ?? ????????? ??? ????? SQL Server 2000 ???????? ???? ?????? 1-6 "????? ??????? Online ????? ?? ????????".

??? ???? ????? ????? ?????? MSDE ???????? ?? ?????? ?????? ?????? ??? ??? ?????? ??????? ??? ???? ????? ??? ????????. ???? ???? ?????? ???????? ???????.

??? ???????? MSDE 2000 SP3a ????? ??? ?? ??? ??????? ?? SQL Server 2000 ???????? (Updated ? SP3) ?? ???? ???? ????? ?? ?????? ?? "??????? ????????".
?? ??? ??????????? ??? ??????
??? ??????????
ALLOWXDBCHAINING = 1????? ??? - ????? ????? ???????. ????? ?? ?????????? ???? "???????" ????? ???????? ???????? ???? 5.1.11 ?????.
SAPWD = sa_password????? ???? ???? ??? ?????? ??? ????? ?????? sa ??? ????? ???? ???? ?? MSDE 2000. ??? ????? SAPWD ??? ????? ????? ????? ?? MSDE 2000 ??? ??? ?????? ?? ????? ?????? sa ?? ???? ???? ???? ??? ???????. ??? ????? ???? ???? sa ???? ????? ??? ??? ??????? ??? ?????? Windows. ????? ??????? SAPWD ?? ????? ??? ??? ??? ??????? ??? ????? Setup.exe ??? ??? ??? ?????? ???????? ??????? ??????? ?????.
/upgradesp {SQLRUN | SqlRunXX.msi [<msipath>]} ???? ??? ??????? ????? ?????? ????? ????? ?? MSDE 2000 ??? SP3a. ?? SP3 ?????????? ??????? ??????? ??? ??????? ??? ??? ??????? /p ???????? ?? ??? ????????? ??????? ?? ???????. ?? ?????? ??? ??????? /p ?? SP3 ?? ??????? ??????. ??? ??????? ??? SP3a ? ???? ?? ??? ?????? ?????? ??? .msi ????????? ?????? ?????? ??????? MSDE 2000. ????? ???? ?????????? ?????? SQLRUN ???? ???? ???? ???? ??????? ???????? MSDE 2000 SP3a ??? .msi ???? ??? ????????. ??? ????? SQLRUN ??? ????? INSTANCENAME ???? ?????? ??????? ????? ???? ????????? MSDE 2000 ". ??? ??? ?????? ?? SQLRUN ? INSTANCENAME ???? ?????? ??????? ????? ???? ?????? ???????? ??????? INSTANCENAME ". ??? ????? ??? ??? ???? ????? .msi MSDE 2000 ????? ?????? ??????? ????? ?? ????? ????? ?? ???? ??? ???? ????????? ?? ???? ????? ??? ???? ?????. ??? ???? ??????? ??? ???? SqlRun01.msi ????? ?????? ?????? ??????? ????? ?? ???? MSDE 2000 ????? ???????? SqlRun01.msi. MSIPath ?? ?????? ??? ?????? ????? ??? ??? .msi. ????????? MSIPath Setup\. ?????? ??? ????? ????? /upgradesp ???? ?????? 3.7.4 ????? ???????? ?????? ?? MSDE 2000 ??? SP3a
UPGRADEUSER = AnAdminLogin????? ????? ???? ???? ???????? ??? ????? ???? ?? MSDE 1.0 ?? MSDE 2000 ???????? ?????? ???? SQL. ??? ?? ???? ????? ?????? ???? ?? ????? ?????? sysadmin ???? ??? ????. ??????? ??? ??????? ??? ??? ????? SECURITYMODE = SQL ??? ????? ???? MSDE.
UPGRADEPWD = AdminPassword ????? ???? ???? ????? ?????? ??????? ?? UPGRADEUSER ??? ??????? Desktop Engine ???????? ?????? ???? SQL.
??? ?????? SP3 ???? ????? ????? DISABLENETWORKPROTOCOLS ?????. ????? ???? DISABLENETWORKPROTOCOLS ?? SP3a ???? Desktop ???? ???? ?????? ?????????.

??? ?? ????????? DISABLENETWORKPROTOCOLS ?? SP3a.
?? ??? ??????????? ??? ??????
???? DISABLENETWORKPROTOCOLS????? ???? ?????????? ???? ????
1??? ????? ?????? ?? ???? ???? ????? ?????? Net.??? ????? ?????? ?? ???? ???? ????? ?????? Net.
0??? ???????? ????? ????? ???? ?????? ??????.?? ????? ???? ?????? ????????? ?????? Net ??????? ?????.
??????? ??? ?????, ?? ??? ???? ?? 0 ?? 1??? ???????? ????? ????? ???? ?????? ??????.?? ????? ?????? ???? ?????? Net ????? ????.
?? SP3? DISABLENETWORKPROTOCOLS ??? ????? ?????????? ?? ???? ?????? SP3a:
  • ??? ????? ???? ???? ???????? SP3 DISABLENETWORKPROTOCOLS ?? ??? ??? ???? ?? ????? ???? ?? 0 ?? 1 ? ?? ????? ?????? ?? ????????? ?????? Net ??????? ?????. ?? SP3a ? ??? ????? ?????? Net.
  • ???? ?? ????? ???? ?????? Net ????? MSDE 2000 SP3 ?????? ?? ???? ?????? ???? UDP 1434. ?? SP3a ? ?????? ?? ?????? ???? UDP 1434 ?? ??? ???????. ????? ?? ?????????? ???? ?????? 5.1.15 ???????? ??? UDP ?????? 1434.
?????? ??? ???? ?? ????????? ??? ??????? ?????? ????? ????????? ???? ??????? "?????? ?????? Net ? ??????? ????????" ?? SQL Server 2000 ????????.

??? ??? ?????? ???????? ??????? ??????? ??? MSDE 2000 (????? & .msi &) ?? ?????? ????? Windows Installer ????? ????? ?????? ??????? ????? ?????? ?? ??? .msi. ???? SP3a ???? (MSDE 2000) ??? ?????? ??????? ??????? ??? ???? ????????? ???????? ???? ?????? ??????? ??????? ?????. ??? ?? ??? ????? ??????? ???????? ????? ??????? ????? ??????? ?????? ???????? ????? MSDE 2000 ????? ?? ??????? ??????? ??????? ??? MSDE 2000 ??????.
?? ??? ??????????? ??? ??????
??? ?????????? ????? ?????? ???????
allowxdbchainingSqlAllowXDBChaining
disablenetworkprotocolsSqlDisableNetworkProtocols
sapwdSqlSaPwd
upgradeuserSqlUpgradeUser
upgradepwdSqlUpgradePwd
?????? ??? ??????? ??? ????? ?????? ??????? ????? ?????? ?? ?????? ???? ????? ???? ??????? ????? "??????? ?? SQL Server Desktop Engine ??? ?????" ?? SQL Server 2000 ????????.

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

??? ??? ????? ?????? ?? ????? ?????? ??????? ????? ??? ????? ???????? ?? ????? ?????/L * v <logfilename>. <logfilename>?? ??? ??? ??? ??? ??????? ??? ??? ????? ???? ????????? ?????? ??. ??? ?? ???? ?????? ???? ?? ????? ??? ????? ??? ??? ?? ?????? ??????. ??? ??? ??? ????? "?????? ???????" ?? ????? SP3a ????? ?? SQL Server 2000 ? ??? ????? ?????? ?????? ??? ???? ??? ????? ????? ??. ???? ??? ?????? ?????? ??? ??? MSDELog.log ?? ?????? ????? ????? ??????? C::

????? sqlrun /upgradesp DISABLENETWORKPROTOCOLS = 1/L * v C:/MSDELog.log
3.7.4 ????? ?????? MSDE 2000 ????? ??? SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).
??? ??????? ?? ??? ?????? ??????? ????? ????? ?? MSDE 2000 ??? SP3a ??? ?????? ????? ?????? ???? ?????? ?? MSDE 2000 ?????. ?? ??? ?????? ??? ??? ??? ?? ?????? ????? ????????? ?? ????????? ???? ???? ??? ????? ????????? ??????, DISABLENETWORKPROTOCOLS ???????.
????? ??????? ?? ??? ?????? ?? ????? ?????? sa ?? ???? ???? ????. ????? ?? ????????? ??? ???? ???? ????? ?????? sa ???? ?????? 3.7.2 "???????? ??????" MSDE 2000 SP3a.

?????? SQL Server 2000 Desktop Engine
  1. ??? ???? ???? ???????.
  2. ?? ???? ???????? ?????? ????? cd ???????? ??? ?????? ???? ????? ??? ?????? ???????? ?????? MSDE 2000 SP3a:
    ????? ??????? c:\MSDESP3aFolder\MSDE
    ??? ?? c:\MSDESP3aFolder ??? ?????? ??? ?????? ???? ??? ???????? ??????? MSDE 2000 SP3a ?? ???? Desktop Engine SP3a ??? ??????? SP3a ????? ?? SQL Server 2000.
  3. ????? ??? ??????? ???????:
    • ?????? ??????? ???????? ?????? Windows ??? ???????:

      ????? /upgradesp sqlrun DISABLENETWORKPROTOCOLS = 1
    • ???? ???? ???????? ??? ?????? Windows ? ?????:

      ????? sqlrun /upgradesp INSTANCENAME = DISABLENETWORKPROTOCOLS ??? ???? = 1
    • ?????? ??????? ???????? "??? ??????" (??? ???? AnAdminLogin ??? ??? ????? ?????? ?????? ?????) ? ?????:

      ????? sqlrun /upgradesp SECURITYMODE = UPGRADEUSER SQL = UPGRADEPWD AnAdminLogin = DISABLENETWORKPROTOCOLS AdminPassword = 1
    • ???? ???? ???????? "??? ??????" (??? ???? AnAdminLogin ??? ??? ????? ?????? ?????? ?????) ? ?????:

      ????? sqlrun /upgradesp INSTANCENAME = SECURITYMODE ??? ???? = UPGRADEUSER SQL = UPGRADEPWD AnAdminLogin = DISABLENETWORKPROTOCOLS AdminPassword = 1
??? ??? ??? ?????? ??? .ini ????? ??????? ???? ????? ?????? ???????? ?? ????? & .ini &.

?????? ??? ????? Desktop Engine ??? ???? ??????? ???? ????? ??????? Windows 98 ?? Windows Millennium Edition, ??? ?? ??? ????? ???? Desktop Engine ???? ??????? ??? ??? ????? ???????.
3.7.5 ????? ???? ???? ?? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

??????? ?? ??? ?????? ?????? ???? ????? ?? MSDE 2000 SP3a ?? ?????? ?? ????? ???? ??????? ?????? ?? ?????. ??? ??? ??? ?? ?????? ????? ????????? ?? ????????? ???? ???? ??? ????? ????????? ??????, ????? ????? DISABLENETWORKPROTOCOLS = 0.

????? ??? ??????? ?????? ???????? ????????? ?????????? ????? ????? ????? ????? ??? "?" ????? ???????. ???? ?????? ????????? ?????? ?????? ??????? ??? ??????? DATADIR ? ? TARGETDIR. ????? ?? ????????? ??? ?????? ??????? ???? ????? ??????? ?? ????? ???? "????? ??? ?????? ???? Setup.exe" ?? SQL Server 2000 ???????? (Updated ? SP3). ????? ?? ????????? ??? ????? SQL Server 2000 ???????? (Updated - SP3) ???? ?????? 1-6 "????? ??????? Online ????? ?? ????????".

?????? ???? ???? ?? Desktop Engine
  1. ??? ???? ???? ???????.
  2. ?? ???? ???????? ?????? ????? cd ???????? ??? ?????? ???? ????? ??? ?????? ???????? ?????? MSDE 2000 SP3a:

    ????? ??????? c:\MSDESP3aFolder\MSDE
  3. ??? ???? c:\MSDESP3aFolder ??? ?????? ??? ?????? ???? ??? ???????? ??????? MSDE 2000 SP3a ?? SP3a Desktop Engine ?????? ??? ????? ??????? SP3a 2000 ???? SQL.
  4. ????? ??? ??????? ???????: ?????
    To install a default instance configured to use Windows Authentication Mode, execute: 
    setup SAPWD="AStrongSAPwd"
    Where AStrongSAPwd is a strong password to be assigned to the sa login.
    
    To install a named instance configured to use Windows Authentication Mode, execute: 
    setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
    Where AStrongSAPwd is a strong password to be assigned to the sa login and InstanceName is the name to be assigned to the instance.
    
    To install a default instance configured to use Mixed Mode, execute: 
    setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL
    Where AStrongSAPwd is a strong password to be assigned to the sa login.
    
    To install a named instance configured to use Mixed Mode, execute: 
    setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
    Where AStrongSAPwd is a strong password to be assigned to the sa login and InstanceName is the name to be assigned to the instance.
    
    
??? ??? ??? ?????? ??? .ini ????? ??????? ? ???? ????? ?????? ???????? ?? ????? & .ini &.

??? ????? ???? ???? ????? ?????? ?????? sa ????? ??? ??? ?????? ?????? ???????? ??? ?????? Windows.
3.7.6 ??????? MSDE 1.0 ??? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

??? ??????? ?? ??? ?????? ??????? ????? ????? ?? MSDE 1.0 ??? MSDE 2000 SP3a ??? ????? ?????? ????? ?????? ?? ??????. ??? ??? ??? ?? ?????? ????? ????????? ?? ????????? ???? ???? ??? ????? ????????? ??????, ?? ???? ??????? DISABLENETWORKPROTOCOLS.

MSDE 1.0 ???? ?????? ??? ????? ??????? ?? MSDE 2000 ?? ??? ????? ????? ??? ???? ??????? MSDE 2000.

????? ?? ??????? Desktop Engine 1.0
  1. ??? ???? ???? ???????.
  2. ?? ???? ???????? ?????? ????? cd ???????? ??? ?????? ???? ????? ??? ?????? ???????? ?????? MSDE 2000 SP3a:
    ????? ??????? c:\MSDESP3aFolder\MSDE
  3. ??? ???? c:\MSDESP3aFolder ??? ?????? ??? ?????? ???? ??? ???????? ??????? MSDE 2000 SP3a ?? SP3a Desktop Engine ?????? ??? ????? ??????? SP3a 2000 ???? SQL.

    ????? ??? ??????? ???????:
    • ??? ??????? ??? ?????? Windows ? ?????:

      ????? ??????? = DISABLENETWORKPROTOCOLS 1 = 1
    • ??? ??????? "??? ??????" (??? ???? AnAdminLogin ??? ??? ????? ?????? ?????? ?????) ? ?????:

      ????? ??????? = SECURITYMODE 1 = UPGRADEUSER SQL = UPGRADEPWD AnAdminLogin = DISABLENETWORKPROTOCOLS AdminPassword = 1
?????? ??? ??? ?????? BLANKSAPWD = 1 ? ??? ?????? ?????? SECURITYMODE = SQL ?? UPGRADEUSERUPGRADEPWD.

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

??? ??? ??? ?????? ??? .ini ????? ??????? ???? ????? ?????? ???????? ?? ????? & .ini &.
3.7.7 ?????? ????? MSDE 2000 SP3a
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

????? SP3a ???? ??? ?????? ??? ???? ??????? ???????? ????? ????? MSDE 2000 ?? ??????? ???????? ?? ???? ??????? ???? ????? ?????? MSDE 2000. ????? ????? SP3a ???? Desktop ??????? ??? ?? ?????? ?? SQL Server 2000 ???????? (??????? SP3) ? ?? ????????? ?????? SP3a ???? ??? ???????:
  • 3.7.2 ???????? ?????? MSDE 2000 SP3a
  • 3.7.3 MSDE 2000 ????? ??????
????? ?? ????????? ??? ????? SQL Server 2000 ???????? (Updated - SP3) ???? ?????? 1-6 "????? ??????? Online ????? ?? ????????".

????? ??????? SP3a ???? ??? ??????

??? ??? ????? ?????? ?????? ????? ??????? ??? Windows Installer ? ???? ???? ????? ???? MSDE 2000 ???? ?????? ??????? ??????? ??? 2000 MSDE. ???? SP3a ???? (MSDE 2000) ??? ?????? ??????? ??????? ??? ???? ????????? ???????? ???? ?????? ??????? ??????? ?????. ??? ?? ??? ????? ??????? ???????? ????? ??????? ????? ??????? ?????? ???????? ????? MSDE 2000 ????? ?? ??????? ??????? ??????? ??? MSDE 2000 ??????.

??? ????? ????? ???????? ????? ?????? ????? ?????? MSDE 2000 ???????? ??????? ??????? ??? MSDE 2000 ????? ????????? MSDE 2000 ??????? ??? ???????. ??? ??? ????? ?????? MSDE 2000 ??????? ???????? ??????? ??????? ??? ??? ???? GUID ????? ???????? ?????? Windows Installer. ???? ????? ????? ??????? ???? ????? ????? ??? ??? ?????? ??????? GUID ??? ?????? MSDE 2000. ????? ??????? ??? ??? ?? ??????? ?? ??? ???? ??????? ????? ??? ???? ?????? ????????. ?? ???? ????? ??? ?????? Desktop Engine (MSDE 2000) ???? ?? ?????? ?? ??? Microsoft ??? ?????? ???. ??? ?? ????? ??????? ????? ????? ??????? ???????? ????? Desktop Engine SP3a ?????? ??? ??????? ??????? ??? ?? ?? ??????? MSDE ????? ??????? ??? ????????? ?? SP3a.

?????? ??? ???? ?? ????????? ??? ????? ??? ????? ???? ??????? ????????? ?? Windows Installer ??????? ????? ?????? (SDK) ? ???? ????? ??????? ?? the Microsoft Platform SDK Web site.

?? ???? ????? ???? ????? ?????? ????? ???? MSDE 2000 ?? ???? ??????? ?????? ???????? ?????? MSDE 2000 ? ???? MSDE 2000 ????? ??? ??? ?????? MSDE 2000 GUID. ???? ????? ??????? ??? ??????? ???????? ????? ???? ??????? Microsoft MSDE 2000 ????????. ???? ?????? ????? ??????? ??? ??????? ??????? ?????? MSDE 2000 SP3a:
  • ????? ??????? ?????? Desktop Engine SP3a ?? ???? ??????? SQL Server 2000 SP3a ?? ??? ????? SP3a SQL Server 2000.
  • ????? ??? ??????? SQL2KDeskSP3.exe ?????? ???? ??? ??????? ?? ??????? ??? ????? ????? ???? ???????.
  • ??????? ??????? Desktop Engine SP3a ????? ???? ?????? ????? ???? ???? ??? ????? SP3a ??? ?????? MSDE 2000 ??????? ?? ??? ???????.
??? ?? ????? ??????? ???????? ????? ?? ?????? ??????? ?????? SP3a ?????? ??? ?????? ?? ????????? ??????? ??? ???????? ???????.

????? ??? ????? MSDE 2000 ????? ?????? ??????? ???? ?????? ????? ????? Microsoft ? ???? ??? Microsoft MSDE Applications Web page.
3.7.8 ????? SP3a MSDE 2000
????? ????????? ??????? ??? ??? Desktop Engine (MSDE 2000).

???? ????? ??????? Desktop Engine SP3a ????????? ???????? ?? ?????? \MSDE:
  • ??? ??? ????? SP3a SQL Server 2000
  • ?? ?????? ???? ????? ??? ????? ???? ??????? ????????? ?? SQL2KDeskSP3.exe \MSDE ???? ????? ??? SP3readme.htm ??? readme.txt ????? license.txt ???????? ??????? ??????? ?????? ??????? ?????? ????????. ????? ????? ???????? ??????? ???????:
  • \Msi: ????? ??? ??????? ??????? ??????? ???????? ?????? Windows Installer ?? ????? Windows Installer ??? ???? ?? 2.0.2600.0.
  • \MSM: ????? ??? ??????? ??????? ??? ???????? ?????? ?????? ????? ???.
  • \Setup: ????? ??? ????? ???? ??????? .msi ???????? ?? ??? ?????? ??????? MSDE 2000 ?????? ???? ???? ?? MSDE 2000 SP3a ?? ????? ???? ??????? msp ?????? ???????? ???????? MSDE 2000 ??? SP3a ??? ??????? sqlrun.cab ????? ??? ??????? ??????? ?? ??? ?????? ???????.
?????? ??? ??? ?? ??????? ??????? ??????? ??? Desktop Engine ???? ??????? ????? "??????? SQL Server Desktop Engine ??? ?????" ?? "??? SQL Server ???????".

??? ?????? ????? ??????? ????? MSDE 2000 ? ????? ???? ?? ??? ???? ? ??????? ?? ??????? (??? ???? MSDEInstallFolder ???? ??? ???? ??? ???? ????):

MSDEInstallFolder

??? ?? ??? ??????? ?? ?????? \MSDE Desktop Engine SP3a: Setup.exe ? Setup.ini Setup.rll ? sqlresld.dll.

MSDEInstallFolder\Msi

??? ???? ??????? ?? ?????? \MSDE\Msi SP3a ???? ??? ??????.

MSDEInstallFolder\Setup

??? ???? ??????? ?? ?????? \MSDE\Setup SP3a ???? ??? ??????.

?? ????? ????? Setup.exe ????? ?? ????? ?????? MSDE 2000 SP3a.

??? ?? ??? ????? ??? ???? ????????? ???? Windows ?? ?? ????? ???? ?? ??????? ?????? ?? ????? SP3a 2000 MSDE ? ????? ??????? ??????? ??????? ?? ?????? MSDEInstallFolder\Msi ?????? Windows Installer.

3.8 ????? ?????

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

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

??? prudent ?????? ??? ??????? ????? ????? ????? ???????? ???????? ???? msdb ?? ??? ?????.

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

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

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

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

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

?????? ???? ?????? ??? ???? ?????? ????? ?????
  1. ??? ??? ????? ??? ????? ???????? ?????? ?? ????? SQL Server ? ??? ???????? ??? ??? ???? ??????? ?? ???????? ??? ????? ??? ????? SP3a.
  2. ????? ???? ??????? ?? ?????? ???? ???? ?????? ????? ??? ?????? ??????? ???? ???? ???????. ?? ???? ??? ?????? ??? ?? ???? ????? SP3a ??? ??????? ??????? ??? ????? over.This ????? ???? ??????? ??? ???? ????? ?? ???? ?????? ????? ?????.
  3. ?? ???? ?????? ????? ? ???? ??? ?????? ??????? ???? ??? ???? ????????.
  4. ???????? ???? ??? ???? ???????? ??? ?????? ????? ???????. ??? ???? ?? ??????? ??? ??????? ??? ?? ???? ?? ??????.
  5. ?? ???? ????? ?????? ?? ?????? ?????? ??????? ??? ????? ?? ?????? 1 ?????? ????? ???????? ?? ????? ??????? ????? ?????.
?????? ?? ????? ?????? ??????? ????? ??????? ?? ??? ???? ???????? ????? ?????. ?????? ??? ??????? ???? ???? ??? ????????? ????? ??????? ?? ??????? ???? ?? ???????.

??? ??? ???? ???????? ??? ??????? (??? - ??????) ???? SQL Server ??? ???? ????? ????? ??? ????? ?????? (??? - ??????) ?????????? ??? ???? ????? ?? ?? ?????? SP3a.For ?? ????????? ??? ????? ? ???? "????? ????? ?? ???? ??????? ??? ??????? ?????? ???????? ???? SQL Server 2000 (???????)" ?? "??? SQL Server ???????".

?????? ??? ??????? ?????? ??? ????? SP3a ??? ???? ?????? ????? ??? ???? ????? ????? ??????? ??? 811168.

??? ??? ????? ??? ????? ????? ???? ?? ?????? ????? ????? ?????? ??????? ???????
  1. ????? ????? ?????? ?? ???? ????? ?????. ????? ?? ????????? ??? ????? ????? ???? ???? "????? ??????? ?? ??? ???? ?????? ????? ????? ?? ????????? 1" ?? "??? SQL Server ???????".
  2. ?? ?????? ?????? ????? SQL Server 2000 ??????? ????? ?????? ????? ??? ???? ?????? ????? ?????.
  3. ?? ?????? ?????? ??????? SP3a ??? ???? ??? ??????? ??????. ??? ??? ????? SP3a ???????? ??? ??? ???? ?????.
?????? ??? ??? ?????? ?????? ??????? ?? ?????? ??? ??? ????? ?????? ??????? ? ??? ????? ????? SP3a ??? ???? ?????. ??? ????? ????? ????? ??????? ?????? ????? ????? ????????.

??? ????? SP3a ????? ??????? ??? ???? ? ??? ????? ?? ???? ???? ?????.

?????? SP3a ??? ???? "????? ?????"
  1. ????? SP3a ??? ???? ????? ???.
  2. ????? ????? ??? ???? ?????? ??????.
  3. ??? ??????? 1 ?2 ??? ??? ????? ???? ???????? ?? ??????.

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

????? ????????? ??????? ??? ??? SQL Server 2000 ???????? ???? ????? ????? ?? ???????? ????? ????????:
  • ??? ????? ?? ???? ??? ????? ??????.
  • ?????? ??? ???????? ????? ???????? ????? ??? ????????? ????? ???????? ?? ????????? ??????? ???, ????? ????? ??????? ??? ?? ??? Publisher ?? ????.
  • ?????? ??? ???????? ????? ???????? ???????? ??? ??? ????? ???????? ?? ????????? ????? ???????? ?? ????? ????????? ? ?????? ???? ????? ??????? ??? Publisher ?? ????.
?????? ?? ???? ?? ???????? ???? ?? ????? ???????? "??? ???? ? Publisher ??? ??? ?????? ?? ??? ????? ?? ??? ?????.

????? SP3a ??? ???? ???? ???? ??? Publisher "?" ???????

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

???? 1: ?????????? ???? ????? ????????? ??????

????? ?????? ?????? ???????? ???? ??? ? ???????? ?? ????????? ???? ???? ????????? ??? ???????. ??? ?? ???? ?????? ? ??? ?? ???? ??????? ??????? ???? ? Publisher ? ??????? ?????? ??? ???????? ?????? ????????? ?? ????? Subscriber.This ????? ??? ????? ???? A ????? ?????? ??? ????? ??? ?B Server ????? ????? ????????? ?? ????? ?????????. ?? ??? ?????? ???? ??? ????? ????? ?????? ?????? ???????? ?? ??? ?????.
?? ??? ??????????? ??? ??????
???? A???? B
Publisher/???? ????? ???????? ?????????? ????? ???????? ???
??????? ????? ???????? ????????? ?? ?????Publisher/???? ??????? ????? ???????? ?? ?????
???? 2: ?????? ?????????? ???? ???? ??????.

?? ??? ??????? ????? ????? ???? A ????? ??? ????? ??????? ?? ??? Publisher/???? ???? ??????? ????????? ??????? ???.
?? ??? ??????????? ??? ??????
???? A???? B
Publisher/???? ????? ???????? ?????????? ????? ???????? ???
??????? ????? ???????? ????????? ??????? ???Publisher/???? ????? ???????? ????????? ??????? ???
?????? ????? ????? ???????? ??????

??? ??? ??????? ??? SP3a ???? ???? Windows ???? ??? ????? ???? SQL Server ????? ??? ????? ?????? ?????? ?????. ??? ?????? ???? ???? ??? ????? ????? ???????? ??????? ????? ???????? ??? ???? ???? ???? SQL Server. ??? ??????? ??? SP3a ? ??? ????? ???? Windows ?? ??? ????? ??????.

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

???? SP3a ????? ?? ??????? ????? ?? ??????? ????? ?????? ????? ????????. ????? ?? ?????????? ???? ????? ???? 5.3.17 ??? ??????? ????? ?? ??????? "????? ???????? ????? ????????".

????? SP3a ?????? ????? ?????? ???????? ???? ????? ?? ???????? ????? ????????. ??? ???? ?? ?? ????? ???????? ???? ????? ?? ???????? ????? ???????? ??? ???? ??????? ?????? SP3a ??? ????? ???????? ??? ??? ????? ??? ???? ??????? ?? ????? reapplySP3a. ?????? ??? ???? ?? ????????? ??? ??? ????? ?????? ???? ??????? ???? ?????? SP3a ????? 3.12 ??? ????? ?????? Read-Only ?? Filegroups. ?????? ??? ??????? ??? ????? ????? ??? ?????? ??????? ?? ??? SP3a ???? SP3a ????? ????? ??? ?????? ??????? ?? ??? 3.14 ????.

???? ????? ??????? ?????? ?? ????? ???????? "??????? ??????? ????? ?????? ??? ???? ?????? ??? ??????? SP3a ?? ???? ?? ???. ??? ????? SP3a ?? ??? ?? ????? ?????? ????? ???????? ????? ????????? ?????? ?????? ???????? ??? ??????? ?? ???????? ????? ??????. ???? ???????? ??? ??? ????? ?????? ????? ?????? ?? ??? ???? ??? ????? ????? SP3a ??? ??????? ????? ????????.

3.12 ????? SP3a ????? ?????? ??????? ??? ?? Filegroups

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

??? ???? ????? ???????? ??? ???? ??????? ?? filegroups ????? ???? ??????? ???????:

??? ??????? ?? ???? ?? ???? ?? ????? ???????? ? filegroups ????? ??? ???? ???????.

???? ???? ????? ????? ??? ??????? ??????? ???????. ??? ???? ??? ??? ?? ?? ????? ???????? ??? ???? ??????? ?? ??? ??????? ????? ???????? ????? ???????? ???? ??? ?? ?????? ????? ???????? ??? ???? ??????? ?? ????? ????? ????? SP3a ???? ?????? ?? SQL Server 2000.

???????? ???? ??? ??????? ??? ?????? ??????? ??? ???????. ????? ?? ????????? ??? ?????? ??????? ??? ??????? ???? "?????? ??????? ??? ??????? 4.1 ????".

??????????? ???????? ???? ????? ?? ???? ??? ??? ????? ???????? ??? ???? ??????? ?????? ???????? ???? ??? ???? ?? ?? ???? ????? ???. ??? ???? ????? ???????? ?? filegroup "?? ?? ?? ??? ?????? ????? ???????" ? ??? ????? ????? ???? ???????. ?????? ??? ???? ?? ????????? ??? ????? ????? ?????? ??? ????????? ???? ??????? "????? ? ??? ????? ??? ??????" ?? "??? SQL Server ???????". ????? ?? ????????? ??? ????? ????? ?????? ????? ??? ???? ??????? ??????? "Server ? ????? ?????? ????????" ?? "??? SQL Server ???????".

?????? SP3a ??? ????? ?????? ??????? ???
  1. ??? ????? ???????? ??????? ??? ????? ??????? ????? ???????? ????? ALTER ????? ?????? ?????? ?????? ????? ?????? ???: ALTER READ_WRITE SET.
  2. ??? ?????? 1 ?? ??? ???? ????? ???????? ??????? ???.
  3. ????? (?? ????? ?????) ???? ??????.
  4. ??? ??? ?????? ??? ????? ???????? ??????? ??? ??? ???? ???????? ALTER ????? ???????? ? ??? ???:

    ????? ?????? ????? ?????? ALTER SET READ_ONLY
?????? SP3a filegroup ??????? ???
  1. ??? filegroup ??????? ??? ????? ??????? ????? ???????? ALTER DATABAS E, ??? ???: ALTER ????? ?????? ????? ???????? ????? FILEGROUP filegroup_name READWRITE
  2. ??? ?????? 1 ?? ??? ???? filegroups ??????? ???.
  3. ????? (?? ????? ?????) ???? ??????.
  4. ???? ?? filegroup ??????? ??? ??? ???? ???????? ALTER ????? ?????? ? ??? ???:

    ALTER ????? ????? ?????? MODIFY FILEGROUP
    filegroup_name ??????? ???
????? ?? ????????? ??? ????? ?????? ALTER ???? ??????? ???? "ALTER ????? ??????" ?? SQL Server ????? Online.For ???? ?? ????????? ??? ????? ????? ??? ?????? ??????? ?? ??? SP3a ? ???? ???? 3.14 SP3a ????? ????? ??? ?????? ??????? ?? ???.

3.13 SP3a ????? ????? ?????

????? ????? ????? SQL Server SP3a ??? ?????? SQL Server 2000 SP3 ???? ???? ????????.

?????? ?? ??? ????? ????? ??????? MDAC. ????? ?? ?????????? ???? ?????? 5.5.1 ????????? ??? Microsoft Data Access Components.

????? ????? SQL Server 2000 ????? ?????? ? SP3a ???? ??? ??????

?????? ??? SP3a ??? ????? ??????? SQL Server 2000 ?????? ??? ?? ???? ???? ???? ?????? ????? ???????? ???????? ? msdb ??????? ???? ???????? ????? SP3a. ????? ?? ?????????? ???? "????? ???? 3.1 ?????? ????? Your SQL Server ??????".

?????? ??? ??? ??? ????? ?? ?? ????? ???????? ?? ????? ????????, ??? ???? ????? ?????. ?????? ?????:
  1. ?? "????? ??????? ???? SQL" ? ?? ?????? ???? SQL ???????? ? ?? ?????? ???? ???? ??? ?????? ?????? ??? ???? ????? ???????? ?? ???? ??? ????? ????? ????????? ? ???????.
  2. ???? ??? ????? ??????? ????? ?????? ?????.
  3. ?? ?????? ????? ???? ???????? ??? ????? ?????? ??????? ?? ????? ????????. ???? ??? ????? ???????? ???? ??? ?????.
?????? ??? SP3a ??? ????? ????? SQL Server
  1. ??? ???? ????? ???????? ????????. ????? ?? ?????????? ???? "????? ????? ? ??? ????? ?????? (????? ???????)" ?? "??? SQL Server ???????".
  2. ????? ????? SQL Server. ?? ???? ?????? ? ?? ???? ????? ??????? ??? ?????/????? ??????? "? ?? ??? ???? SQL Server ???? ???? ?????.
  3. ????? SQL Server 2000 ?? ????? ??????? ?? ???? ??? ????? ????? SQL Server.
  4. ??? ????? ?? ??? ?????? ?????????? QFE ???? ?? ??????? ??? SP3a.
  5. ??????? ????? ???????? ???????? ? msdb ??????? ?? ????? ????????? ??????? ???? ?? ??????? ??? ????? SP3a.This ???????? ????? ?? ????? ?????? ???????? ????? ?? ????? ???? ?? ????? ????? ????????? ?? ?????? ??? ?? ??? ????? ???? ????? ????????.
  6. ????? ?? ????? ?????? ???????? ???? ?? ??????? ??? ??? ??? ??????? ?? ????? ???????? ????????.
  7. ????? ????? ???????? ??? ??? ?????.
????? ??? ?????? ??? ????? SQL Server ??? ????? ???? SP3a ??? ????? ???? ????????? ???? ????? ??? ????? ???????? ???????? msdb ??????? ??? ????? SP3a

uninstalling SQL Server 2000 Analysis Services SP3a

????? ?????? ??? ????? Analysis Services ??? ????? ??? ????? ???? SP3a ??? ??? ???? ???????? ????? ??????? Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP ??? ??? ????? SP3a. ????? ?? ?????????? ???? ????? ???? 3.2 ?????? ????? Your Analysis Services ?????? ? ??????.

????????? ?? ??? ????? ??????? ???, ??? ????? ????? ????? ?? ????? "????? ??????? ?? Microsoft" 330244.

?????? ??? SP3a ??? ????? ????? SQL Server
  1. ????? ????? SQL Server 2000 Analysis Services. ?? ???? ?????? ? ???? ????? ??????? ??? ?????/????? ???????, ???? ??? ????? ????? SQL Server 2000 ?? ???? ??? ?????.
  2. ????? ????? SQL Server 2000 Analysis Services ?? ????? ??????? ?? ???? ???? ??? ????? ?????? "????? ?????".
  3. ??? ????? ?? ??? ?????? ?????????? QFE ???? ?? ??????? ??? ????? SP3a.
  4. ????? ????? ??????? Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP.
  5. ????? ????? ????? ??????? Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP ?? ?????? ?????????? SP3a ??? ????? ????.

3.14 ????? ????? ??? ?????? ??????? ?? ??? SP3a

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

?? ??????? ??????? ??? ????? ????? SP3a:
  • ??? ?? ????? ?????? ????? SQL Server 2000 ??? ????? SP3a.
  • ??? ?? ????? ????? ???????? ?? filegroups ???? ??? ????? ?? ???????? ????? ???????? ?? ??????? ??? ????? ????? ?????? SP3a ???? ???????
?????? ????? SP3a ? ???? ??????? ???????? ?? "???? ?????? 3.0 ????" ???????.

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

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

4.1 ?????? ??????? ??? ???????

???? ????? SP3a ?????? ????? ???????? ?? ??? ??? ??????? ??? ???? SQL Server. ????? "????? ??????? SP3a ?????? ????? ????????" ??? ????? .iss ???? ???? ????????? ?????? setups SP3a ??? ??????? ???????? ?????? ?? ?????? ???????. ??????? ??????? ???????? ?? ?????? ????? ??? ????? ???????:
  • Sql2kdef.iss ?? ??? ??????? ??? ??????? ???????? ?????? SP3a ?????? ????? ???????? ??????? ???? ?? SQL Server 2000 ???? ??? Windows 2000 ?? Windows NT 4.0. ?? ??? ???? ??????? ???????? Sql2kdef.bat.
  • Sql2knm.iss ?? ??? ??????? ???????? ?????? SP3a ?????? ????? ???????? ??? ????? ???? SQL Server 2000 ???? ??? Windows 2000 ?? Windows NT 4.0. ??? ????? ??? ?????? ?? ??? ????? .iss ?????? ?????? ???? ?? ??????.
  • Sql2ktls.iss ?? ??? ??????? ???????? ?????? ????? SP3a ???????? ??? ????? ????? ???. ???? ??????? ??? ????? ??????? ???? ??? ???????.
  • Sql2k9x.iss ?? ??? ??????? ???????? ?????? ????? SP3a ???????? ??? ??????? ???? ????? ??????? Windows Millennium Edition ?? Windows 98. ??? ????? ??? ?????? ?? ??? ????? .iss ?????? ???? ??????.
  • Sql2kcli.iss ?? ??? ??????? ???????? ?????? SP3a ?????? ????? ???????? ??? ????? ?????? ???? ??? ??????? ???? ????? ??????? Windows 95.
  • Msolap.iss ?? ??? ??????? ???? ???? ?????? ????? ?????? ????? ????? ??? ????? ?? SP3a ????? ???????.
?????? ??? ???? ?? ????????? ??? ????? ????? ????? ??? ????? ?? SQL Server 2000 ???? ??????? "????? ????? ????? ?????" ?? "??? SQL Server ???????".

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

????????? ?????????? ??????? ??? ????? ??? ?????:
  • ????? ????? ??? ????? ???????? ?????? Windows ???? ???? ???.
  • ??? ??? ??? ????? ?????? ????? ??? ????? ???????? ?????? ???? SQL; ??? ???? ?????? ??? ??? ???? ?????? ????? ??? ????? ?? SP3a ??? ???? ??????? ???? ????? ??????? Windows 98 ?? Windows Millennium Edition ???? ??? ????? ???? ???? ????? ?????? sa ?? ??? .iss ?? ??? ???? ??? ??? ??????? ??? ?????. ????? ?? ???? ??? ????? ???? ???? ????? ?????? ' sa ' ?? ??? ??????? ???????? ??????? sapwd ??? ???:

    ??? ????? setupsql.exe/wait -s - ???? ?????? sapwd sms - C:\sql2knm.iss f1-
  • ??? ??? ???? SQL Server ?????? ??? SP3a ???? ???? ????? ????? ????? ?????? sa ? ??? ????? ???? ???? ??? ?????? ????? ??? ?????. ??? ???? ????? ???? ?????? ??? ?? ???? ????? sp_password.
  • ??? ????? ????? ??? ????? SP3a, ??? ????? ???? ????? ??????? ??????? ???? ?????? ?? ?????? ??? ???? ?????? ????? ?????? ??????? ????? ?? ??? ???? ????? ??????? ??? ?????.
?? ??? ??????????? ??? ??????
????? ??????? ??? ??????????
UpgradeMSSearch??? ??????? ??? ????? ??????? ??????? ????? ????? ??????? ??????? ???? ??????. ??? ?? ????? "??? ???? ??????" ??? ???? ????? ??? ??????? ??? 1. ?????? ??? ???? ?? ?????????? ???? ?????? 5.1.5 ???? ?? ???????? ??? "????? ??????? ??? ????? ??????".
MSXTSXUpgraded??? ??????? ??? ????? ??????? ??????? ???? ????? ??????? ???? ?????/??? ?????. ??? ??? ???? ?????? SP3a ??? ???? ??????? ?? ????? ??? ???? ????? ??? ??????? ??? 1. ????? ?? ?????????? ???? ?????? 5.4.2 ????????? ??? "??????? ????" ?????/?????.
EnableCrossDBChaining(???????) ??? ??????? ??? ??????? ??? ?????? ????? ????? ????? ???????? ????????. ?????? ????? ????? ???????? ??? ????? ????? ??? ??????? ??? ??? 1. ????? ?? ?????????? ???? ??? 5.1.11 "????? ???????" ????? ???????? ????????.
  • ????? ????? ??? ?????? ??? ??? ??????? ?? ?? ????? ?????? ??? ???? ??????? ?? ????? filegroups ????? ????????? ??? ??????? ????? ????? ??????? ??? ???????. ??? ??? ?? ?? ????? ???????? ??? ???? ??????? ?? ??? ??????? ????? ???????? ????? ???????? ??? ?? ?????? ????? ???????? ??? ???? ??????? ?? ????? ????? ????? SP3a ???? ?????? ?? SQL Server 2000. ?????? ??? ???? ?? ????????? ??? ??? ????? ?????? ???? ??????? ???? ?????? SP3a ????? 3.12 ??? ????? ?????? Read-Only ?? Filegroups. ????? ?? ????????? ??? ????? ????? ??? ?????? ??????? ?? ??? SP3a ???? SP3a ????? ????? ??? ?????? ??????? ?? ??? 3.14 ????.

4.2 SP3a ?????? Access Components ?????? ?????

????? SP3a ?????? ????? ???????? ?? ??????? ???? ????? Sqlredis.exe. ??? ????? Sqlredis.exe ????:
  • ????? ??? Mdac_typ.exe ?? Microsoft Data Access Components (MDAC) 2.7 Service Pack 1a. ??? ?????? ?????? MDAC 2.7 SP1a ???????? (??? ?? ??? ????? ?? ????? ??? ?? ????) ????? ??????? ???????? ????? ???? SQL Server ? Desktop Engine ??????? SP3a. ????? ?? ?????????? ???? 5.5.1 ????????? ??? Microsoft Data Access Components.
  • ????? ????? ????? ODBC Jet Microsoft ??????? ???????.
???? ????? ????? ????? Sqlredis.exe ??? ?????? ???????? ?? ??? Redist.txt ???????? SP3a.

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

???? ??? ?????? ???????? ???? ?? ???? ???????? ??? ??????? ??????? ???????? ??? ????? SP3a. ????? ??? ???????? ??? ????? ???? ?????? ????? ?? SQL Server 2000 ?? SQL Server 2000 ?????? ????? ?????? SP1 ?? SQL Server 2000 ?????? ????? ?????? SP2. ??? ?????? ?? ???? ???? ??? ???? ????????? ???????? ?? SP3a. ?????? ??? ????? ????? ??? ????????? ???? ????? "????? ??????? ?? Microsoft" 306908.

?? ??? ?????? ??? ?????? ??????? ?????? ?????? ??????? ?? ??? ????? ??? ?????? ??????? Desktop Engine-???.
???? ??? ??? ??????? ????? a? ???? ???? ?? SQL Server 2000 ??? ?????? ?? ????? ??? ??? ??????? ?? ??? ????? ???????? ?? ????? "????? ??????? ?? Microsoft" 816502.

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

5.1 ????? ???????? ? ??????? ???? ??? ??????

??????? ??????? ????? ??? ?????? SQL Server 2000 ?????? ???? SP3a ?????? ????? ????????. ??? ????? MSDE 2000 ???????? ??? ?? ????? SP3a ???? ??? ??????.
5.1.1 ??????? ??????? ?? ????????? ?? ??????? ?????? ?? SP3a ?????? ????? ????????
??????? ?? SP1

??? ??? ?????? SP3a ?????? ????? ???????? ??? ???? ???? ?????? Windows NT 4.0 ?? Windows 98 ? ???? ??? ??????? ??? Windows 2000 ????? ???? ??????? Windows 2000 ???????? ????? ???? ?????. ????? ?????? ??? ????? ?????? ???? ?????? ??????? ?? ????????? ?? ???????. ??? ??????? ?????? ??????? ?? ????????? ?? ??????? ?? ????? ?????? SQL Server ????? ?? ????? ????? ????? Sqlredis.exe ??????? ?? SP3a ??? ??????? ??? Windows 2000. ????? ?? ????????? ??? ????? Sqlredis.exe ???? ?????? ?????? ????? 4.2 SP3a ?????? Access Components.

?????? ?? ???? ????? ????? ????? Sqlredis.exe ??? ????? ????????? ??????? ?? ??? ???????? ???? ?? ????? ??? ????? ???????? ???? ????? ??? ?????? ??????? ?? ????????? ?? ???????.
5.1.2 ????? ????? ???????
??????? ?? SP1

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

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

?? ??? ??????? ???????? ???? ?? ???? ????? ????? ??????? ??????? ???????? ????. ????? ??? ??? ??????????? ?????? ?? ??? ??? ????? ????? ?????? ???? ????? ???? ????????? ??? ????? ?????? ????? ??.
5.1.3 ????? ???? ??????? ????
??????? ?? SP1

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

????? I/O ???? ???????

????? ????? ????? ????? ???????? ???????? (CPUs) ???? ??? ????????? ?????? ?????? ??????? ?????? ?????/????? ????? ?? ???? ?????? ???. ??? ??????? ??? ??????? ??? ????????? ?? ?????? ???? ???????. ????? ?? ?????????? ???? ??????? 298402 ?? ?????? ?????? ????? ????? ??????? ?? Microsoft. ?????? ??? ??????? ??? ????? ?? ????? ????? ???? ?????? 1.5 ?????? ??????? ??? SP3a.

????? ????? ???? ???????
????? ???????? ???? ?????? ??? ????? ??????? ???? ??? ??????? ??????? ??????? ????? ????? (VIA) ???? SQL Server ??????? ?? ?????? ?????? ????? ??? ????? ?? ?????? ?? ?????????. ??? ??????? ??? ??????? ??? ????????? ?? ?????? ???? ???????. ????? ?? ?????????? ???? ??????? 299641 ?? ?????? ?????? ????? ????? ??????? ?? Microsoft.
5.1.4 ????? ??? ??????
??????? ?? SP2

??? ???? "??? SQL Server 2000 355069 ??? ????? ?? 306467 ????? ????? ????? Microsoft" ? ??? ??? ???? ?????? ??? ??? ????????? ?????????? ????? ??? ?????? ????? ??????? ????????. ???????? ??? ????? ????? ???, ??? ????? ????? ???? ??????? ???? ????? ??? ??? ????? ?? ???? ???????. ????? ?? ?????????? ???? ?????? ?????? ????? ????? ??????? ?? Microsoft.
5.1.5 ????? ????? ???????? ?? ???? ??? ?????? ???????
??????? ?? SP3

??? ????? ????? ???? ??????? ??????? ???? ?????? ???? ?? ??????? SP3a ? ???? ??? ??? ??????? ?? SP3. ????? ????? ???????? ??????? ???? ????. ?? ???? ??????????? ?????????? ???? ?????? ????? ????? ?? ??? ????? ??? ?????? ????? ????? ?????. ??? ????? SP3a ????? ????? ?????? ????? ??? ??????? ?????? ??? ?? ??????? ??????? ???????? ???? ?????? ?? ????? ???? ??? ??? ???? ????? ???????.

?????? ??? ?????????? ???? ????? ????? ??????? 327217 ? ???? ?????? ???? ?????? ???????? ?????? ????? ????? ????? ????? ????? ????? ????? ??????? ??? ????? ?? ?? ???? ?????.
5.1.6 ???? ???? ????????? ?? sp_change_users_login
??????? ?? SP3

??? ????? sp_change_users_login ?? @ ??????? = Auto_Fix ??????? ???? ??? ????? ???? ????. ????? sp_change_users_login ???? ?????? ??? ?? ????? ???? ????? ????? ????????. ???? ?????? ?????? @ ???? ?????? ??????? ???????. sp_change_users_login
sp_change_users_login [ @Action = ] 'action' 
    [ , [ @UserNamePattern = ] 'user' ] 
    [ , [ @LoginName = ] 'login' ]
    [ , [ @Password = ] 'password' ]
Use the @Password argument only with @Action=Auto_Fix. The following example shows the new syntax for the sp_change_users_login command when using Auto_Fix. Other examples in SQL Server Books Online remain unchanged.

USE pubs
go
EXEC sp_change_users_login 'Auto_Fix', 'Mary', NULL, 'B3r12-36'
go
5.1.7 ????? Ad Hoc ?????? ??? ????? ????? ?????? OLE ???? ???????
??????? ?? SP3

???? ??????? DisallowAdhocAccess ?? ??? ????? ????? ? ?????????? ??? ????? ad hoc ?????? ??? ????? ????? ?????? OLE. ???? ???? ?? ???? ???? ????????? ad hoc ??? OPENDATASOURCE OPENROWSET ? ?? ???? ????????? ?? ???????? ???????. ?????? ??????? ???????, ??? ????? ?????? DisallowAdhocAccess ???? ???? ??? 0.
5.1.8 ???? ???? SqlServerLike ????
??????? ?? SP3

?????? ?????? ???? ?????? ?? ??????????? ???? ????? LIKE ??????? ??? ????? ?????? SqlServerLike ?? SP3. SQL Server 2000 SP3 ?? ???? ???? ?? ?????? ?????? LIKE ???????? ??? ?????? ????????. ??? ??? ????? ???? OLE DB ???? ????? ???? ???? SQL Server LIKE ???? ? ???? ????? ????? ????? ?????? SqlServerLIKE ???? SQL Server ????? LIKE ?????? ???????? ???? ???? SQL Server. ?? ???? ????? ???? OLE DB ???? ????? ??? ???? ???? ?????? ????? ????? ANSI/ISO SQL - 92 ?? ????? ????? SQLPROP_ANSILIKE ? ???? ???? SQL LIKE ?????? ??? ???? ????? ???????? ???? ???? SQL-92. ?????? ??? ???? ?? ????????? ??? SQLPROP_ANSILIKE ? ???? ??????? "??????? SQLPROPSET_OPTHINTS ?????? ?????" ?? SQL Server 2000 ????????.

??? ????? ???? ????? ????? ?????? ???? SqlServerLIKE OLE DB ??????.
???? ????? ????? ??????? ???? ??? ???? ??? ???? ?????? ????? ???? ????? ????? ???? ???????. ??? ???? Microsoft ?? ????? ?? ?? ??????? ??????? ?? ????? ??????? ???? ??? ????. ??? ????? ??????? ?? ????? ????? ????????? ???? ?????? ?????.
  1. ???? Regedit32.
  2. ??? ???? ????? ??????? ???????:
    • ??????? ???? ??? ???? ??? ???????:
      Server\ SQL HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft < ???? ??? > \Providers\ < ??? ?????? >
    • ??????? ????????? ??? ???? ??? ???????:
      HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Providers\ < ???? ??? >

  3. ?? ??????? < ??? ?????? > ????? ???? DWORD ???? SqlServerLIKE ?? ?? ?????? ?????? ?????? ?? ??? 1.
5.1.9 ????? ????? ?????? ?? ????????? ???????
??????? ?? SP3

?? ??? ????????? ??????? SQL Server ?????? ??? ???? ????????? ???????? ??? ??????? ????? ??????. ??? ????????? ??? ???????? ???????? ??????? ?? ??? SQL Server ??????? ??? ??? ??? ???? ?????? ????? OLE DB IErrorRecords. ??? ??? ?????? ??? ??????? ???????? ?????? GetErrorInfo ?????? ??? ??????? ?????? ??? ????? ?? ?????? ?? SQL Server ? ????? ??? ????????? ??? ???????? ???? ?? ????? ?????. ??? ??? IErrorRecords ??????? ??? ?????? ? ???? ?? ????? ?? ???? SQL Server: SQL Server ?????? ??? ???.
??? ???? ??????? ????? ????????? ?????? ????? ???? ?????? MSDASQL ?? ????? sql_variant:
SELECT * FROM remote2k.dqtable.dbo.sqlvariantnotnull 
--Remote2k is a loopback server.
Prior to SP3, SQL Server returned the following error message:

Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'msdasql' supplied inconsistent metadata for a column. 
Metadata information was changed at execution time.
After you apply SP3 or later, SQL Server returns the following error message:

Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'msdasql' supplied inconsistent metadata for a column. 
Metadata information was changed at execution time.
OLE DB error trace [Non-interface error:  Column 'sql_variant' (compile-time
ordinal 3) of object '"dqtable"."dbo"."sqlvariantnotnull"' was reported 
to have a DBCOLUMNFLAGS_ISFIXEDLENGTH of 16 at compile time and 0 at run time].
5.1.10 fn_get_sql ???? ???? ????? ???? SQL
??????? ?? SP3

SP3 ?????? ?????? ????? ?? ?????? fn_get_sql ???? ?????? ???? ????? SQL ?????? SQL ??????. ???????? ??? ???? ??????? ??? ?????? ????? ????? ????? ??? ??????? ??? ???? ?????? sysprocesses ?????? ?? ?????? ??????.
?? ??? ??????????? ??? ??????
??? ????????? ???????????
sql_handlebinary(20)???? ?????? ????? ???? ?? ????
stmt_start??? ????????? ????? SQL ??????? sql_handle ?????? ?????
stmt_end??? ????????? ???????? SQL ?????? ????? ?? sql_handle ??????. ???? ???? ?????- 1 ??? ????? ??????? ??????? ??? ????? ????? ?? ??????? ?????? ???? fn_get_sql sql_handle ??????.
Syntax
fn_get_sql ([ @SqlHandle = ] SqlHandle )

Arguments
[ @SqlHandle = ] SqlHandle

The handle value. SqlHandle is binary(20).

Tables Returned
?? ??? ??????????? ??? ??????
??? ????????? ???????????
dbid??? ???? ???????? ????? ????????. ??? ?????? ?? NULL ?? ?????? SQL ???????
objectidInt????? ???? ????? ????????. ??? ?????? ?? NULL ?? ?????? SQL ???????
?????? ???? ??????? ???????? ??? ???? ????? ?????????. ??? ?????? ?? 0 ????????? ??? ????????? ? NULL ?? ?????? SQL ???????.
?????????????? ??? ?? ??? ??? ?????? ?????. ?? ?????? 0 ??? ?? ??? ????? ?????? ? 1 ??? ?? ????? ??????.
?????????? ????? SQL. ??? ?????? ?? NULL ??????? ???????.
???????

???? ?????? ??? ???? SQL ???? ?? ???? sql_handle ???? ?????? sysprocesses.

??? ??? ?????? ???? ?? ??? ??????? ?? ????? ??????? ?????? fn_get_sql ????? ??????? ?????. ??? ??? ?????? ???? ??? ????? ?????? ?????? ??? ????? ????? ????? ???????:

????: ????? 569 16 ????? "?" 1 ???? ????? fn_get_sql ? ????? ?????? ??? fn_get_sql 12 ?? ??? ????.

?? ???? ????? SQL Server 2000 ??? Transact-SQL ?????? ??? ?????? ?????? ????? ????? ??????? ?? ????? ????? ???? ?? 8 ???? ????. ?? ???? ??????? ????? ??? ???????? ???????? ?????? fn_get_sql.
??? ????? ???? ?? ?????? ??????? ???? ???? ?? ????? ??? ????? ??????.

???? ????????? ???? ??? ??????? ?????? ?????? fn_get_sql ????? INPUTBUFFER DBCC. ?????? ?????? fn_get_sql ??? INPUTBUFFER DBCC ?? ???? ??????? ? ??? ???? ??????:
  • ????? ???? ??????? ???? ???? ?? 255 ?????. w
  • hen ???? ?????? ???? ????? ??????? ?????? ?? ????? ????. ??? ???? ??????? ???? ????? ????????? ??????? ????? sp_1 ?? sp_2. ?? ???? ??????? sp_1sp_2 ?????? ??? ?????? ?? ???? ?????? sysprocesses ????? ????? sp_2 ?????? fn_get_sql ?????? ??????? ??? sp_2.???????? ??? ???? ???? ?????? fn_get_sql ???? ?????? ??????? ?????? ?? ???? ????? ??????? ??????
??????

???? ??? ?????? ??? ???? ???? sysadmin ????? ?????? fn_get_sql.

?????

???? ??????? ????? ???????? ?????? ?????? fn_get_sql ???????? ?? ????? ??????? ????????. ??? ????? ????? ????? ???? ????? ????? (SPID) ? ??????? ???? ??????? ???? SQL ?? ??? SPID ??????? ???? fn_get_sql ?? ?????? ? ??????? ???????? ????? ????????? ?????? ?? SQL ??????? SPID. ??? ???? ??????:
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52
SELECT * FROM ::fn_get_sql(@Handle)
5.1.11 ????? ??????? ????? ???????? ????????
??????? ?? SP3

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

??? ????? SP3a ?????? ????? ???????? "? ???? ???? ?????? ????? ????? ?????? ??????? ????? ???? ?????? ????? ????? ????? ???????? ????????. ???? ???????? ????? ????? ????? ????? ????? ????? ???????? ???????? ??????? ????? ????? ?????? ????????. ????? ????? ????? ????? ????? ???????? ???????? ??????? ????? ????? ??????. ????? ?? ?????????? ???? "??????? ?? ????????? ???????" ???? ?????? ????? ??????.

??? ????? Desktop Engine SP3a ? ????? ??????? ??????? ??????? ALLOWXDBCHAINING ?????? ????? ????? ???????? ??? ????? ??????? ????? ????? ??????. ????? ?? ?????????? ???? ?????? 3.7.3 MSDE 2000 ????? ??????.

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

??? ???????? ????? ??????? ????? ??????? ?????? ????? ?????? ??????? ????? ????? ?????? ?? ?????? ??????? ????? ???????? ????????:
  • ??????? ???? ?????? OwnershipChaining DB ??????? ?????? p_configure s ??????? ??????.
  • ?????? ?????? ?????? ????? ??????? ????? ???????? ???????? ??? ????? ??????? ???? ?? ???? ?????? ????? ???? SQL ?? "????? ???????.
  • ??????? ?????? ?????? ????? ????? ???????? (DMO) SQLServer.Configuration.ConfigValues. ??? ?????? SQLServer ??????? ??? ???? SQL Server 2000 SP3 ?? ??????? ?????? ??? ??? ???????? ????? ??? ???? ConfigValue ???? ?????? ????? ??????? DB.
??? ?? ????? ????? ????? ????? ????? ???????? ???????? ?????, ????? ????? ?????? ?????? ?????. ?????? ????? ??????? ?????? ????? ????? ????? ???????? ???????? ?????? ?????? ??????:
  • ?????? ?????? ????? ????? ?????? ????? ?? ????? ?????? ?????? sp_dboption.
  • ?????? ?????? ????? ??????? ????? AllowCross ?? ??? ????? ??????? ?????? ???? ?????? "????? ????? ????????" ?? "????? ???????.
  • ?????? ??????? DBChaining ?????? DMO DBOption2.
?????? ??? ??? ?????? ?????? ????? ????? ????? ???????? ???????? ??? ????? ?? ??? ????? ?? SP3 (??? ????? 8.00.[BUILD_NUMBER]) ? ??? ?????? ??? ????? SP3a ??? ????.

????? ?? ?????????? ???? ??? ???? "???????" ?? ?????? "????? ???????? ??????? ?????" ??? ????? ?????? ??????? ?? ????? ??????? ??????? ?? SQL Server 2000 ???????? ?? ???? ????? ????? ????? 810474.
5.1.12 ????? ?? ????? ???? 1204
??????? ?? SP3

????? ????? ???? 1204 ??? ?????? ??????? ???????? ?? ???? ???? ??? ?? ?????? ?????? ????????. ?? SP3 ?????????? ??????? ????? ???? ??? ??????? ?????? ??? ??????? ???? ???? ??? ???????? ????? ??? ?????
5.1.13 "????? ????????" ?????? sp_changedbowner
??????? ?? SP3

???? ????? ????? ??? ?????? ???? ????? ?????? ??? ????? ?????? ?????? sp_changedbowner.
5.1.14 ??????? ????????? ??????
??????? ?? SP3

?? ????? ????? ??????? ??????? ????????? ??????? ?? Microsoft Visual Studio 6.0 ? ??????? ?? ?? SQL Server ???? ??????? ??? ??? SP3 ???? ???????. ?? ????? ????? ??????? (????? ??? ???? ????? ??????? SQL ???????? ?? SQL Server ????? ????? ????? ????) ????? ???? ???????. ?????? ????? ??????? ????? sp_sdidebug ? ????? ??????? legacy_on. ?????? ????? ????? legacy_off ??? ??? ???????.

?????? ????? sp_sdidebug ??????? ?????? ??? ????? ??????? ??? ??????.

????? ?? ?????????? ???? ????? "????? ??????? ?? Microsoft" 328151. ????? ??? ??????? ?? ?????? ?????? ????? ????? ??????? ?? Microsoft.
5.1.15 ?????? ????? ???? UDP 1434
??????? ?? SP3a

????? ?? SQL Server 2000 SP3a ?????? ???????? ?????? ???? ????? ?????? SQL Server 2000 ?MSDE 2000 ???? ?? ??? ??????? ???? ???? ???? ????? ????????? ???????? ???????? ???? ?????? ???????? (UDP) 1434. ??????? ???????? ???? ?? ??????? ???? ??????? ?????? 1434 UDP

???? ????? ???? ????? SP3a ???????? 1434 UDP ???? ???? ???? ?????? Net ????? ???????? ??????? ???????? Net ????? ?????. ???? ????? ?????? ???????? ???? 1434 ???? ??? ?????? ?? ???? ?????? Net. ?????? ??? ??????? ??? ????? ?? ????? ???? ?????? Net ???? ??????? "SQL Server ?????? ????????" ?? SQL Server 2000 ????????.

??? ???? ??????? ???? UDP 1434 ?????? ??????? ??? ????? SP3a ???? ?????? SQL Server 2000 ? MSDE 2000 ??? ????????? ? ????? ??????? ?????? ??? ??.

?? ??? ??? ???? UDP 1434 ????? ?? ???? ?? ????? ??? ???? ??????? ???????? ????? ??????. ??????? ????? ?????? ??????? ????????? ??????? ??? ? ?? ?????? ???? ????? ????????. ??????? ???????? ????? Net ??? ?????; ?? ???? ????? ?? ?????.

????? ????? ????? ?? ??? ?? ????? ???? ?????? Net ??? ????? ?? ????? ???? MSDE 2000. ?????? ??????? DISABLENETWORKPROTOCOLS ?????? ???????? ????? MSDE 2000, ?? ??????? SqlDisableNetworkProtocols ?????? ??????? ??? MSDE 2000. ?????? ??? ???? ?? ????????? ??? ??? ???????? ???? 3.7.3 MSDE 2000 ????? ??????.

?? ????? ????? ???? ?????? ???? ????? ?????? ?????? Net ??? ????? ?? ????? ?????? SQL Server 2000.

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

????? ??? ?????? ????????? ???? ?? ??????? ?? SP3a ??? ????? ????? SQL Server 2000.
5.2.1 ????? ??????
??????? ?? SP1

????? ??? ????? ??? ?? ??? ??? ???? ???? SP1 ?? ????? ???? ???? ????, ??? ?? ?????? ?????? ??????? ???? ?????? ???? ???? ?????? ?????? ?????? ??? ?????? ????? ??? ?????? ??????. ?? ???? ?????? ??? ?? ????????? OLAP ?????? ??? ?????? ?????? ???? ?????? ?????? ??????.
???????? ??? ???? ??? ??? ?????? ?????? SP1 ?? ????? ???? ???? ???? ??? ?????? ?????? ????? ??? SP1 ?? ????? ???? ???? ???? ???? ???? ????? ?????? ?????? ?? ?????? ??????? ??????.
5.2.2 ????? ??????? ????? ????? ???? ??????? ?????? ???????
??????? ?? SP1

????? ????? SP1 ?????????? ?????? ????? ??????? ?????? ?? ????? ??????? ??????? ??? ?????? ??????? ??????? ?????? ???????:
  • PTSLite.exe
  • PTSFull.exe
??? ??????? ???????? ?? ???? \Msolap\Install\PTS ???? ????? ???? ??????.

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

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

?????? ??? ??????? "????? ???????" ?? Office XP ? ????? ?????? ???????? ??????.
5.2.3 ????? ??? ?????? ????? ????? ???????? ???
??????? ?? SP1

????? ????? SP1 ?????????? ?????? ????? ??? ????? ????? ???????? ??? ???????? ????????. ?????? ??? ???? ?? ????????? ??? ????? ???? ???????? ??? ?????? ???? ????? ?????? "????? ????? ??? ????????" ? ?? OLE DB ???????? ??????? Resource Kit ? ????? ????? ????? ??????? ???????? ????? ??? ??????.
5.2.4 ????? Analysis Services ?? ??????? ?? ????? ???? ??????
??????? ?? SP1

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

??? ??? ?????? ????? ????? SQL Server 2000 ??? ??????? ???? ????? ??? ????? ???? ??????? ??? SQL Server 2000 ?????? ????? ?????? SP1 ?? Office XP? ??? ????? Analysis Services SP1 ?? ????? ???? ???? ?? ?? ???? ?????? ???? ???? ??? ??? ????? ??????? ??????.
5.2.5 ?? ????? ?? ?????? OLAP ????? ?????? ???? ???????
??????? ?? SP3

???? ???? ?????? ?????? ??????? ?????? ??? 255. ??? ???? ?? ?????? ??????? ????? ?????? ???? ?? 64 ??? ???? ??? ?? ????? ?? ???? ® Microsoft PivotTable ???? ?? ??????? ??? SP3.
5.2.6 ???? ?????? ????? ?????
??????? ?? SP3

?????? ?????? ???? ???? ????? ??? ???? ????? ?????? ? ?????. ??? ??????? ?????? ???????? ????? ????? ????? CREATE CUBE ?????? ??????? ????????? (MDX) ????? ??????? ????? ??? ???? ?????. ?????? BNF ??????? ???? ????????? ???? ?? ??????? ??? ????? CREATE CUBE:
<dimensions def> :: = DIMENSION <dimension name> [<time def>] 
  [DIMENSION_STRUCTURE <sub_type>] [<hidden def>] 
  [DESCRIPTION <description expression>] 
  <options def> <comma> <hierarchy def list> 
<measures def> :: = MEASURE <measure name> <measure function def> 
  [<measure format def>] [<measure type def>] [<hidden def>] 
  [DESCRIPTION <description expression>] [<comma> <measures def>]
5.2.7 ????? ???? ???? PivotTable ??????? ?????
??????? ?? SP3

????? SP3 PivotTable ???? ????? ????? ????? ????? ? "???? ????????". ???? ??????? ??? ??????? ?????? ???? PivotTable ?? ??????? ????? ?????? ??????. ??? ??? ?????? ??????? ????? ????? ????? ????? ?? ??????? ???? ??????? ??? CREATE CUBE, CREATE CUBE ???????? ??????? CUBE ???? CREATE ???. ???????? ??? ???? ??? ?? ???? ????? ??????? ???? ??? ????? ?? ?????? ????? ????????? ? ??? ??? ??? ???? ??????? ???? ?? ??????? ?? ???? ????? ??? ???? ????? ???? ?? ??? ???? PivotTable.

???? ??? ??????? ???? ?????. ??? ?? ????? ?????? ??? ?? ???? ????? ???? ?? "Y" ???? "y" "T" ?? "t" ?? ??? ???? ????? ???? ??????? ??? ???? ????? ????? ?? 0 ? ???? PivotTable ???? ??? ?? ???? ??????. ??? ?? ????? ?????? ??? ?? ???? ????? ? ??? ???? ????? ????? ("") ? ?? ??? ???? ??????? ???? ??????? ??? ???? ????? ????? 0 ???? PivotTable ??? ????. ?????? ?????????? ???? ??????? ?? "0".

?????? ?? ??? ??????? ?? ????? ??????? ???????? ??? ???????? ???????.
5.2.8 ????? ?? ????? ?????? ??????
??????? ?? SP3

????? ??????? ?????? ???? ??? DBPROP_MSMD_SAFETY_OPTIONS_ALLOW_SAFE ???? ????? ??????? ?????? ?????? ???????? ?? ?????? ??????.
5.2.9 ????? ?????? ??? ????? ?????? ??????? ???? ?????? ?????????
??????? ?? SP3

?? ????? ???? ??????? ????? ??????? "????? ?????? ???????" ?? "????? ?????? ???????" ?? SP3 ?? ??????? ?????? ?? ??????? ??? ??????? ??? ??????. ??? ???? ?? ???? ??? ?????? ????? ??? ??????? ????? ????? ?????? ???? ????? ??????? EnableMigrationToMetaDataServicesFormat.

?????????? ?? ???? ????? ??????? ???; ???? ??? ?? ???? ?????? ????? ??????? ??????? Server\Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP ?????? ?????? ??????? ??????? ??? "????? ?????? ???????" ?????. ???? ????? ??????? ??? ???? ????? ???? ???? ??????. ??? ?? ????? ?????? ??? 1 ?? True "? ??? ????? ??????? ??????? ??? ?????" ????? ?????? ??????? ". ??? ?? ????? ?????? ??? ?? ???? ??????? ?? ?? ???? ??? ???? ????? ??????? ????? ??????? ??????? ??? ????? "????? ?????? ???????".
?????? ?? ???? ????? ???? ????? ??????? ??? ??????? ???? ??????? ?????.
5.2.10 "?????? ???" ?? ???? ??????? ?? "???? ???????? ??????"
??????? ?? SP3

??? ??? ?????? "?????? ????? ???????" ??????? ??? ??????? ??? ??? ???? ???? ?????? ?????? ????? ? ??? ???? ????? ???????? ??? ?????? ??? ????? ??????? SP3a. ??? ????????? ?????? ?????? ???????? ??? ?????? ?????? ??????? ?????? ?????? ?? ??? ???? ????? ???????? Administrators OLAP ??? ????????? ???? ???? ??????? ?? ??????. ?? ???? ?????? ??? ??? ??????? ??? ????? ?? ??????? ?? ?????? ????????? OLAP ? ??? ?????? ?? ????? ???????? ??? ???????? ?????? ?????? ???? ???? ??????? ??????? ????????? OLAP ????????. ??? ??? ???? ????? ????????? ?????????? ???? ????.

???????? ??? ???? ??? ????? ??????? SP3a ? ??? ?????? ?????? ???? ????? ?????? ??? ?????? ?????? ?? ?????? ??? ?????? ?????? ????.

??? ??? ?????? SP3a ??? ???? ?? "????? ?????" ??? ??????? ?? ????? ?????? ???????? ????????? OLAP ????? ?????? ???????? ??? ?????? ?????? ?????? ?????? ??? ?????? ?????? ????. ????? ?? ????????? ??? ????? ?????? ????????? OLAP ????? ?????? ???? ??????? ??? 308023 ???????? ?? ?????? ??? ????? ????? ??????? ?? Microsoft.

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

????? ??? ?????? ????????? ???? ?? ??????? ?? SP3a ??? ????? ???????? ?? SQL Server 2000.
5.3.1 ???? UPDATE ????? ???????? ????????? ????? ?????
??????? ?? SP1

????? ????? ????? ???????? ????????? ??? ????? ????????? ??????? ????? ????? "?" ??? "?" ??????? ??????? ?? ????? ?????? ????????. ??? ????? ?? ??? ??????? ????? UPDATE ????? ??????? ?????? ??????? ??????? ?????? ???? ??????? ?? ???? ????????. ??? ????? ????? ?? ???? ?? ???? ??? ??? ????? ???????? ??? ???????. ???? ???? ???? ??? ??????? ??? ?????. ??? ???? ??? ??? ?? ?? ??? ??????? ???????? ????? ????? ??? ???? ?? ???? ?????.

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

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

sp_scriptdynamicupdproc

???? sp_scriptdynamicupdproc ????? ???? ????? CREATE PROCEDURE ???? ???? ??? ????? ????? ????? ???? ???? ?? ???????. ????? ????? UPDATE ???? ??????? ?????? ??????? ????? ???????? ??? ???? ???? MCALL ???? ???? ??? ??????? ???? ???? ???????. ?????? ??? ??????? ?????? ??? ????? ??? ??? ??????? ?? ?????? ?????????? ??? ??????? ??????? ????. ??? ????? ??? ??????? ?????? ?? ??? ?????? ??? ????? ???????? ???????.
Syntax
sp_scriptdynamicupdproc [ @artid =] artid

Arguments
[@artid =] artid

????? ???????. artid Int ?? ???????.

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

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

???????

??? ??????? sp_scriptdynamicupdproc ?? ????? ???????? ?????????. ????? ???? ??????? ???? ????? UPDATE ???? ??????? ?????? MCALL ????????? ?? ?????? "???? ?????" ?????? ??????? ???? ?? ???????. ??? ?? ?????? ???? ? ?????? ??? ????? ??? ???? ??? ???? ???? ???? ?? ????? ?????. ??? ????? ?????? ???? ?????? ??????. ???? ??????? ??? ??? ??????? ?????? ?????? ????? ?????: ????? ??????? ???? ?? ??????? ??? ????? ???? ????? UPDATE ????. ??? ???? ??? ?????? ?????? ?????? ?? ??? ??????? ??? ????? ????? UPDATE ???????. ?? ???????? ?????? ?? ?? ??????? ??????? ?????? ??????? ??????? ????????? ????? ??? ?? ?????? ???? ?????? ?? ??? ????????? ???????.

??????

???? ????? ????? ????? ??????sp_scriptdynamicupdproc

?????

??? ?????? ????? ???? (?? artid ??????? ??? 1) ??? ???? authors (????????) ?? ????? ?????? pubs (????????) ?? ????? ?? ????? UPDATE ??????? ??????? ?????? ?????:

'MCALL sp_mupd_authors'

Generate the custom stored procedures to be executed by the Distribution Agent at the Subscriber by running the following stored procedure at the Publisher:
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

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


5.3.2 ?????? UPDATE ????? ???????? ????????? ??? ????? ????
??????? ?? SP1

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

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

??????? ???? ??? ??????? ??????? ?????? 8207 ?? ????? ???????? ????????? ??????? ???. ?? ?????? ??? ??????? ?????? ?? ???????? ?????? ??????? ??? ??? ??????? ??????? UPDATE ???? ?? ???? ??? ???????.
5.3.3 ???? ??????? ?? ?????? ???? ?????????
??????? ?? SP1

?? SQL Server 2000 ?????? ???? ????????? ?? ??? ?????? ??? ????? ???? ????? ???? ???? ???? ?? ??? ????? ????? ?? ????? ???? ????????. ??? ?? ????? ??????? ???????? ??? ????? ???? ???????? ????? ????? ???? ???????, ???? ????? ???????? ?? ??? ????? ????? ??? ????? ???? ????????? ??? ?????. ??? ????? ?????? ??? ??????? ?????? ???? ??????? ?? ???? ?????? ???.
5.3.4 ????? ???????? ????????? ????? ????? ????????? ????????
??????? ?? SP1

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

sp_scriptpublicationcustomprocs

?? ????? ??? ??? ????? ?????? ????? ???? ????? ???? ?????? ? ????? ????
sp_scriptpublicationcustomprocs ??????? ?????? INSERT ? UPDATE ? DELETE ????????? ??????? ?????? ????? ???????? ??????.
sp_scriptpublicationcustomprocs ???? ???? ??? ????? ?????????? ???? ?????? ??? ????? ??????.
Syntax
sp_scriptpublicationcustomprocs [@publication]= publication_name

Arguments
[@publication] = publication_name

The name of the publication. publication_name is a sysname with no default.

Return Code Values
0 (success) or 1 (failure
??????? ???????

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

???????

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

??????

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

??????

???? ??? ?????? ?????? ?????? ??? ???? ????????? ??????? ?? ????? ????? Northwind..
exec Northwind.dbo.sp_scriptpublicationcustomprocs 
@publication = N'Northwind'

5.3.5 ??? ????? ???????? ???? ????? ??? ???????? ?????? ??????? ????? ?????
??????? ?? SP1

????? ?????? ??????? ????? ????? ????? ???? ????? ???????? ??? ????? ????? ?? ?????? ??????? ? ?????? ??????. ??? ??? SQL Server 2000 SP1? ?????? ??????? ?? ???? ????? ??? ?? ???? ????? sp_mergecleanupmetadata. ??? ???? SQL Server 2000 ?????? ????? ?????? SP1 ?????????? ?????? ????? ?????? ??????? ???????? ??? ???????? ????? ? ??? ???? ?? ?????? ??????? ???? ???????? ??? ?? ????? ?????? ???????:
  • MSmerge_contents
  • MSmerge_tombstone
  • MSmerge_genhistory
  • ?? ??? ??????? ?????? ??? ??? ???????
?????? ????? ??? ??????? ?????? ??? @ keep_partition_changes ??? ????? ?????? ?????? ???????? ??? ???????.

???? ??????? ???????? ??? ???????? ????? ???????? ??? ???:
  • ??? ?? ????? ????? "???? ???" ?MetadataRetentionCleanup ??? 1? ??? ???? ??????? ? ?????? "???? ???" ????????? ??????? Publisher ??????? ?? ?????.
  • ??? ??? MetadataRetentionCleanup-????? ??????? ??? 0? ???????? ???? ??? ?? ????. ?? ??? ??????? ?????? ??? ???????? ??? ???????? ?????? ??????? ????? ?????? ????? s p_mergemetadataretentioncleanup. ??? ?? ??? ????? ??? ??????? ?????? ?? ?? Publisher ? ??????? ??? ?? ???? ?????. ??? ?????? ???? ??? ?????, ?? Publisher ? ????????? ???? ????? ???? ?????? ?? ????? (???? ??? ????????? False ?????? ?? ??? ?????).

    ??????-MetadataRetentionCleanup ????? ??????? ??? 1 ????? ????????? ???????? "??? ????" ???? ?? ??????? ?? SQL Server 2000 ?????? ????? ?????? SP1 ?????????? ??????. ?? ???? ????? ???? ??? SP1 ?? ???? ?? ????? ????? ???????? ??? ??? ????? ??? ????? "???? ???" ???????? ????? ??? ???????. ??? ??? ?????? ???? ?????? ????? ???????? ??? ???? ??? SP1 ?? ????? "???? ???" ?? ??? ????? ??????? ??????? ????????; ????? ??????? ??????? ?? ???? ????? sp_add_agent_parameter (???? ????? ?????? ?? sp_add_agent_parameter ?????? ?? ??? ?????).

    ??? ????? ???? ???????? ?????????? ????????? 14 ???. ??? ???? ????? ????? ?? ??????? ????? ?? ???? ???? ????? ????????? ??????. ?? ??? ??????? ??? ??????? ???? ???? ????????? ?????? ???? ???????? ??? ?????? ????? ????. ??? ??? ???? ??? ??????? ??? ????? ?????? ???? ?????? ??? ??? ????????? ??? ???? ??????? ????? ?? ?????? (@ ??????? = 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

???? ?????? ??????? ????? ????? ???? ?? ????? ?????? ???????? ?? ????? ???????? "???" ? ??? ?? ????? ???????? "?" ???? ??? ?????? ??? ???????? ???? ?????? SQL Server 2000 ?????? ????? ?????? SP1 ?? ????. ??? ???? ??????:
  • ??? SQL Server 7.0 ??????? ?? ??? ????? ????? ??? ?????? SP1 SQL Server 2000.
  • ??? SQL Server 2000 ?????? ????? ?????? SP1 ??? ???? ?? ??? ????? ????? ?? ????? ?????? ????? 2000 SQL Server ??? ???? ?????? SP1.
  • ??? SQL Server 2000 ?????? ????? ?????? SP1 ??? ???? ????? ??????? ???????? ??? ?? ????? ?????? SQL Server 2000 SP1 Publisher ??? ?? ???? ???? ????????? ???? ???? ????? ??????? SQL Server 2000 ?? ????? ????.
???????? ????? ??? ??? ??????? ???? ?? ??????? ??? ??? ?????? ??????? false ????? ? ??? ?? ???? ??? ???????. ?????? ??? ???????? ???? ????? ??????? SQL Server ??? ??? SQL Server 2000 ?????? ????? ?????? SP1 ?? ???? ????? ?????? ?? ???? ????? sp_mergemetadatacleanup ??? ???? ???????? ???? ??? ??? ????? ????????.

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

??? ??????? ???????? ??? ???????? ????? ???????? ??? ??????? ??? ???? ???????? ??? ????????? ?? ????? ??????. ??? ???? ???? ?? ???? ????????? false ?? ???? ???? ?????? ???????:
  • ????? ?????? ??????? ?? ???? ????? ? ?? ???.
  • ???? ????? ????? ?? ???? ????? ??????? ??? ?? ?? ??? ?????? ??????? ?????? ??.
??? ???? ??????? ?? ???? ????? ?????? ??????? "??? ?????? ???? ?? ??? ??????? ????? ????? ??? ?????? ???? ????? ??? ????? ?? ?? ???? ???????? ????????.

???? ??? ??????? ???? ?? ????? ?????? ??????? ?? ??? ??? ????? ?? ??? ??? ?????. ??? - ????? MetadataRetentionCleanup ??? 1? Publisher ? ??????? ??? ????? ???????? ??? ??? ????? ??? ???????? ?????? ?? ?? ??? ????? ????? ?? ??? ?????. ??? ??? ????? ??????? ???? ????? ????? ???????? ??? ?????? ??????? ?????? ??????? ??? ??? ?????.

?? ??? ????? ????? ??? ??????? ????? ?? ?? ??????? republishing ?? ?????? ????? ????? ????????? ?? ???? ?? Publisher ? ???????. ?????? ???? ????? ?????? ??????? ??? ???? ???? ???? ?? ????? ?? ???????? ?? ??? ????????? ?????? ??? ????? ????????? ??????.

?????? ??? ???? ????? ????? ?????? ??? ????? ????? ?? ?????? ??????? ???? ??? ?? ???? ?????, ?? ?????? ????? ??? ???? ??????. ????? ?????? ??????? ???? ????? ???? ??? ???????.
5.3.6 ????? ????????? ?????????? ??????? ?????? ??? ????? ????????
??????? ?? SP1

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

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

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

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

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

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

    ??? ??????? ???? ??????? ??????? ?????? ??? ??? ?????? ?????? ?????????? ?? ???? ???? ?????? ??? ???? ???????. ??? ??? ????? ??? ??? ????? ???? ??????? ??????? ?????? ?????? ??? ?? Publisher (???? ??? ?????? ??? ?????? ???????) ? ?????? ??? ?????? ???????? ??? ????? ???? ??????? ?????????. ????? ??? ???? ?? ????? ?????? ?????? ??????? ????? ?????? ????????? ??? ??????? ???? ???? ??? ??? ???????.
  • ??????? ??? ????? ??????? ??????? ?????? ???? ???????? ?????? ??????? ?????? ???. ?? ???? ??????? ??? ?????? ??? ??? ???????.
5.3.7 ??????? ????? ????? ?????? ?? ??????? ?????? ?? SQL Server
??????? ?? SP1

??????? ???? ???????? ??? ??? ???? ?????? ? ?????? ??? ??????? ???? ??????? ?????? ???? ?? ????? ?????? ?????????? ? ????? ??????? ????? ????????. ??? ??? ???? ???????? ????? ?????? ?????? ??? ????? SQL Server ????? ?? ??????? ???????? ???? ???? ???????? ?? ????? ???????? ??? ?????? ???????? ???????:
  • ??? ??? ???? ???????? ????? ???????? ??? SQL Server 2000 SP3a ?? ???? ???????? ?? ??????? ?????? SQL Server 2000 ???? ???????? ??? ??????? ????? ???????? ??? ???? ????? sp_vupgrade_replication. ???? ????? sp_vupgrade_replication ????? ?????? ????? ????? ????????. ??? ?? ??? ?????? sp_vupgrade_replication ???? ??? ?????? ????? ????? ???????? ?? ???? ??? ??????.
  • ??? ??? ???? ???????? ????? ???????? ??? SQL Server 2000 ?? ???? ???????? ?? ??????? ?????? SQL Server 7.0 (???? ??????? ? SP1 ? SP2 SP3 ? SP4) ????? ?? ???????? ?????????? ????? ???????? ??? ????? ????? ????? ????????? ??? ????? ??? ??????. ???? ??????? ????? ???????? ??? SQL Server 2000 SP3a ?????? ?? ???? ???????? ?? ????? ?????? ?? ??????? ?? SQL Server 7.0 ???? ?? ??? ???????? ??????? ????? ????????.
5.3.8 ???? - MaxCmdsInTran ????? ???? ???? ???
??????? ?? SP1

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

???????? ?MaxCmdsInTran ? ??? "???? ???? ???" ????????? ???? ??? ??? ???? ?????? ?? ???? ??? ?? ??? ??????? ??? -MaxCmdsInTran ???????. ????? ???? ?? ???? "???? ?????" ?????? ??? ??????? ?? ???? ????????? ????? ??? "???? ???? ???" ?? ???? ??? ??? ???? ?? ??? ????????.

????? ??? ??????? ?? parallelism ??? ???? ???? ??? ???? ????? ???? ??????? ????? ???????? ?????. ??? ???? ???? ?? ??? ???????? ??? ????? ??? ??????? ?? ????????? ??????? ???? ????? ??????? atomicity ???? ????? ???? (Atomicity ????? ? ??? ? Durability). ??? ??????? ??? ????? ?? ???? ???????? ?????? ?? ???????? ?????? ??? ??????.

????? ?MaxCmdsInTran ?????

????? ??? ???? ???? (1 ?? ????) ????? ???????-MaxCmdsInTran. ???? ???? 0 ????? ?? ?????? ???????. ??? ??? ??????? ?????? ?????? ??? ????? ???? ???????? ?????, ???? 5000 ?? ???? ???? ??????? ?????????. ??? ???? ??????:

logread.exe MaxCmdsInTran 10000.

???????? ??? ??????? ??? ????? ?????? SQL Server 2000 ?????? ????? ?????? SP1 ?? ????? ???? ?? ??? ????? ????? ???????? "???? ???? ???" ???????? ??? SP3 ?? ????. ????? -MaxCmdsInTran ??? ?????.
5.3.9 ????? ??? ????? ??????? ???????? ??? ????
Introduced ?? SP2 (????? ??? "????? ???????? ???????" ???)

?? ????? ????? ???? ?????? ???????? ??? ???? ?? ???? ??? ??? ????? ???????? ?????????. ??? ????? ?????? ??? ????? ????? ?? ????? ????? ??????.
5.3.10 ???? - ????? ??? ??????? MaxNetworkOptimization ????? ???????
??????? ?? SP2

????? ?????? ?????? ???? ????? ????? ???????? ??? DELETE ????? ??? ????????? ?????? ???? ?? ????? ??? ??????? ????? ?????. ??? ??????? ????? DELETE ?? ??? ????? ??? ??? ???. ??? ??? ?? ???? ??? ????? ???????? ?? ??????? ???? ???? ?? ???? ???? ???? ???? ??????? ??? ????????.

?????? ?????? ?????? ???? ??? ??? ???? ??????? ??????? "???? ????" - MaxNetworkOptimization ?? ??? ????? ???????? ?????????. ????? ??????? ??? 1 ????? ??? ???? ??? ???? ????? ????? ???? ???? ???????.

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

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

????? ????? ??? ??????? ??? ??? ????? "???? ????" ?????? ????? ??????? ?????? sp_add_agent_parameter ??? ???:

EXEC sp_add_agent_parameter 1? 'MaxNetworkOptimization' 1
??? 5.3.11 ????????? ????? ???????? ??? ????
??????? ?? SP3

SP3 ????? ?????? ??? ???? ????????? ?????? ???????? ?????? ??? ????? ????????. ??? ????? ?????? ?? ????? MSmerge-< ???? ??????? >. ??? ????? ??? Publisher ?? ????? ??? ????? ???????? ????? ????? ?????? ?????? ??????? (PAL) ?????? ?? ?????? ??? ??? ????????? ??? ??????. ??? ?? ????? ??? ????? ????? ????? ????? ????? ???? ??????? ?? SP3 ?? ????? sp_createmergepalrole, ?????? ????? ?????. ??? ????? ??? ??????? ?????? ?? Publisher ??? ????? ?????? ??????? ??? ????? ????? ?????. sp_createmergepalrole
Syntax
sp_createmergepalrole [ @publication = ] 'publication' 

Arguments
[@publication = ] 'publication' 

The publication name. publication is sysname, with no default. This parameter is used to select the publication to use when re-creating a role used by merge replication. 

Return Code Values
0 (success) or 1 (failure)
???????

????? sp_createmergepalrole ????? ?? ???? ??? ???? sysusers ??? ????. ????? ??? ??? ????? ?????? ??? ???? ?????? pubid ?? ?????? sysmergepublications ????? ??????. ????? ??? ????? 'MSMerge_' ??? ??? ????? ???? pubid (???? ????????) ??? ?????.

??????

???? ??? ?????? sysadmin ???? ??? ???? ?? ??? ????? ???????? ??????? db_owner ????? sp_createmergepalrole.
????? ??????? ???? ?? ???????? 5.3.12 ?????? ?????????? ??? ????? ??????
??????? ?? SP3

??? ?? ????? ?????? ?? ??? ?????? ??? ????? ?? ????? ?????? sysadmin ???? ??? ???? ? ??? ?? ???? ??? ????????? ???????:
  • ????? ???? ?????? SQL Server ???? ????? ?????? ????? ?????? ???? ??? ????? ???? ???? ???? ???? SQL ???????? ???? ????? ???????? ?? ???????? ?????. ????? ?? ?????????? ???? ??????? "xp_sqlagent_proxy_account" ?? "??? SQL Server ???????".
  • ????? ???? ?????? ?????? ??? ?????? ???? ????? ??? ????? ?????? ?????? ???? ??? ????? ??????.
?????? ????? ?????? ??????? ???? ???? ????? ?????? ?????? ???? ??????? ?? ???? ???? ???????? ?? ??? ????? ?????? ?????? ?????.
????? 5.3.13 ??? ?????? ????????? ????????
??????? ?? SP3

?? ????? ???????? ??? ??? ?? ????????? ??????? ??????? ????? ?????? ??????? ???????? ????? ??????. ????? ???? ??? ????????? tightening ?? ???????? ???????? ?????? ????????? ???????. ????? ?? ????????? ??? ?????? ????? ?????? ??????? ???? Transact-SQL ?????? ??? ??????? ????? ???????? ???? ?? ??????? ?? ??????? ??????? ?? "??? SQL Server ???????". ????? ?? ????????? ??? ????? "??? SQL Server ???????" ???? "?????? 1-6 ????? ??????? Online ????? ?? ????????".
5.3.14 "????? ?????" sp_addmergearticle ? sp_changemergearticle
??????? ?? SP3

????? ????? ? @ published_in_tran_pub ? ?? ????? sp_addmergearticle ? sp_changemergearticle. ??? ??????? ??? ??????? ??????? ????? ??? ??? ????? ?? ????? ??? ?? ????? ???????. @ published_in_tran_pub ?? nvarchar(5) ? ?????? ??????? FALSE. TRUE ????? ??? ??????? ????? ?? ????? ???????.

?????? ??? ????? ??? ??????? ?? sp_changemergearticle ??? ?? ???? ????? ?????? ? ??? ?? ???? reinitialized ?????????.
5.3.15 ????? ???? ????? ?? ????? ?????? ???????
??????? ?? SP3

????? ???? ????? ???? ????? ????? ?????? ?????: "???? ?????? ????". ??? ????? ???? ???? ??? ??? ?????? ??? ?????? ???????? ?? ???? ???????? ?????? ??? ?? ???? ???? ?? ???? ?? ??? ???????? ??? ???? ????. ???? ??????? ??? Publisher ???? ???? ????? ???? ????? ? ???? ????. ?????? ??????? ?? ????? ?????? distributor_admin. ???? ???????? ?????? ??? ????? ??? ??? ????? ??? ?? ???? ?????? ???? ????? ???? ????.

?????? ?? ???? ???? ????? ?? ????? SQL Server 2000 ???????? (Updated - SP3) ? ????? ??? ????????? ??? ????? ??? ???? "???????" ???? ?????.
????? 5.3.16 ???? ????? ???????? Windows
??????? ?? SP3

???? SQL Server ????? ?????????? ???????? (?? ?????? ???????? ????? ??????? SQL Server SQL-DMO ?????????? ??????? ????? ????????) ????????? ???????? ????? ??????? ?? Windows. ????? ????? ????? ???????? ???? ???????? ????? ??????? Windows. ??? ????? ???? ??????? ??? ?????? ?????? ??????? Windows Synchronization Manager ???? ???? ?????? ?? ????? ?????? ???????? ??????? ??????? ???????? ?? ????????.
????? 5.3.17 ??? ??????? ????? ?? ??????? ????? ?????? ????? ??????
??????? ?? SP3

??? ?????? ????? ?? ???????, ?? ????? ??? ????? ???????? ?? ????? ????? ?? ??????? ????? ?????? ??????. ???? ??? ??????:
  • SP3 ?? ???? ?? ??????.
  • ???????? ????? ????? ???????? ??? ????? ??? ????? ?????? ?????? ?????.
  • ????? ????? ???????? ???????? ?? ??? ?????? ??.
??? ???? ???? ?????? ??????? ????? ??? ????? ??????? sp_changedbowner ??????? ?? ????? ???????? ??????? ?? ??? ?????????. ????? ????? ????? ???? ??????? ?????? sa. ???? ??? ????? ???????? ???? ???? ????.

?????? ??? ?? ???? ????? ??? ????? ?????? ?????? ???? ????? sp_changedbowner.

????? ?? ????????? ??? ????? ????? ???????? ??? ????? ???? ??? 5.1.11 "????? ???????" ????? ???????? ????????.

5.4 ??????? ???? ???? SQL

????? ??? ?????? ????????? ???? ?? ??????? ?? SP3a ????? ???? SQL.
5.4.1 ??????? ?????? ????? ???? ???? SQL
??????? ?? SP2

SQL Server ???? ??????? ?????? ???? ???? ????? Windows ??? ???? ???? ?? ???? ????. ????? ??? ????????? ?? ????? ????? ?????? ?? ?????? ???????? ??? ???? ?????? ???????? ???? ?? ??????? ????? ???????? ??????? ????? ????? ???????? (DTS) ?????????.
????? 5.4.2 ??? ??????? ???? ?????/?????
??????? ?? SP3

???? ??????? multiserver ????? ????? ?????? ???????? ??? ?????? ?????? ?? SQL Server. ??????? ????? multiserver ??? ??? ???? ?????? ????? ?? ???? ?? ?????? ???? ???? ?????? sign ????? ???? ?????.

?? SP3a ? ???? ???? SQL Server ???? ?? ???? ?? ???? ????? Windows ??? ??? ??? ???? ??????? ???? ???? ???? ?? SQL Server. ?????? ??? ???? ?? ????????? ??? ???? ???? SQL Server ???? ? ???? ???? 5.7.3 SQL Server ???? ???? ???? ???????. ??? ?? ???? ???? ???? SQL Server ???? ??? sysadmin ???? ??? ????.

?? ????? multiserver ??? ?? ???? ???? ???? ??? ????? ???? ????? ????? ??? ???? ??? ?????. ???? ????? ?????? ???? ??? ??????? ??????? ?? ?????? ?????. ???? ????? ?????? ?????? ???????? ?? ??????? ???? ?????? ???? ??? ??????? ??? ??????? ?????. ??????? ???? ???? ?????? ??????? ????? ??? ????? ?????? ??? ????? ???? ??? ????? ?????? ?????. ?? ???? ???? ???? ????? ?????? ?????? ?????? ????? ?? ??? ??????? ?? ???? ?????. ??? ????? ?????? ?? ?????? ????? ???? ?????? ??????? ????????? ???? ??????.

??? ????? SP3a ??? ????? ?????? ?? ??????? ?????? ????? ?????? ???????/??? ???? SQL Server 2000. ????????? ???? ??? ??????? ?? SP3a ??? ??????? ?? ?????? ????? SQL Server 7.0 ?? ?? ?? ???????? ???? ?? ?????? SP3a. ??? ????? ?? ????? SQL Server 2000 ??????.

?????? ????? ?????? ????? ?? ?????/???
  1. ????? ???? ???? (???? ?????) MSX ??? ???? ?????. ??? ?????? TSX (?????) ?????? (?? ?????) ???????. ?????? ????? ?? ?????? ??????? ???????. ?????? ? ???? ??? ????? ?????? ???--?????? "???? SQL B: ????"
    --Option A: Windows authentication
    EXEC sp_grantlogin 'DOMAIN\user'
    GO
    USE msdb
    GO
    EXEC sp_adduser 'DOMAIN\user', 'DOMAIN\user', 'TargetServersRole'
    GO
    
    --Option B: SQL Server authentication ? see explanation below for 
    --details.
    EXEC sp_addlogin <MSXAccount>, <MSXAccountPassword>, 'msdb' 
    GO
    USE msdb
    GO
    EXEC sp_adduser <MSXAccount>, <MSXAccount>, 'TargetServersRole'
    GO
    
    ??? <msxaccount>???? ??? ????? ???? SQL ???? ?????? ????? <msxaccountpassword>???? ?????? ????????.

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

    ???? ???????? ??????? ??? ?????? ???? MSX:
    • ?????? Windows. ??? ?? ?????? ?????? ?????? ???? ?? ???? ????? ????? ?????? ??? ???? ????? SQL Server ? SQL Server ???? ???? ???? ????? Windows ??????.
    • ?????? ???? SQL. ????? ??? ?????? ?????? ???? ???? SQL ?? ???? ???? ???? ??????? ?????? ???? ??? ???? SQL Server ?????? ??? ???????? ????? ?????? ???? ?? ???? ???? (LSA) ???? ??? ????? ??? ????????? ???????? ??? Windows ??????. ????? ????? ???? ???? ?????? TSX ?? ????? ????? ???? ???? ??? ???? TSX.
    ?? ???? ???? ?????? ???? ???? SQL (<computer_name> _msx_probe_login). ???? ?? ??????? ??? SP3 ?? ??????? ?????? ????? SQL Server ?????? ?????? ?????? ???? ?? ??? ?????? TSX ??????? ???.
  2. ????? ?????? TSX ??? SP3a ???? ?????. (??? ????? ???? ??????? ???? ?????? 3 ?????? ??? ???? ?? ????????? ??? ????? ???????.)
  3. ?????? ????? ??? ????? ??????? ?????? ??????? xp_sqlagent_msx_account ??? ?? ???? TSX ??? ?????? ??????? SP3a ??? ????.

    ?????? ??? ????? xp_sqlagent_msx_account ? ??? ?? ???? ????? ???? SQL ?????? ?????? ??? ?? ????.

    ????? ?? ????????? ??? xp_sqlagent_msx_account ???? ?????? 5.4.3 "???? SQL Server ???? ??????? ????? ????".
  4. ????? SP3a ???? ?????. ??? ????? ?????? _msx_probe ?????? ??? ??????? SP3a ???? ?????? TSX ????????? ?? ???. ??? ??? ???? ???? ???? SQL ???? ? ?? ??? ????? ?????? ?? ??? ????? ???? ?????? ??? ?????? ??? ? ?????? ?????? ??? ????????. ??? ??? ???? ?? ?????? ??????? ?????? _msx_probe ?????? ??? ???? ???? SQL ?????? ?? ???? ??? ????? ???? ???? ???? _msx_probe.
5.4.3 ??????? ???? ???? SQL ???? ????? ?????
??????? ?? SP3

????? SP3a ???? ????? ????? ???? ???? ???? ?? ????? ?????? ???? ???????? ???? SQL Server ???? TSX ?????? ????????? ?? ???? MSX. ??? ?????? ?? ???? MSX ?? ???? ???? ????? ???? ?????.

xp_sqlagent_msx_account

????? xp_sqlagent_msx_account ????? ??????? ?????? ?? ??????? ??? ?????? ???? SQL Server ???? MSX ????? ?????? ??? ?? ?? ??????? LSA ??? ?????? TSX. ???? ??? ?????? ??? ???? ???? securityadmin ????? ??? ??????? ??????? ???????.

??? ????? ??? ????? ????? ??????? SQL ??? ?? ??? ????? ???? Server. ???????? ??? ???? ??? ??? ?????? ?????? SQL ????? ???? ???? SQL Server ???? ??? ?? ????? ???? ???? ??????? Windows ??????. ???? SQL Server ???? ?????? ??? ???????? ????? ?????? ?? LSA ? ??? ????? ??? ????????? ???????? ??? Windows ??????.
Syntax
xp_sqlagent_msx_account

    {N'GET' |

    N'SET' | N'DEL', N'MSX_domain_name', N'MSX_username', N'MSX_password'

    }

Arguments
N'GET' 

??????? ???? MSX ???? ???? SQL ??????. N'GET ' ?? nvarchar ?? ???????. ?? ??? ??????? ???? ?????? ?????? ?????.

N'SET '

????? ?????? ???? ???????? ???? MSX ???? SQL Server ????. ???????? MSX_username ?????????? MSX_password ?????? ?????? ????????? ????? MSX ???? ???? SQL. N'SET ' ?? nvarchar ?? ???????.

N'DEL '

???? ??? ??? ???? MSX ???? ???? SQL.

'MSX_domain_name'

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

'MSX_username'

??? ???? Windows ????????? ????? MSX ???? ???? SQL. ????? ????? ????? ?????? ???? ??????? MSX_password ?????? ???? Windows. ?? ??? ??????? ???? ???? SQL Server ???? ??? ??????? ?????? ?????? ????? ?????? ??? ???? MSX. ?? MSX_username nvarchar ?? ???????.

'MSX_password'

???? ?????? ????? SQL Server ?????? ?? MSX_username. ????? ????? ????? ??? ??????? ? MSX_username ?????? ???? Windows. ?? ??? ??????? ??? ??????? ?????? ?????? ???? ???? SQL Server ???? ?????? ?????? ??? ???? MSX. ?? MSX_password nvarchar ?? ???????.

?????? ??? ????? ?????? xp_sqlagent_msx_account ????????. ?? ???? ??????? ???????? ???????.
????? ??? ???

????? ???? 0 ??? ???? ?? 1 ?? ???
????? ???? xp_sqlagent_msx_account ?????? ???? ?? 1, ???? SQL Server ????? ??? ????? ??? ??????? ??? ?????.
??????? ???????

?? ??? ????? ???? SQL Server ???? MSX xp_sqlagent_msx_account ?????? ?????? ?? ????????? ??????? ????? ???? ?????? ????? N'GET '.
?? ??? ??????????? ??? ??????
??????? ???????????
??????sysname. N/A ???????? ????????? ?? ????????.
??? ????????sysname?????? ???????? ??? SQL Server MSX ???? ????.
??? ?? ??? ????? ???? MSX ???? ???? SQL ?? N'SET ' ??? ????? ?? ????? ?????? ???????.

??????

????? ???????? ?????????? xp_sqlagent_msx_account ??? ????? ??? ???? ???? securityadmin.

?????
  • ??????? MSX ???? ???? SQL ??????? ?????? ????

    ???? ?????? ?????? ???????? ???? ??????? ?????? ????????? ????? MSX ???? ???? SQL:

    EXEC master.dbo.xp_sqlagent_msx_account N'GET '
  • ????? ???? MSX ???? ???? SQL ???????? Windows ????????

    ???? ?????? ?????? ?????? MSX ???? SQL Server ?????? ???????? ?????? Windows:
    EXEC master.dbo.xp_sqlagent_msx_account N'SET',
       N'',  -- Reserved for future use 
       N'',  -- MSX_username
       N''  -- MSX_password
    
  • ????? ???? MSX ???? ???? SQL ??? SQL Server ????????

    ???? ??? ??????? ?????? MSX ???? SQL Server ???? ???? ?? ????? ???? ????:
    EXEC master.dbo.xp_sqlagent_msx_account N'SET',
       N'',  -- Reserved for future use 
       N'Ralph',  -- MSX_username
       N'RalphPwd'  -- MSX_password
    
  • ??? ???? MSX ???? ???? SQL

    ?????? ?????? ??? ??? ???? MSX ???? ???? SQL. ???? ???? ??? SQL Server ???? ????????? ?????? ?????? ???????? ?? Windows.


    master.dbo.xp_sqlagent_msx_account EXEC N'DEL '
5.4.4 ??????? ??? ???? ???? SQL
??????? ?? SP3

????? SQL Server ???? ?????? ?? ?? ?????? ???? ???? ???? ??? ????? ?? ??????? ??? ??? ????? ??????? ?? ?? ????. ???? ??? ????? ???:
  • ??? ??? ???? ?????? ????? ?? ????? ?????? sysadmin ???? ??? ???? ? ???? ????? ??? ??? ??????? ???? ??? ??????.
  • ??? ??? ???? ?????? ?????? Windows ? ??????? SQL Server ?????? ?? ??? ??? ??? ???????? ??? ??????? ??? ???? ??? ??? ??????? ?????? ??????? ??? ??????.
  • ??? ??? ???? ?????? ?????? ???? SQL ? ??????? SQL Server ???? ?????? SQL Server ???? ??? ??????? ??? ???? ??? ??? ??????? ?????? ??????? ??? ??????. ??? ?? ??? ????? ???? ??????, ??? ????? ?? ???.
?? ???? ??????? ??? ??????? ???? ?? SQL Server ???? ?????? ???????? ???? SQL Server ???? ????? ?????????? ?????? ?? ?? ???????? ???? ????? ??????? ??? ??????? ?????? ??????? ???? ????? ??? ??????. ???? ??????? ?? ??????? ?????? ???? ?? ???? ??????? ?????? ??? ?? ???? ????? ??? ?????.
5.4.5 ????? ????? MAPI ???? ???? SQL
??????? ?? SP3

???? ????? ????????? ???? SQL ?? ??????? ?? ?? ?? SQL Server 2000 ?? ??????? ??? ????? ?????? ???????? Extended MAPI ?????? ??????? ?????? ??????????. ????? ??????? ????? ?????? ???????? Extended MAPI ??? Microsoft Outlook ?????? ??? ????? MAPI ???????. ?? ??????? 64 ?? ?? SQL Server 2000 ???? ???? SQL ???? ??? ??????? ??????? ????? Simple MAPI ?????? ?????? ?????????? ?????????. ?? ?????? ????? ????? Simple MAPI ?? ????? 32-?? ?? SQL Server 2000.

5.5 ??????? ?????? ????? ???? SQL

????? ??? ?????? ??????? ??? ?????? ??????? ?? 2000 ???? SQL ???? ?? ??????? ?? SP3a.
5.5.1 ??????? Microsoft Data Access Components
??????? ?? SP3a

????? SP3a ??????? Microsoft Data Access Components (MDAC). ??? ????? SP3a ????? MDAC 2.7 Service Pack 1a ?????. ????? MDAC 2.7 SP1a ??? ??????? ???? ?? ????? MDAC ??????? ?????? SQL Server 2000 (MDAC 2.6) ???? ????? ????????? ???????? ??????. ????? MDAC 2.7 SP1a ????? ??? SP3 3 MSXML.

?????? ?? ??? ????? ??? ??????? ?? MDAC ??? ????? ??????? ??? ??????? ?? ????? ????.

????? ?? ????????? ??? ??? ??????? ?? MDAC ???? ??????? ?????? Access ???? Microsoft ??? ??? ?? ??? ?????? ??? microsoft.com. ??? ??? ????? ????????? ??????? ?? ??? ??????? ?? MDAC ?? ????? ????? ??????? ??? 326848. ????? ?????? ??? ??? ??????? ?? ????? ????? ????? ??? ?????? Microsoft.
5.5.2 ??? QLogic ????? ????? ??????
??????? ?? SP3

???? SQL Server ???? ????? ?????? QLogic ??????? ???? ????? ????? ?????? ????? (VIA) (SAN). ?????? ??? SQL Server ??????? ??? QLogic ???? ??? ?? ????? ??????? ?????? ??????? ?????? ??? ????? IP ?? ??? ???? Vihosts ?? ???? Windows ???????? ??? system32\drivers\etc. ??? ?? ??? ????? ?????
The Vihosts file should be formatted as follows:

<VI IP Address of server computer> <SERVER_COMPUTERNAME>

<VI IP Address of client computer> <CLIENT_COMPUTERNAME>

For example:

139.4.130.1  SQLCOMPUTER

139.4.130.2  SQLCLIENT

?????? ?????? IP ????????? ?? ??????? QLogic ???? ?????? ? ????? ????? ????????? ??????. ???? ???? ?? ???? ????? ????????? ??? ?????? ??????? ?? ?? ?????????? IP ???? ??? TCP ?? ???????. ??? Vihosts ??? ?????? ?? ??? ??????? Giganet ????.

????????? ????? ??????? ???? ?????? ??? ????? ????????? ??????? ???????? "?????? ???????? ???? ??????". ??? ?????? ???????? ?? ?????? ?????? ???????. ??? ????? ???? ????? ??????? ??????? ??? ????? ??????? ???? ?? ???? "???? ?????? ????????".

5.6 ??????? ????? ?????? ???????

????? ??? ?????? ??????? "????? SQL Server 2000 ??????? ????????" ???? ?? ??????? ?? SP3a.
5.6.1 ????? ???????? ?????? ??????? ?? Unicode
??????? ?? SP1

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

??? ?? ????? ??? ?????? ??? ?? ?????? ?????????. ??? ????? SP3a ? ????? ????? ?????? ??? ??? ??????? ??? ??? ????? ?? ????? ??? ?????? ???????? ???:
erep_scripts_notenabled

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

??? ??? ???? ?? ?????? ????? ??????? ?????? ????? ??????? ??????? ?????? ?????? ????? ????? ????? ??? ?????? ???.
  • ???? ???? ??????? ?????? ??? HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.
  • ????? ????? ????? ???? ?????? (??? ??? ??? ??? ????? ??????) ? ?? ?? ?????? sub-key ???? ???? ???? ????? ?????? Repository\Engine.
  • ?? ????? ??????? ???? ????? ???? DWORD ????? ???? AllowScripting ?????? ?????? ??? 1. ??? ??? ???? ?? ????? ??????? ?????? ???? ??? ????? ???? ????? ??????? ?????? ??? 0.
??? ??? ??? ?????? ????? ?????? ????????? ?????? ??????? ???? ?????? ??? ?????? ??.
5.6.3 ??? RepositoryUser ???? ?????? ??? ?????? ??? ??????? ?????
??????? ?? SP3

????? SQL Server ?? ????? ???????? msdb ?????? ?? ??????? ????????? ??????? ???? ???? ???? ?????? ????????? ????????? ?? ??? ????? ??????? "????? ?????? ???????". ?? SP3? ??? ????? ??? ???? ???? ???? RepositoryUser ?? ??? ??????? ?????? ?????? ??????? ???????. ??? ?? ????? ??? ????? ??? ??????? ? ????? ? ??? ? ????? ???????? ??? ??? ????????. ??? ?????? ?? ??? ???????? ??? ??? ????????. .

???? ??? ??????? ??? ?????? ??????? ???????? ???????? ??? ??? ?????? ?????? ?? ??????? ?????? ???? ??????? ?? ????????. ??? ????? ?????????? ?????????? ???? ?????? ??????? ?? ???? ??? ????? ??? ??? RepositoryUser.

5.7 ??????? ????? ????? ????????

????? ??? ?????? "????? SQL Server 2000 ???????? ?????" ????????? ???? ?? ??????? ?? SP3a.
5.7.1 ????? DTS ?? ??? ???? ????? ????? ??? ???? 255
??????? ?? SP2

??? ????? ???????? ??? ??? ??? "?????" ?????????/??????? DTS ???? ?????? ???? ??????? ??? 8000 ??? ?? ?? ???? ????? ??? ?????? ??? ???????.
5.7.2 ???? ?????? ????? ?? ????? ????? DTS ??? ???? SQL Server


??????? ?? SP2

???? ???? SQL ??????? ???? ?????? ???? ???? ???? ?? ???? ?? ????. ?? SP3 ?? ??????? ??????? ???? ???? ???? ?? ???? ?????? "??????? ??????". ??? ????? ???? DTS ?? ???? ?? ???? ?????? ???? SQL Server ???? ???????? ???? ???? ???? ??????. ????? ??? ????????? ?? ????????? ????? ???????? ??? ????????? ???? ???? ??? ??? DTS ???????? ???? ??????? ??? ????.
5.7.3 SQL Server ???? ???? ???? ???????
??????? ?? SP2

??? ??? SP2? ??? DTS ??????? ??? ?????? ???? ????? ??? ?????? ?????? "???? ?????? ????? ?? SQL Server ????" ??? ??? ??? ???? ?????? ???? ?? ?????? ??? ?????? Temp ???????? ????? ??? ?? ??? ?????? (?? ?????? ?????? ???? ????? ?? xp_cmdshell) ?? ?????? (?? ?????? ?????? ???? ????) ???? ????. ????? ???? ?????????? ?????? ??? ??? ????? ?????? TEMP ???? ??? ??????? SQL Server ?? SQL ???? ??????? ??? ???? ???? ?? ?????? ??? ??? ??????? ?? ? ?????? ?????? ??? C:\Temp. ?? SP2 ?????????? ??????, ?? ????? DTS ???????? ?????? Temp ?????? ??? ?????? ?????? ???????? ??? ????? ???? ???? ????? ?????? ??? ??? ?????????.
5.7.4 ??? ??? ????? ?????? ??????? ?????? ?? ??? ?????????
??????? ?? SP3

?????? ????????? "?" SP3 "?" ????? ???? ??? ?????? ?????? DTS ?? ????? ?????? ???????. ???? ???? ?? ???? ?????? "????? ?????? ???????" ?? ??????? ???????? ?????? ?? ???? ?????? ??? ????? DTS. ???????? ??? ???? ?? ????? ??? ?????? ??? ??? ???? ????? ???? replicate ?? "?????" ?????????/??????? DTS.

?????? ??? ???? ????? ?? "????? ?????? ???????"
  • ?? "????? ??????? ???? SQL" ? ???? ??? ?????? ?????? ??? ???? ????? ????? ???????? ? ???? ??? ????? ?? ???? ??? ????? ????? ??? ????? "?????? ???????".
????????? ?? ??? ????? ????? ?? ???????? ??????? ????? ??? ???????.

????? ??? ????? ?????? ?????? ????? ?? "???? ?????? ???????" ???? ????? ??? ???????? ?? "????? ?????? ???????" ?? ?????? ????? ?? ??? ??? ???????? ?????? ??? "????? ?????? ???????". ??? ???? "????? ?????? ???????" ??? ????? ?? ??? ???? ??????. ??? ???? ??????? ????? ?? re-save ???? "????? ?????? ???????" ???????? ??? ?????.

5.8 ??????? XML

????? ??????? ?????? ????? XML ? SQLXML ?? SP3a.
5.8.1 ?????? ?? ??? ??????? ?????? XPath
??????? ?? SP3

?????? ?????? ??? ??? SP3 ????? MSXML ???? ?? ??????? ?? SQL Server 2000 (MSXML 2.6) ????? ??? ????? ?? ????? XPath ??????? ?????? ????? ????? ???? ????? ???? ?????? ?????? ???? ?? ???? ?????? ???? (.) ?? ???? ???? XPath. ??? ?????? ??????? ???? ?????? XPath ???? ????? ?? ???? ??? ????? ??????? ??? ????? ???? ????.

??? ????? SP3 ?? ????? ??? ????? ????? ???? ?? MSXML (3.0 SP3) ???? ?? ??????? MDAC. ????? ?? ?????????? ???? ?????? 5.5.1 ????????? ??? Microsoft Data Access Components.

?? ????? ???? ?? MSXML ?? ???? ????? ?????? ???? ???? ???? ?????? ??? ?????? ???????. ??????? XPath ?? SQLXML ??????????? (????????? XPath ????? annotated ?????? ????? ???????? ?? ????? ??????? XSLT ????? ????? ????? SQLXML) ?????? ???? ?????? ??? ????? ??? ??????? ??? SP3 ?? ????

???? ??? ????? ????? ?????? ?? ???????? ?????? ???? ???? ??? ????. ??? ???? ??????? ???? ???? ????? XPath ???? ??? ?????? ???? ????? ???????? ?? ?????? xsl:if ?????? ??? ???? ??? ???? ??????? ? [@ ResourceTypeID = '2'] ? ?????? ???? ?????? ????? ????? ???? ????? ???? ?????? ??????.

??????? ??????? ???? ??? ?? ??? ?????? ??? ? ????? ??? SP3 ?? ???? ????.
xsl:if test=".[@ResourceTypeID='2']">
To prevent a failure, the XPath expression must be amended as follows:

<xsl:if test="@ResourceTypeID='2'">

5.9 ??????? ??????? API ????? ????????? ???????

??? ????? ?????? ?????? ?? SQL Server 2000 ??????? ????? ????????? ??????? API.
5.9.1 ?????? ????? ?????? ?????? ?? ???? ????

??????? ?? SP2

???? API ???? ????? ????????? ??????? ISVs ????? SQL Server 2000 ????????. ????? ????? ??? API ??? ?????? ???? ?????? ????????? ???????. ???? ???? ???? ????? ????? ????????? ?????????? SQL Server 2000? ??? ?? ??? ???? ???? ?? ???????? ??????? ?????? ? snapshot ????? ?????????.

?? SP1 ?????????? ??????? ??? ???? ???? ????? ????? ????? ????????? ???? ?? ????? ?????? ????? ?? ??? ????. SP3 ?? ???? ???? ????? ??? ?? ???? ?????? ????? ???????? ????? ?????? ?????? ?? ???? ???? ?? ???? ????? VDC_PrepareToFreeze.

??????? ???? ????? ????????? ??????? ?? SP3a ????? ??? ????????? ??????? ??? ??? ????? VDC_PrepareTo. ???? ?????? ??? ????? ???? ?? ??? ????? "????? ???? ?????" (Vdi.h) ?? \Devtools\Include ?? ???? ??????? SP3a

????? ????? ??????? ?????? ?? ???? ????? Microsoft ?? ???? "??? Microsoft SQL Server ?????????".

5.10 ??????? ?? ?????

??????? ?? SP3

??? ????? ??????? ?? ????? ?? Microsoft SQL Server ???? ???????. ???? ????? ????? ??????? ?? ???? ????? SQL Server ?? ????? ????? ??????? ?? ??? ??????? ?? ???? ???? ?????? ????? ???? ?? ????? ??????? ?? ???? ?????? "????? ??????" ?? "????? ????? ??????. ???? ????? ???????? ????? ????? ????? SQL Server ???????? ???? ????? ?????? SQL Server ? SQL Server ????. ???? ????? ??????? ?? ????? ????? ????? "????? ????? ?????" ???????? ?????? ?????. ??? ??? ???? ?? ????? ???????? ??? ?? SQL Server ? Analysis Services ??? ????? ???????? ?? SQL Server ????? ????? ????? SQL Server Analysis Services ????? ????? "????? ????? ???????".

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

??? ????? ??????? ??? ????? ??? ??? (HTTPS) ??????? ??? Microsoft ??? ??? ?????? ?? ???? ?????. ????? ?? ???? ???? ????? ??? ????????? ??? ???? "????? ?? ????? ?????? ?????? ??.

????? ????? ????? ??? ????????? ???????
  • ???? ???? SQL ??? ???? ???????.
  • ???? ??????? ??????? ?????????? ??????? ???????.
  • ?????? ?????? ????? ?? ??????, ???? ???? ???????? ?????? ??????? ????? ??.
  • ????? IP ?????? ??? ????????? ????? ??.
  • ??????? ?? ??????? ?? ????? ?? ????? ???? ????? ?? ?????.
Microsoft ?? ???? ?? ??? ?????? ??????? ?????? ?? ?? ??? ????? ????? ?????? ?????????? ?? ?? ??? ??? ?? ????????? ???????. ??? ???? ????? ????? ????? ????? ??? ??????? ???? ??????? ?? ??????? ?? ????? ?? ????? ???? ????? ?? ?????. ??? ????? ?? ??? ???? ??????? ??? ????????? ?????? ????? ?? ???? ? ?? ?????? Microsoft ??? ????????? ???? ?????.

?????? ??? ??? ????? ???????? ??????? ?? ??????? Microsoft ? ???? Microsoft Web site ???.

?? ???? ????? ??????? ?? ??????? ???? ??? ???? ?? ??? ??????? ?? Microsoft ?? ??? ??????? Windows ???? ???? ??? ????? "????? ??????? ?? Microsoft" ??? ??? ?????. ??????? ?? ?????? ?????? ??????:
Source = MSSQLServerOlapServicesDW 
EventID = 1010
data = http://support.microsoft.com/support/misc/kblookup.asp?id=Q123456
&iBucketTable=1&iBucket=39980&Cab=21474432.cab&LCID=1033
&OS=5.1.2600.2.00010100.0.0
?????? ???????? ???? ????? ?????? SQL Server ? SQL Server ???? ????? ??? ????? ???? SQL (????? ??????? "???") ?? "????? ??????? ??? ?????? ????? ???? ???????? ????? ??????? ?? ???????. ?????? ???????? ?????? ????? ????? ??? "????? ??????" ?? "????? ????? ??? ?????? ????? ???? ???????? ????? ????????. ??? ?? ????? ??????? ?? ????? ?? SQL Server (???? ????? ???????? ? SQL Server ????) ?????? ????? ??? ???? ????? ???????? ?? SQL Server Analysis Services ???? ????.

5.11 ??????? ??????? ???????

??????? ?? SP21

????? Microsoft ?? ????? ???? ????????? "????????? ??????????". ?? ??? ????? ??? ??????? ???? ?? ???? ??????. ??? ???? ??? ???????? ?? ???? ??????? ?? ???? ??????? Query ??????????. ????? ?????? ??????? ??? ????? ??????? SP3a ?? \EQHotfix ??????. ????? ?????? ??? ????? "????????? ??????????" ?? ?????? ?????? ????? ????? ??????? ?? Microsoft. ????? ?? "????? ?????" ?????? ??? ??????? 297105.

5.12 DB-????? ? SQL ??????? ?? C

??????? ?? SP1

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

???????

???? ???????: 889551 - ????? ??? ??????: 06/?? ??????/1428 - ??????: 3.8
????? ???
  • Microsoft SQL Server 2000 Desktop Engine (MSDE) SP3a
  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server 2000 Developer Edition SP3a
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Personal Edition SP3a
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbinfo KB889551 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????889551

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

 

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