??? ????? ?????? 1 ? SQL Server 2000: 30 ????/???? 2001

?????? ????????? ?????? ?????????
???? ???????: 889553
??? ????? ??? ??????? ??????? ??? ????? ????? ???????. ??? ????? ?????? ???? ?? ???????? ??? ??????? ?? ???? ?????? ???????? ?? ???? ???? ?????. ?????? ??? ??????? ??? ????? ????? ????? ????????? ???????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
256986 ??? ??? Microsoft Windows
????? ???? | ?? ????

?? ??? ??????

??????

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

?????????

????? ???

??? ????? ??? ??????? ?? Microsoft SQL Server 2000 Service Pack 1 (SP1) ?? ????? ?????:
  • SP1 ?????? ????? ???????? ???? ??????? ?????????????????? ???? SQL Server 2000? ???????? ????? SQLServer 2000 Desktop Engine. ????? ???? ?????? SP1 ?????? ????? ???????? ???????? ??? thefollowing:
    • ???? ????????
    • ????? ?????? ???? ??????? ???????? ????????? ??? ????? ??????? SQL Server ? osql
    • ?????? ????? ?????? ????? ????????? ??? ???? Microsoft OLE DB ? SQL Server 2000 ??????? ????? SQL Server 2000 ODBC ?????? Net ??????
  • SP1 ????? ??????? ???? ??????? ??????? ????? ????? SQL Server2000 ?????? SQL Server 2000? ???????????? ???????:
    • ????? ???????
    • ?????? ???? ????? ???????? ??? ????? ????? ????? Microsoft OLE DB "?????? ???????"
    • ?????? ????? ?????? ????? ????????? ??? ???? Microsoft OLE DB ? SQL Server 2000 ??????? ????? SQL Server 2000 ODBC ?????? Net ??????
  • ???? ???? ?????? SP1 ???? ??? ?????? ????????? ?????????????????? ???? SQL Server 2000 Desktop Engine. ?????????????? ?? ???:
    • ???? ????????
    • ?????? ????? ?????? ????? ????????? ??? ???? Microsoft OLE DB ? SQL Server 2000 ??????? ????? SQL Server 2000 ODBC ?????? Net ??????
???? ????? ??? ??????? ??????? ?? SQL Server 2000 SP1 ??? ??? ?????? ???????:
  • ?????? ???? ?????? SP1 ?????? ????? ???????? ?????? ?????????????????? ????? ?? ??? ????? ?????? "????? ???????" ?? ?????? SQL Server 2000 Desktop Engine.
  • ?????? SP1 ????? ??????? ?????? "?????????????????? ???????" ????? ?? ??? ????? ????? Desktop Engine ?? ?? ??????????????????.
  • ??????? ??? ?????? SP1 ???? ?????? ?????? ????????????? ??? ????? "????? ???????" ?? ?????? ???? ?????? ??????? Server 2000. ????? ?? ????????? ??? ????? Desktop Engine ???? "????? SP1 ??????? Desktop Engine"?????? ?????? ?? ??? ???????.
??? ???? ?????? ?? ?? ?????? ????? ???????? ??????? "????? ???????"? ??? ????? SP1 ?????? ????? ???????? "?" SP1 ????? ???????.

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

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

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

????? SQL Server 2000 SP1

??? ????? ???? ??????? ????? ????? ?????? ???????. ????? ??? ?????????, SQL Server 2000 SP1 ?? ???? ??????? ??????. ?????? ??? ?????? ???? ???? ??? ??????? ??? ????? SP1? ??? ????? ?????? ????? SQL Server 2000. ??? ????? SQL Server 2000? ??? ????? ???????? ?????? ??. ????? ????? ??? ??? ????? ????? SQL Server 2000. ????? ?? ????????? ??? ??????? sp_attach_db ? sp_detach_db? ???? "??? SQL Server ??? ??????".

??? ????? SQL Server 2000? ??? ????? ?? ???:
  • ????? ????? ?????? ????? ?????? ????????.
  • ????? ????? ?????? ???????? ????? ??? ??????? ?? ????? ?????? ??????.
  • ??? ????????? ???? ??? ??? ?? ????? ????????.
  • ????? ????? ???????? ??? ??????? ????? ????????.
?????? ??? ??????? ?????? ??? ????????? SQL Server 2000 SP1 ?????? ??? ??????? ?????? ??? ????????? ??????? ?? ???? ?????? ???? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
290212 ????? ??????? ???? ?? ??????? ?? ???? ?????? service Pack 1 (1 2) SQL Server 2000
?? ????? ??????? ?? ??? ??????? ??? ?????? ??? ????? ????? ??????? ??? ??????? ????? ???????.

??????? QFE

??? ????? ????? QFE ??? 1 ????/???? 2001? ?? ??? ????? ??????? ?? SQL Server 2000 SP1. ???? ????? ????? ??????? ??? ????????? QFE ? SQL Server 2000 SP1.

????? ????? SQL Server ??????

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

????? ??????? ?????? ?? "????? ???????"

?????? ????? ????? ??????? ???? ??? ????????? ???? ??????? ???????:
  1. ???? ??? ???????? ??? ???? ??? ??? SQL Server 2000? ??? ???????? ?????????? ???? ??? ???????????????.
  2. ?? ???? ????? ?????? ?? ?????? ?????? ??? ??????????????? ??? ?? ???? ??? ??? ????? ???????.
???? ?????? ?????? ????? "????? ???????" ???? ????.
?? ??? ??????????? ??? ??????
??????? ???????? ??????? ????????? Analysis Services
8.0.194????? ????? ????? SQL Server 2000
8.0.382SP1 ????? ???????

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

??? ????? SQL Server 2000 SP1 ?? ?????:
  • ??? ??? ?????
  • ?? ????? ????????? ?????? ??????? ??????? ???? ???? ???????????? ?? ????????:
    • SQL2KSP1.exe: SP1 ?????? ????? ????????
    • SQL2KASP1.exe: SP1 ????? ???????
    • SQL2KDeskSP1.exe: ???? ?????? SP1 ??????? Desktop Engine
??? ??????? ????? ??????? ???? ?????? ?????? ?? ??????? ???????? ???????? ??? ???? ????????? ????? ??. ??? ??????? ???????? ?? ??? ?????? ??????? ???????? ???????? ??? ????? ??????? ? SP1 2000 ? SQL Server. ??? ??? ?????? ???? ??????? SQL Server 2000 SP1? ??? ??????? ??????? ????? ??????? ???? ???? ??? ????? ?????? ???????.

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

?????? ??? ??????? ???????? ?? ??? ?????? ????? ??????. ?????? ????? ????? ??? ??? ???? ???? ???????? ????? ???? ??????? ???????. ?????? ???? ???????? ????? ???? ??????? ? ?? ??? ???:
  1. ?? Microsoft Windows Explorer? ?? ??????? ???? ???? ??? ??????.
  2. ???? ??? ????? ??????? ??? ? ??? ?? ???? ??? ???? ???????? ????? ???? ??????? ????????.
?????? ??? ??????? ???????? ????? ?? ??? ?????? ??? ??? ??????? ???? ??? ???? ??? ???? ????????? ???? ???? ?????? ???? SQL Server 2000 ??? ???? ?????? ???? ?????? ???. ?? ??? ??????? ?? ?????? ?????. ?????? ?????? ????????? ?? ??? ?????? ??? ???? ??? ????? ???? ???????.

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

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

????? SQL Server 2000 SP1

?????? SQL Server 2000 SP1? ?? ???? ????????? ???????? ???????? ??? ???????? ???? ???? ????????:
  • ?????? ???? ?????? SP1 ?????? ????? ???????? "?" ??????????????? ???? ?????? SP1? ???? ??????? ??????? ?? ????????????? ??????? ?? ??? ???????:
    • "???????? ????? ?????? SQL Server"
    • "???????? ????? ???????? ????? ???????"
    • "?????? ?? ???? ????? ??? ????? ??? ????? ?????? ??????"
    • "????? ??????? ?????????? ??? ????? ?????? ????? ???? ?????? SP1 ?????? ? SQL Server 2000"
    • "????? SP1 ?????? ????? ????????"
    • "????? SP1 ????? ???????"
    • "????? ????? ?????"
    • "????? ????? ?????????"
  • ?????? SP1 ?????? ????? ???????? ??? ???? ??????? ????????? ??? ?????? ??????? ??????? ???? ??????? ???? ???????????? ?? ??????? ??????? ?????? ?? ??? ???????:
    • "???????? ????? ?????? SQL Server"
    • "?????? ?? ???? ????? ??? ????? ??? ????? ?????? ??????"
    • "????? ??????? ?????????? ??? ????? ?????? ????? ???? ?????? SP1 ?????? ? SQL Server 2000"
    • "????? SP1 ?????? ????? ????????"
    • "????? SP1 ????? ???????"
    • "????? ????? ?????"
    • "????? ????? ?????????"
  • ?????? SP1 ?????? ????? ???????? ??? ???? ??????? ????????? ???? ???? ??? ?? ????? ?????? ?????? ??????? ??????? ???? ???????????? ?? ??????? ??????? ?????? ?? ??? ???????:
    • "????? SP1 ?????? ????? ????????"
    • "????? ????? ?????"
    • "????? ????? ?????????"
  • ?????? SP1 ????? ???????? ???? ???? ??????? ??????? ?? ??????? ??????? ?????? ?? ??? ???????:
    • "???????? ????? ???????? ????? ???????"
    • "????? ??????? ?????????? ??? ????? ?????? ????? ???? ?????? SP1 ?????? ? SQL Server 2000"
    • "????? SP1 ????? ???????"
    • "????? ????? ?????"
    • "????? ????? ?????????"
    ?????? ??????? ??????? ?????? ????????? ???? ???? ????????? ????? ?????? ?????? ??? ?????? ??????? ???? "????? ???????" ????????? ??????? ??????.
  • ?????? SP1 ???? ??? ?????? ??? ??? ??????? ????????? ??? "?????? ??? ??????"? ???? ??????? ??????? ?? ??????? thefollowing ?????? ?? ??? ???????:
    • "????? ??????? ?????????? ??? ????? ?????? ????? ???? ?????? SP1 ?????? ? SQL Server 2000"
    • "????? SP1 ??????? Desktop Engine"
  • ?????? ???? ??????? ??? ???? ???? ??? ???? ??????? ??????? ?? ????? "????? SQL Server 2000 SP1 ??? ?????????????" ?????? ?? ??? ???????.
?????? ?? ????? ??????? ?????? ????? ???? SQL ??? ????? SQL Server 2000 SP1.

???? ??? ????? SQL Server 2000 SP1? ????? ????????? ???????? ????? ????? ??????? ????? ??? ???? ???????? ???? ???? ?????? ????? SQL Server ???? ????? ?????? ??? ????? ????????. ??? ?????? ??????? ?? ???? ??? ?????? ????. ??? ????? ??? ????? ?? ????? Sqlsp.log ? SQL Server ?? ?? ????? Olapsp.log "????? ?????". ????? ??? ???? ????? ???????? ??? ???? ???????? ??? ???? ????? ????? ??? ????? ???? ???????.

????? ???? ??????? "???? ????? ???????" ?????? SQL Server 2000 SP1 ???????? ??? ?????? ?? ????? ????????? ???? ???? ??? Windows NT Server 4.0 ???????? ??? ????? ???? (??? Smssql2ksp1.pdf). ??? ????? ?????? ???????? ?????? ???? SQL Server ?? "???? ????? ???????". ?? ???? ????? ???? SQL Server ???????? ??? ????? ????????? ???? ???? ??? "???? ????? ???????". ????? Sms2kdef.bat ?? ??? ???? ???? ?? ???? ??????? ????????? ???? ????? ??????? ??????? ?? ?????? "???????".

?????? ??? ????? SQL Server 2000 SP1 ??? ????? ????? ???????? ?? Windows NT 4.0? ???????? ????? ????????? ???????? ?? ??????? ??????? ?? "????? ??????? ? Microsoft":
259484 ??? ??? ??????? CryptEncrypt ????????????? ?????? ???????? ?? Windows 2000

??? ???? ???????? ?? ????? ?????? SQL Server

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

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

????? ??? ??????? ????? ???????? "????? ???????"

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

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

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

??? ?? ????? ?????? ????? ???????? ?????? ???????? ???????? ?????? msdb ?? ?????? ?? SQL Server 2000 ?? Desktop Engine ??? ????? SQL Server 2000 SP1? ????? ???? ??? ??????.

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

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

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

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

?????? "?????? ???????" ??? ????? ????? ?????????? ????? ??????? ?????????? ??????? ??? ????? ???? ??????:
  • ????? Microsoft ???? ????????? (MS DTC) ???? Microsoft? MSSQLServer ? MSSQLServerOLAPService ???????????????????????.

    ?????? ??? ???? ????? ??? ??????? ??? ???? ????. ???????????? MSSQL ????????????? $.
  • ????? ???????? Microsoft ?? ????? ?????? ??????? ? Microsoft ?????? ?????? Microsoft COM.
  • ???? ?????????? ??? ?? ??? ?? "???? ??????". ??? ????????????? ??????? ???? ??? ?????.
?? ???? ????? ??????? ?? ???? ????? ??? ???. ????? ?? ?????????? ???? ????? "??????? ??? ???? ????" ?????? ?? ??? ???????.

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

????? ???????? ????? Setup.bat ?? ??? ??????? ???????:
  • ?????? ???? ????? ??? ???????? ???? ????????? ?? Sql2ksp1.exe
  • ???? ???? ?????? ??? SP1CD 2000 ???? SQL
??? ??? ???? ?????? ????? Setup.bat. ?????? ???? ?????? ?????? ??? ??????? ??? ?? ??? ??? ???? ??????? ?????? Windows ?? ?????? SQL Server. ??? ????? ?????? SQL Server? ??? ????? ?????? "???????" ???????? ???? ?????? ????? ????? ?????? sa. ??? ????? ?????? Windows? ??? ?? ??? ????? ?????? ??? Windows ???????? ???? ????? ???? Windows ??? ????? ?????? ???????. ??? ?? ???? ???? ????? ?????? ??? ??? ?? ????? ?????? ??? ?????? ????? SQL Server 2000 ?? Desktop Engine ??????? ?????.

?? ???? ?????? ??????? ??? ???:
  • ??????? ??????? SQL Server 2000 ?? ??????????? ??? ?????? ?? ????? SP1.
  • ??? ????? ??? ????? ???????? ????? SQL ???????? ?????? ????????? ????????????.
  • ???? ?????? ???? ??? ???????? ??? ?? ??????? ?????? "?????? ????? ???????" ???????? ???? ???? ?????? ????? ????? ?????? sa. ??? sa ?????????? ????????????? ???? ???? ????? ?????? ?? ????? ?????? ??????? ??? ???? SQL ?? Engine.You ??? ?????? ????? ??? ????? ??????? ?? ???? ??? ???? ???? sa ?? ????????????? ????????.
??? ???? ?????? ??? ?????? ????????? ??????? ???????. ???? ??? ??????? ???? ??????:
  • ??? ????? ????????? ???? ???? ??? Windows 98 ? Windows ?????????????? ??? ????? ???? ?????? ??? ???????? ??? "?????? ??????????" ?????? ????? ???? ???? ??????????? sa. ?????? ????? ??????? ?? ??? ???????? ??? ?? ?????????? ??? ????? ??????? ???. ??? ??? ?????? ???? ????? ??????????? ????? ???? ???? ????? ?????? sa. ??? ???? ???? ?????? ?????? ??????? ?????? ??????? ???? ????? ???? ??????.
  • ??? ????? ????????? ???? ???? ??? Windows NT 4.0 ?? Windows 2000? ??? ????? ?????? ??????? ??????? Windows. ?????? ???? ?????? ??????? ????????? ????? ??????? ?? ??? ???????? ????? ???? ????? ???? sa ??? ????????.
??? ????? ??? ?????? ?? ???? ?????? ????? ????? ?????? sa? ???? ?? ?? ??? ??????? ?? ???? ??? ????????? ????????. ??? ???? ??????? ??? ??? ?????? ?? "?????? ????? ???????" ??????? Windows? ?? ???? ??????? ????????? ???????? ???? ????? ??????? ???????? ?????? ???? SQL ??? ??? ????? ??? ???????? ??? ??????? ?????? Windows. ????? ??? ??? ?????? ???? ???? ????? ?????? sa? ????????? ?? ???????? ???????? ???? ?????? ???? ?????? ??????? ?? ???? ??????? ??? ?? ????? ???????? ???? ?????? ???????.

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

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

?????? SP1 ????? ???????? ????? Setup.exe ?? ??? ??????? ???????:
  • Msolap\Install ???? ???? ?? ???? ??? ?????????? SP1 ????? ??????? ????????? ?? SQL2KASP1.exe
  • ???? Msolap\Install ??? ????? ??????? ? SP1.
??? ??? ???? ?????? ????? Setup.exe. ??? ??????? ????????? ??? ?? ????? ?????? ??????? ???????.

????? ???? ?????? SP1 ??????? Desktop Engine

?????? ????? ????? ? Desktop Engine? ????? Setup.exe ?? ??? ??????? ???????:
  • ?????? ?????? MSDE ?? ?????? ???? ????? ??? ????? ???? ??????? ??????????? ?? Sql2kdesksp1.exe
  • ?????? ?????? ?? SP1CD 2000 ???? SQL MSDE
??? ?? ??? ????? ??? ??????? ??? ???? ? Desktop Engine ???????. ??? ????? ?? ??? ?? ???? ??? ???.msp ????????? ?????? ???? ?????? ???. ??? ??? ???? ???? ??????? ???? ?? ???????? ?????? "???? ??? ??????"? ??? ??? ????? ?? ???? ??????? ???????? ?????? &/p . ??? ??? ?? ???? ???? ??????? ???? ?? ????????? ???? SQLRUN ??? ?????? /p . ???????? ?????? ???????? SQLRUN? ????? ?????? ????? ??? ??????? ??? ????? ?????? ???????:
  • ???? ?????.msp ???????? ?? ???? ??? ??????????. ??? ?????? ??? ?????? ??? ?????? ???? ????? ??? Setup.exe.
  • ????? ??? ?????? ????? Desktop Engine ?????????????? ?? ???? ??????? ??? ?? ??? ?????? ?????????.
???? ?????? ?????? ?????? ??????? ?????? ????? ??? ???? ???? ???? ??????????:
Setup.exe /p SQLRUN INSTANCENAME=MyInstance
?????? ?? ?????? ??? ?????? ?????? ???????? ??? ??? ??????.

???? ???? ????? ??? ?????? ?? ??? Setup.ini ?? ??? ??? ?????????. ????? ?? ?????????? ???? "????? SQL Server 2000 ??? ?????? ????" ?? "??? SQL Server ??? ??????".

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

????? ???????? ??????? ?? "???? ??? ??????" ??? ????? SQL Server 2000 SP1

???? ??? ??????? ?????? ???? ????? ?? "???? ??? ??????" ??? ????? SQL Server 2000 SP1.
  1. ????? ???? ??? ????? ?? ??????? ??????? ??? ???? ??? ?????.rdl ?? ?????? SQLServer\80\Tools\Binn\Resources\1033 \Program Files\Microsoft:
    • semnt.rll
    • sqlsvc.rll
  2. ????? ???? ??? ????? ?? ??????? ??????? ???????? ???? ??? ?????.dld ?? ?????? SQLServer\80\Tools\Binn \Program Files\Microsoft:
    • Semnt.dll
    • Sqlsvc.dll
    • Sqlresld.dll
  3. ?? ?????? ??????? Desktop Engine ??? ???? ?????? SP1.
  4. ????? ?????? ????? ??????? ????? andSqlsvc.rdl Semnt.rdl ?? ?????? SQLServer\80\Tools\Binn\Resources\1033 \Program Files\Microsoft.rll.
  5. ????? ???? ??? ????? ?? Semnt.dld,Sqlsvc.dld? Sqlresld.dld ??????? ?? ?????? SQLServer\80\Tools\Binn \Program Files\Microsoft ???.dll.
???? ???? Desktop Engine ?????? ????? ?? ???? ?????? SP1.

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

??? ?????? "?????? ???????"? ?? ???? ??? ????? ????? ??????. ??? ????? ????? ?????? ?? ??? ?????? "?????? ???????" ??? ??? ????? ????? ??????? ????? ??????? ?? "???? ??????" ?????? ?? ????? ????? MS DTC ???? Microsoft? MSSQLServer ? MSSQLServerOLAPService ? SQLServerAgent. ????? ??? ??????? ????? ????? ???????? ???????? ?????? msdb ?????? ????? ??? ?????.

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

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

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

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

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

????? ???? ?????? ??? ????? ????????? SQL Server 2000 ?? ???????? ????? ???????? ????? ????????? ????? ?????? ??????? ??????????. ??? SQL Server 2000 SP1 ??? ?????? ?????? ???????? ??????:
  • ????? ??? ??? ??????? ?? ??????
  • ??????
  • ??? ?????????
?????? ?? ???? ???????? ?????? ??????? ??? ??? ??????. ???? ????? ???? ??? ?? ??? ????? ????????. ??? ????? ?????? ??????? ?? ??? ?????.

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

?? ?? ???? ?????? ??? ????? ???? ???????? ???????? ?? ???????? ????? ?????? ????. ??? ???? ?????? ????? ???????? ????? ????? ??? ??????? ???? ??? ????? ?????? SQL Server 2000 ????? ??????? ???. "?-MaxCmdsInTran ??????? ??????? ????? ???? ???" ???? ??????????? ???? ?????? ?????? ?? ??? ???????.

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

?????? ??? ??????? ??? ???? ?????? SP1 ?? SQL Server ?? ????? ???????? ??? ????? ?? ???:
  • ?? ?????? ???? ?????? SP1 ? SQL Server 2000.
  • ????? SQL Server 2000.
  • ??????? ????? ???????? ???????? ?????? msdb ?????? ?????? ???????.
???? ??? ??????? ?????? ??? ??????? ??? ???? ?????? SP1 ?? SQL Server ?? ????? ???????:
  1. ?? ????? ??? ??????? ????? ????? ???????? ????????.
  2. ?? "???? ??????"? ???? ????? ??????? ??? ?????/??????????????? ???? ??? ???? SQL Server ???? ???? ??????? ??? ?? ???? ??? ?????.
  3. ????? SQL Server 2000 ?? ????? ??????? ?? ????? ?????? ?? ????? SQL Server ??.
  4. ??????? ????? ???????? ???????? ?????? msdb ?? thelast ???? ???????? ?? ??????? ??? ????? SQL Server 2000 SP1.
  5. ?? ???????? ????? ?????? ????????.

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

???? ????? SP1 ?????? ????? ???????? ??? ???? SQL Server 2000 ???? ???? ??? ??????? ?? ????? ??? ???????. ????? ??????? ? SP1 ?????? ????? ???????? ????? ??? ?????.iss ???? ???? ????????? ?????? ??????? ??? ????? ?? ???? ?????? SP1. ???? ??? ??????? ?? ?????? ????? ??? ????? ???????. ???? ??????? ??????? ?????? ????? ?????? ?? ?????? ???????? ??? ???:
  • ??????? Sql2kdef.iss ?????? ???? ?????? SP1 ?????? ????? ???????? ??? ???? SQL Server 2000 ???? ???? ??? Windows 2000 ?? ???? ??????? NT 4.0 theWindows ????????. ????? ?????? ???????? ???????? isSql2kdef.bat.
  • ?????? Sql2knm.iss ?????? ???? ?????? SP1 ?????? ????? ???????? ????????????? ?? SQL Server 2000 ???? ???? ??? Windows 2000 ?? ???? ??????? WindowsNT 4.0. ??? ????? ??? ?????? ?? toidentify ???.iss ?????? ???? ??? ?????.
  • ??????? Sql2ktls.iss ?????? SP1 ?????? ????? ???????? ??? ????? atools ???. ???? ??????? ??? ????? ??????? ???? ??????????????.
  • ??????? Sql2k9x.iss ?????? ???? ?????? SP1 ?????? ????? ???????? ??? ????????? ???? ???? ?????? ???? 98operating Windows ?? Windows Millennium Edition. ??? ????? ?????? ??? ????? ????? ?????? ????????????.
  • ??????? Sql2kcli.iss ?????? SP1 ?????? ????? ???????? ??? ????? ?????? ?????? ??? ???? ??????? ???? ???? Windows 95operating.

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

????? ???? ?????? ??? ??? ??? ??????? ???? ???? Sqlredis.exe ?????? Redist.txt. ???? ??? ??????? ?? ???? ?????? SP1 ?????? ????? ????????. ???? ???????? ??? ????? Sqlredis.exe? ???? ???? ????????? ???????:
  • ???? Mdac_typ.exe ?? ?????? Microsoft Access Components(MDAC) 2.61. ??? ????? ???????? ???????? MDAC 2.61. ??? ???? ???? ?????????? ?? SQL Server Desktop Engine? ????? ????? ???????? ???? ??????? ?? ???? ?????? ???.
  • ????? ????? ????? Microsoft Jet ODBC ??????????????????????.
???? ????? ????? ????? Sqlredis.exe ??? ??? ?????? ??????? ???? ??? ??????? ?? ????? Redist.txt ??????? ?? ???? ?????? ???.

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

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

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

?? ???? ????? ???? ?????? SP1 ?????? ????? ???????? ??? ???? ???? ?????? ????? ??????? Windows NT 4.0 ?? ???? ??????? Windows 98 ???????? ??? ???? ??????? Windows 2000? ?????? ????? Windows 2000 ??? ????? ??????. ????? ?????? ??? ?????? ?? ??? ??? ?????? ??????? ?? ????????? ?? ???????. ??? ??????? ?????? ??????? ?? ????????? ?? ??????? ?? ????? ?????? SQL Server ????? ??? ??? ????? ????? Sqlredis.exe ???? ???? ?? SQL Server 2000 SP1 ??? ?????? ??????? ??? Windows 2000. ????? ?? ????????? ??? ????? Sqlredis.exe? "????? ????? ?????? ?????? SP1 ?????? ????? ????????" ??????.

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

?????? ?????? ??????? ????? ?????? ??????? ?? Unicode

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

?????? ?????? ??????? ???? ????? ?????? ??????? ????? ??? XML ?? Unicode. ??? SQL Server 2000 SP1? ????? ???????? ????????? ???????? ANSI. ??? ???? ?? ????? ??? ANSI ???? ??? ????????. ???? ??? ??????? ???? ?????? ????????. ??????? ?? ??? ??????? SQL Server 2000 SP1? ?????? ??? ??????? ?? ???????? ???? ?? ??????? ? Unicode.

?? ???? ????? ????? ?? ????????? ???????? ANSI ?????? ???? ????? ??????? ?????? ?????? ??? ???:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Repository\Engine\XMLExport
???? ??? ??? ????? ???? ????? ??????? ???? ??????? ?????? ???????:
  • ?????? = 1
  • ???? = 2
  • ??????? ??????? = 4
  • UNICODE = 8
  • ?????????????? = 16
  • ??????????? = 32
????? ?? ????????? ??? ?? ?????? ???? "????? IExport::Export" ?? "??? SQL Server ??? ??????".

????? ??????

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

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

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

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

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

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

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

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

?? ???? ??????? ???? ????? ????? ????? ???????? ???????? ???? ??? ????????? ?????? ?????? ??????? ?????? ?????/????? ?????. ??? ??????? ??? ??????? ??? ?? ???? ???? ????? . ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
298402 ?????? ??? ????? ????? ???? ??????? ???????/??????? ? SQL Server
????? ????? ???? ???????

?? ???? ??????? ???? ????? ????? ??????? ???? ?? ??????? ?????? ????? ?????? (VIA) ???? ????????? SQL Server ?? ?????? ?????? ????? ??? ????? ?? ?????? ?? ?????????. ???? ??????? ??? ??????? ??? ?? ???? ???? ????? . ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
299641 ?????? ??? ????? ????? SQL Server ???? ????? ???????

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

??????? "????? ???????" ??????? ??????? ?? SQL Server 2000 SP1:
  • ?????????? Analysis Services ??????? ?????? ??????? ???????
  • ??? ????? ??? ????????????????? ??? ?????? ??????
  • ???? ????? ????? ??????? ??? ????? ????????? ??? ??????? ?????? ???????????

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


????? ???? ?????? SP1 ????? ??????? ????????? ??????? ?? ????? ?????? ??????? ?????? ??????? ??????? ???????:
  • PTSLite.exe
  • PTSFull.exe
??????? ??? ??????? ??????? ??????? ?? ????????? ???? ?? ?? ?????? ????? ?????? ???? ?? ??????? ??? ??????? ????? ??????? ? Microsoft Office XP.

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


????? ???? ?????? SP1 ????? ??????? ???? ??? ?????? ????? ???????? ??????? ?????? ??????. ????? ?? ????????? ??? ????? ???? ???????? ??? ??????? ???? OLE DB "?????? ????? ??????? ?? ????????". ????? ??? ???????? ????????? ???????? ????? ???????? ??? ?????? ?????. ????? ?? ????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://www.Microsoft.com/data
????? ????? ??????? ??? ??????? ?? ??????? ??????? ??????


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

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

??????? ????? ???????? ??????? ??????? ?? SQL Server 2000 SP1:
  • ????? ???????? ????????? ?? ??????? ????? ????? ???????
  • ??????? ????? ???????? ????????? ?? ??????????????
  • ???? ?? ???????? ????????? ??????
  • ????? ???????? ????????? ?? ??????? ????????????????
  • ??? ????? ?????? ??????? ??? ???????? ?????? ????????
  • ??????? ????? ???????? ???????? ????? ???????? ?? ????? ?????????? SQL Server
  • ????? ????? -MaxCmdsInTran "???? ???? ???"

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


????? ????? ???????? ????????? ???????? ??? ????? ????????? ??????? ??????? ?????? ???? ?????? ????????? ?? ????? ?????? ????????. ??? ????? ?? ??? ??????? ????? ?????? UPDATE ? ????? ??????? ????????? ????? ???? ??????? ?? ?????? ????????. ??? ??????? ?????? ?? ???? ?? ????? ??? ????. ???? ???? ???? ??? ??????? ??? ?????. ??? ???? ??? ??? ????? ?? ?? ??? ???????? ????? ????? ??????? ???? ?? ???? ?????.

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

????? ???? ?????? ??? ????? ???? ????? sp_scriptdynamicupdproc. ???? ??? ??????? ?????? ????? ???? ????? ????? ??????? ??????? ?????? ????? update ?? ??? ??????? ???? ????. ??? ???? ?????? ?????? ?????? ?? ??? ??????? ????? ??????? ?????? ????.
sp_scriptdynamicupdproc

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

???? ??????

sp_scriptdynamicupdproc [ @artid = [ artid

???????

[@artid =] artid ?? ???? ??????? artid ?? ??? ????? ??? ???? ????????.

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

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

???????

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

??????

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

?????

??? ?????? ???? ???? (?? artid ??????? ??? 1) ??? ?????? ?????? ?? ????? ?????? pubs. ???? ?????? ??? ????? ???? ?????? ????? UPDATE :
'MCALL sp_mupd_authors'
????? ????????? ??????? ??????? ??????? ?????? "???? ???????" ??????? ?? ???? ????? ??????? ?????? ?????? ??? ??????:
EXEC sp_scriptdynamicupdproc @artid = '1'
The statement returns:

create procedure [sp_mupd_authors] 
  @c1 varchar(11),@c2 varchar(40),@c3 varchar(20),@c4 char(12),@c5 varchar(40),@c6 varchar(20),
  @c7 char(2),@c8 char(5),@c9 bit,@pkc1 varchar(11),@bitmap binary(2)
as

declare @stmt nvarchar(4000), @spacer nvarchar(1)
select @spacer =N''
select @stmt = N'update [authors] set '

if substring(@bitmap,1,1) & 2 = 2
begin
  select @stmt = @stmt + @spacer + N'[au_lname]' + N'=@2'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 4 = 4
begin
  select @stmt = @stmt + @spacer + N'[au_fname]' + N'=@3'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 8 = 8
begin
  select @stmt = @stmt + @spacer + N'[phone]' + N'=@4'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 16 = 16
begin
  select @stmt = @stmt + @spacer + N'[address]' + N'=@5'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 32 = 32
begin
  select @stmt = @stmt + @spacer + N'[city]' + N'=@6'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 64 = 64
begin
  select @stmt = @stmt + @spacer + N'[state]' + N'=@7'
  select @spacer = N','
end
if substring(@bitmap,1,1) & 128 = 128
begin
  select @stmt = @stmt + @spacer + N'[zip]' + N'=@8'
  select @spacer = N','
end
if substring(@bitmap,2,1) & 1 = 1
begin
  select @stmt = @stmt + @spacer + N'[contract]' + N'=@9'
  select @spacer = N','
end
select @stmt = @stmt + N' where [au_id] = @1'
exec sp_executesql @stmt, N' @1 varchar(11),@2 varchar(40),@3 varchar(20),@4 char(12),@5 varchar(40),
                             @6 varchar(20),@7 char(2),@8 char(5),@9 bit',@pkc1,@c2,@c3,@c4,@c5,@c6,@c7,@c8,@c9

if @@rowcount = 0
   if @@microsoftversion>0x07320000
      exec sp_MSreplraiserror 20598

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


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

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

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

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

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


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

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


??? ????? ?????????? nosync? ??? ????? ?????? ??????????????? ??????? ????? ??????. ????? ?????????? nosync ?????????? ?? ????? ?????? ??????. ???? ???? ??? ????? ??? ???????? ??? ??????? ??? ????? ???? ??????. ??? ????? ????? ???? ????? sp_scriptpublicationcustomprocs? ????? ??????? ?????? ??????? ????????? ??????? ??? ????? ???????. ??? ??????? ??????? ?? ???? ????? ?????????? nosync.

sp_scriptpublicationcustomprocs

??????? ?????? ??????? ??????? ????? ?????? ???? ????? ?????? ???????? ?? ????? ????? ????? ?????? ?????? ?????? ?????? ??????? ??????. ??????? sp_scriptpublicationcustomprocs ????? ???? ???? ??? ?????? ?????????? ???? ????? ?????? ??????? ??????.

???? ??????

sp_scriptpublicationcustomprocs [@publication] = publication_name

???????

[@publication] = publication_name
?? ??? ???????. publication_name ?? sysname ??? ???? ????????.

Return Code Values


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

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

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

???????

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

??????

????? ??? ????? ???????. ??? ????? ????? ???? ??????? ???? ??? ??????? ?????? ?????? ?????? ??? ????? ????? ?????? ??? ?????? ????? ? db_owner ????? ??? ????? ???????? ?? ????? ???????? ???????.

??????

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

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

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

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

????? ?????? ??????? ??? ??????? ???? ??? ???:
  • ??? ?? ????? ????? "???? ???" ?MetadataRetentionCleanup ??? 1? ????? "???? ???" ???????????? ??????? ???? ??? ??????? ?? ?????. ???? ???????? ??? ????? ????? "???? ???" ?MetadataRetentionCleanup ??? 1.
?????? ??????? MetadataRetentionCleanup 1 ?? ??? ?? ????? ????? "???? ???" ???????? ?? ???? ?????? ???.
  • ??? ?? ????? ????? MetadataRetentionCleanup ??? 0? ?? ??? ????? ??????? ????????. Inthis ?????? ??????? ?????? ????? ?????? ??????? ???????? ??? ??????? ?????? ?? ???? ????? sp_mergemetadataretentioncleanup . ??? ??????? ?? ???? ???? ??? ????? ???????????? ??????? ?? ???? ?????? ???. ??? ????? ??? ????? ??????? ?????? ?????? ????????.
???? ???????? ?????????? ????????? 14 ????. ??? ??? ???? ???? ?? ??????? ?????? ?? ??????? ?? ???? ????? ????????? ??????. ?? ??? ??????? ??? ??????? ???? ???? ????????? ?????? ?? ???? ?? ???? ???? ??? ???? ?????.

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

????? ?????? ??????? ???????? ??? ??? nonconvergence ??????? ???????? ??? ????????? ?? ????? ??????. ??? ???? ???? ?? ???? ????????? false ??? ???? ??????? ??????:
  • ??? ????? ?????? ??????? ??? ???? ????? ???? ??? ?????????? ?? ??????.
  • ???? ????? ????? ?? ???? ??????? ?? ??? ?? ??? ?????? ???????.
??? ???? ??????? ??? ??? ??? ????? ?????? ??????? ??? ?????? ???? ??? ??? ??????? ?????? ????? ?? Publisher? ???? ????? ??? ????? ?? ?? ???? ???????? ???? ???? ????????. ???? ??? ???????? ???? ?? ?? ??? ????? ?????? ??????? ??? ??? ??? ????? ?? ??? ????? ??????. ??? ?? ??????? ??????? MetadataRetentionCleanup 1? ?? ?? ?????? ???????? ?? ??????? ???????? ??? ??? ????? ?????. ???? ??? ??????? ?? ??? ????? ????? ?? ??? ?????. ??? ??? ???????? ??????? ???? ??????? ????? ???????? ?????. ?????? ??? ??????? ???? ??????? ??????? ?? ?? ????? ??? ????? ???????? ??????.

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

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

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


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

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

??? ??????? ?????? ??? ??????? ???????? ?????? ????? ???????? ???? ?? ???? ???????? ??????? ???????? ???????:
  • ??????? ????? ???????? ???????? ?? ????? ?????????? ???? ????? ??? ???? ?????????.
??????? ????? ?????? ?????? ?? ???? ???????? ??? ??? ?? ?????? ???? ???? ??????? ???? ????????? ???? ????? ??????? ??? ?????? ??????????. ??? ???? ??????? ??? ??? ???????? ????? ?????? ??????? ?????? ????????? 10 ?? 20 ?? 30 ????? ??? ???????? ????? ????????? ???????? ???????? ????? ???????? ??? ??? ??????? ???? ?? 10 ????.
  • ?????? ??? ????? ???? ????????.
???? Microsoft ???? ??????? ????? ?? ?????? ??? ????? ???? ????????. ????? ?? ?? ????? ?????? ???? ???? ??? ??? ??????? ???????? ?? ?????? ?????????? ???. ??? ????? ?? ??? ?? ???? ??? ????? ????????? ???? ???? ????? ???? ?? ???? ????? ???????? ??????? ?? Publisher ?????? ??????? ??? ???? ???? ?????????. ??? ???? ??????? ????? ????? ???? ??????? ?? 10 ????. ??? ???????? ??????? ??? 8 ???? ??? ????? ????? ?????????. ??? ?? ????? ????? ????????? 4 ????? ??? ??? ?????? ??? 12 ????. ?? ????? ???????? ??? ???? ?????????. ??? ??? ?? ?? ?????? ??????? ?????? ??? ????? ?????????? ????? ????? ?????? ???????? ??? ???? ?????????.
  • ????? ??????? ??? ??? ?????? ???? ??????????????????.
??? ??? ??? ????? ?????? ???????? ???????? ?????? ????? ??????? ????? ???-????? ????????. ???? ????? ?????? ??????? ???????? ??? ??? ?????? ??????? ????? ?? ??? ????? ?????? ??? ?????? ??? ???? ???????? ???????.

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

??????? ????? ???????? ???????? ?? ??????? ?????? ?? SQL Server


??????? ???? ???????? ??? ??? ?????? ?????? ???????? ???? ??????? ????? ????????. ??? ??? ?????? ????? ?????? ?????? ??? ????? SQL server ???? ????? ?? ?????? ???? ?? ????????? ????? ????????? ?????? ????????? ??? ?????? ???????? ???????:
  • ?? ???? ??????? ????? ???????? ??? SQL Server 2000 SP1from ????? ??????? ???? ?? ?????? ???????? SQL Server 2000 ?????? ??? ??????? ?????????????????? ??? ????? ??????? sp_vupgrade_replication ???????. ????? sp_vupgrade_replication ???? ?? ??????? ?????? ??????????? ?????? ????? ????? ????????. ??? ?? ??? ?????? sp_vupgrade_replication? ?? ??? ?????? ??????? ????? ???????? ?? ???????????????????.
  • ??? ??????? ????? ?????? SQL Server 2000 ?? ?????? ???? ?? ??????? ?????? SQL Server 7.0 ????? ???????? Service Pack 1 ?? Service Pack 2 ?? Service Pack 3? ????? ???????? ??????????????????? ??? ????? ????? ?????? ?????????? ??? ????? ??? ???????. Youcan ?????? ??????? ????? ?????? SQL Server 2000 SP1 ?? ???? ???????? ?? ??????????? ????? ???????? ???? ????? ?? SQL Server 7.0. ??? ???? ?? ??? ???????? ??????????????????.
????? "???? ???? ???" ????-MaxCmdsInTran

?? SQL Server 2000 SP1? ??? ????? ????? ???? ????? ???? ???? -MaxCmdsInTran "???? ???? ???". ??? ??????? ?????? ??????? ??? ???? ???? ??? ????? ???????. ????? ???? ??????? ????????? ????? ???????? ????????. ??? ???? ??? ??? ???????? ??????? ???????? ???????. ????? ??? ??? ???? ????? ???? ??????. ??? ??????? ???? ????? ?? ???? ???????. ??? ???? ???? ??????? ????? ?????? ?? ???? ???? ?????.

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

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

????? ????? ûmaxcmdsintran ??

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

??????? "??????? ???????"

????? Microsoft ?? ????? ???? ????????? "????????? ??????????". ?? ??? ????? ??? ??????? ???? ?? SQL Server 2000 SP1. ??? ???? ???? ?????? ??? ??? ?????? "??????? ???????". ?????? ??? ??????? ?????? ??? ????? "??????? ???????"? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
297105 ?????: ????? ????? ?????? "??????? ???????"

???????

???? ???????: 889553 - ????? ??? ??????: 15/?? ??????/1434 - ??????: 2.0
????? ??????: 
kbdatabase kbservicepack kbhowto kbinfo kbmt KB889553 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????889553

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

 

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