??? Service Pack 4 ?? SQL Server 7.0 ? ???? ??????? Microsoft (MSDE) 1.0

?????? ????????? ?????? ?????????
???? ???????: 889543 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ?? Microsoft SQL Server 7.0 ? ???? ?????? Microsoft "(MSDE) 1.0 Service Pack 4 (SP4) ??????? ??????? ????? ?????? SQL Server 7.0 ?? MSDE 1.0 ???????. ???? ??? ?????? ????????? ??????? ??? SP4:
  • ??????? "???? ???????" ???????? Service Pack 4
  • ????? ????? ??????? Service Pack 4
  • ????? ????? Service Pack 4
  • ????? ????? ????? ?????? ????? ???????? "?" ?????? ?????? Service Pack 4
  • ???? ??? ??????? ???????? ???? ???? ??? ????? Service Pack 4 ???? ?? ??? ???????

?????????

??????? ????

????? ???

????? ??? ??????? ?? Microsoft SQL Server 7.0 ?????? ????? ?????? Service Pack 4 (SP4) ? Microsoft ?????? ???? (MSDE) 1.0 SP4 ?????? ????? ?????? ????? SQL Server 7.0 ?? MSDE 1.0. ????? ??? ???????? ???????:
  • ???? ????????
  • ????? ?????? ?????? ????? ???????? ??? ????? ??????? SQL Server ? osql (SQL Server 7.0 ???)
  • ????? ?????? ?????? ????? ?????? ??? ???? OLE DB ?? SQL Server ?????? ????? SQL Server ODBC ?????? ?????? Net
???? ????? SQL Server 7.0 ?????? ????? ?????? SP4 ??? ????? ????????? ???? ?????? ???? ?????? SQL Server 7.0 ?? MSDE 1.0. ????? 4 ???? ?????? ???????? ???????? ?????? ?? ????? SQL Server 7.0 ?? MSDE 1.0 ??? ????????? ???? ????? ???????? ???????? ?? ??? ??????? ???. ?????? "???????" ??? ?????? ????? ???????? ???????? ?? SQL Server 7.0 Enterprise Edition ?? ?? ??? ?????? ??????? ?????? ?? ???? Enterprise Edition. ??? ????? ???? ??????? ??? ??????? ???? ????? ??????? MSDE 1.0 ? ???? ??? ?????? ????? ???????? ??? ??????? ?? SQL Server 7.0. ??? ????? ???? ??????? ??? ??????? ??? ????? ????? ???????? ?????? ?????? ???? ??? ????? ?? ???? ?? ?????? ???? ????? ????????.

??? ??? ?????? ???? ????? ?????? SQL Server ???????? ????? SP4 ????????? ?? ???? ??? ?????? SQL Server 7.0 ???????. ????? ???? ????? SP4 ????? ?????? ?? ??????? 7.0 ?? SQL Server ?? MSDE 1.0 ?? ??? ?? ????? SQL Server 7.0 ?? MSDE 1.0 ???? ???? ???? ?? ?????? ??????.

?? ???? SQL Server 7.0 ?????? ????? ?????? SP4 ??? ????? ????????? ???? ????? ??? ????? CPU Alpha. SQL Server 7.0 ?????? Pacl 3 (SP3) ?? ??? ?? ???? ???? SQL Server 7.0 ????? ????? ????????? ???????? ??? Alpha.

?????? ??? ??????? ?????? ??? ????????? ??????? ?? SQL Server 7.0 ?????? ????? ?????? Service Pack 4 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
313980????? ??????? ???? ?? ??????? ?? ???? ??? ?????? ?? SQL Server 7.0
?????? ??? ??????? ?????? ??? ??????? ??? SQL Server 7.0 ?????? ????? ?????? Service Pack 4 ???? ?? ??? ????? ?? ??? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
313986?????? SQL Server 7.0 Service Pack 4 Readme.htm

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

??? ?? ??? ??????? ?? ???? ?????? ???? ??? ??????? ??? ???? ?? ???? ????? ?????? SQL Server 7.0 ?? MSDE 1.0 ? ?????? ?? ??????? ?? ???? ????? ??? SELECT @@ VERSION ?? osql ?? ???? ??????? SQL isql. ???? ?????? ?????? ??????? ??? ????? ????? ???? ??? ????? ?????? ????? @@ VERSION ??? ???? SQL Server 7.0 ? MSDE 1.0:
?? ??? ??????????? ??? ??????
@@ ?????????? SQL Server
7.00.623??????? ?????? ?? SQL Server 7.0 ?? MSDE 1.0
7.00.699????? ?????? ?????? Service Pack 1 (SP1)
7.00.842????? ?????? ?????? Service Pack 2 (SP2)
7.00.961????? ?????? ?????? SP3
7.00.1063SP4 ?????? ????? ????????
??? ?? ??? ??????? ?? ????? SQL Server 7.0 ??? ??????? ?? ??? ??? ???????? MSDE 1.0 ????? ?????? ?? ??????? ???? ?? ??????? ?????? ????? @@ ????? ?????? ??????? ???? ?? ??????? ??. ??? ???? ??????? ?? ???? ??????? ?????? ??? ???:
MSDE on Windows NT 4.0 (Build 1381: Service Pack 4)
Desktop Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
Developer Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
????????? ??????? ???????

??? ????? ??????? ?????? ??? 20 ?????? 2002 ??????? ?????? ??? ??????? ?? ??? ??????? ?? SP4. ???? ????? ????? ??????? ???????? ??????? ???? ?? SP4.

????? SP4

cannnot ????? ????? SP4 ?????? ???? ??????? ?????? ?????? ???? ????? ???? ?????? ?? ??? ???????. ?????? ??? ????? ?? ??? SP4 ?? ??????? ??? ????? ?? ?? ?????? ????? SQL Server 7.0 ?? MSDE 1.0. ??, ??? ??? ??? ??????? ??? ????? ???? ?????? (SP1 ?? SP2 ?? SP3) ???? ??? ??????? ??? ????? SP4. ??? ????? ????? SQL Server 7.0 ?? MSDE 1.0 ??? ????? ???????? ??? SP4. ????? ?? ????? ????? ??? ????? ????? SQL Server 7.0 ?? MSDE 1.0 ? ??? SP1 ?? SP2 ?? SP3. ?????? ??? ??????? ??? ??????? ???? ????????? sp_attach_dbsp_detach_db "??? SQL Server ???????" ?? SQL Server 7.0. ??? ?? ????? ?? ?? ????? ????? ???? ????? ????? ?????? ????? ?????? ????????. ??? ????? ????? ????? ?????? ???????? ????? ??? ??????? ?? ????? ???????? msdb ???????? ??? ??? ??????? ??? ???????? ?? ???? ????? ????????. ??? ??????? ????? ????????, ????? ????? ????? ????? ????????.

????? ?? ??????? SP4

??? ????? ???? ?????? ??? ?? ?????? ???????:
  • ??? ????? ??????? ?? SP4
  • ?? ??? ????????? ???? ???? Sql70sp4.exe ???? ????? ??????? ?? ??????
??????? ??? ??????? ???? Sql70sp4.exe ?????? ?????? ?? ???????? ??? ??????? ???????? ??? ???? ????????? ????? ?? ?? ??? ???????? ???????? ???????? ??? "????? ???????" ?? SP4. ??? ????? ??????? ?? ???? ??? ?? "????? ???????" ?? SP4 ? ????? SP4 ????????.

?? ???? ????? SP4 ??? ?? ??? ??????? ??????? ?????? ?????? ???? ???? ??? ????? ??????? ????????.

?????? ?????? ?? ??????? ???????? ?? ??? ?????? ????? ????. ???? ?? ????? ?????? ????? ???? ??????? ?? ?????? Microsoft Windows NT ?? Windows Explorer ??? ????? ?? ??? ??????. ?????? ??? ??????? ???? ??????? ???????:
  1. ??? ????? ?????? Windows "??" ?????? Windows NT.
  2. ?? ??????? ???? ???? ??? ??????.
  3. ??? ????? ??????? ??? ? ???? ?????? ????? ???? ???????.

??????? ????? ????? ?? SP4

??? ?? ???? ???? 231 ???????? ?? ????? ????? ?? ???? SP4 ??? ????? ??? ??????? ???? ???? ??????? ??? ???? ??????? C ??? ???? ????????? ????? ?? ?? ????? ????????? ??? ????.

??? ??? ???? ????? ????? ??? ????? ?????? SP4 ??? ???? ??????? C ??? ???? ????????? ????? ?? ???? ????? ????? ??? ????? ?? ???? ????? ????? ????? SP4 ??? ???? ????? ?????. ??? ????? ??????? ????? ??????? ?? ??? Zip ??? ???? ??????? C. ????? ??? ??????? 188 ???????? ??? ???? ??????? C ? 43 ???????? ??? ???? ??????? ???????.

??????? SP4 ?????? ????? ????????

???????? SP4 ?????? ????? ??? ??? ??????? ???? ??? ???? ??? ???? ????????? ???? ???? ????? ??????? SQL Server 7.0 ?? MSDE 1.0. ??? ???? ?? ?????? ?????. ??????? ???????? self-extraction ???? ?????? ??? ???? ??? ????? ???? ???????. ??? ???? ??????? ??? ??? ?????? SQL Server ?? MSDE ?????? ????? ???? ???? C:\70sp4 ??? ??? Sql70sp4.exe ??? ????????? ????? ??, ?? ?????? ????? ?? ?? ?????? ??? ?????? C:\70sp4 ????? ??? ???????.

????? ??? ??????? ????? ???? ??????? ?? ?? ???? ??????? Microsoft Systems Management Server ??? ?????? C:\70sp4. ????? ??? ???? ????? ???? ??????? ?? ???? ???? \X86.

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

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

?????? SP4 ???? ??????? ??????? ???. ?????? ?????? ???? ???? ? ??? ???? SQL Server 7.0 ??????? ???? ??????? ??? ????? ??????:
  • ????? ???? ????? ????????: ????? ??? ???? ??????? ???? ?????? ????? ???????? ???????? ??? ????? ?? ?? ????? ?? SQL Server 7.0 ?? MSDE 1.0. ????? ????? ??? ????? ????????? ??? ?????? ?????? ????? ????????.
  • ????? ???? ??? ????? ????????: ????? ??? ??????? ???? ????? ??????? ???????:
    • ????? ?????? ?????? ????? ?????? ??? ???? OLE DB ?? SQL Server ?????? ????? SQL Server ODBC ?????? ?????? Net (??? ?? SQL Server 7.0 ?? MSDE 1.0).
    • ??????? ???????? ?????? ????? ???????? ??? ????? ??????? SQL Server ? bcp (SQL Server 7.0 ???).
  • ????? ???? ?????? ????? ?????: ????? ??? ??????? ???? ????? ??????? SQL Server 7.0 ???? ?? ?????? ?? ???? ?????? ????? ???.
  • ????? ???? ????? ????????: ????? ??? ??????? ???? ????? ??????? SQL Server 7.0 ???? ????? ?????? ???? ??? ????? ????? ?? ???????? ????? ????????.
?? ???? ????? ? ??? ??? ???????? ??????? ???????.

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

?????? ??? ????? SP4 ??? ??????? ??????? ?? Windows NT 4.0 ???? ????????? ??????? ?? ????? ????? Microsoft ???????? ???????:
259484??? ?????? ???????? CryptEncrypt ? CryptDecrypt ?? ????? ???????? ?? Windows 2000
??? ??? ???????
????? ??????? ??? ???? ?????? ????? ??????.

?? ?????? ??????? SP4 ????? ????? ???????? ???????? ??? ????? ???????? ??? ???????? ???? ????? ???????? ?? ???????? ????? ????????. ??? ????? ???? ????? ?????? ??? ???????? ?? ???????? ????? ???????? ???????? ??? SP4. ??? ???? ??????:
  • ????? ??????? ????? ?????? ?????? ????? ??????? ?? ???? ?? SQL Server 7.0 ?? SQL Server 7.0 ?????? ????? ?????? SP1 ?? SP2 ?? SP3 ??? ???? SQL Server 7.0 ?????? ????? ?????? SP4.
  • ????? ??????? ????? ?????? ?????? ????? ??????? ?? ???? SQL Server 7.0 ?????? ????? ?????? SP4 ????? SQL Server 7.0 ?? SQL Server 7.0 ?????? ????? ?????? SP1 ?? SP2 ?? SP3.
  • ????? ??? ????? ?????? ?????? ?? ???? ?? SQL Server 7.0 ?? SQL Server 7.0 ?????? ????? ?????? SP1 ?? SP2 ?? SP3 ??? ?? ?????? ??? ???? SQL Server 7.0 ?????? ????? ?????? SP4.
  • ????? ??? ????? ?????? ?????? ?? ???? SQL Server 7.0 ?????? ????? ?????? SP4 ??? ?? ?????? ??? ???? SQL Server 7.0 ?? SQL Server 7.0 ?????? ????? ?????? SP1 ?? SP2 ?? SP3.
??????? SP4 ????? ????? ?????? ???????? ???? ????? ?? ???????? ????? ????????. ??? ????? SP4 ???? ?? ?? ????? ???????? ????? ???????? ?????????? ????? ??????? ??? ???? ???????? ???? ??? ????? ?????? "???????" ??? ?????? ??? ????? ????????. ????? ?? ????????? ??? ????? ????? SP4 ??? ????? ???????? ???????? ?? ???????? ????? ???????? ???? Installing on replicated servers.
??? ???? ????? Systems Management Server ????? ???????
????? ????? ??????? Microsoft Systems Management Server ?????? SP4 ???????? ??? ?????? ?? ????? ????????? ???? ???? ????? ??????? Windows NT Server. ????? Smssql.sms ?? ??? ????? ???? ?????? ????? ???? SQL Server ?? "???? ????? ???????". ?? ???? ????? ???? SQL Server ?????? ??????? ??? ????? ????????? ???? ???? ??? "???? ????? ???????". ????? Unattspsms.bat ?? ??? ???? ???? ?? ???? ??????? ?? ????????? ??? ?? ???? ?????? ??????? ??????? ?? ??????? ????????.

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

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

??????? ?????? ?? ????? ??? ??????? ????? SQL Server ????? ????????. ????? ??? ????? ???????? ???????????? ? msdb. ????? ???? ?????? ?? ???? ?????? ????? ?????? ???????? ???????? ????? ?????? ???????? ???????? ?? ????? ???????? ???? ??? ????? ????? ???????? ???????? ???? msdb. ?????? ???? ??????? ??? ????? ????? ???????? ????????msdb ? ????. ??? ??? ????? ??? ?????? ?? ??????? SQL Server 7.0 ??? ????? SP4. ????? ?????????? ??? ?????? ??? ???? ????? ????? SQL Server 7.0 ???? SP4.

??? ????? prudent ???? ???? ???????? ?? ????? ???????? ???????? ? ??? ????? ?? ?? ???? SP4 ????????? ??? ?? ????? ?????? ???????? ???? ????? ?? ???????? ????? ????????.

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

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

????? ???? ??? ?????? ??? ????? ???????? ?????????:
  • ?????? autogrow ?????? ???????? ???????? ???? msdb ?? ???? SQL Server ?? MSDE ????? SP4.
  • ????? ???? ??????? ???? ????? ??? ????? ???????? ??? ??? ????? 500 ???? ???? ?? ??????? ????? ???????? ??? ????? ?????? ???? autogrow.
?? SQL Server 7.0 ????? ?????? ?? ???? ????? ?????? ?????? ??? ????? ??? ?????. ?????? ????? ??????? ????? SQL ?? ????? SQL Server ??????? ???? ??? ?????? ?????? ??? ??? ????? ???????? ?? ?? ???? ??? ?????. ???? ?? ????? ???? ???????? ???????? ????? ??? ?????. ?????? ??? ?? MSDE ????? ?????? SQL ???????:
  • sp_helpdb ????????
  • sp_helpdb msdb
?? ???????? ??? ???????? ???? ?? ?? ?????? ??? ??? 0.

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

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

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

??? ????? SP4 ?????? ????? ???????? ??? SQL Server 7.0 Enterprise Edition ?? ???? ????? ??? ??? ???? ?? ?? ???????? ???? ????? ??? Microsoft ??????? ??????? ???? (MSDTC) ????? ?? ??? ???? ???? ?? ????? MSDTC ?????.

??? ??? ?? ?????? ??? ?????? ???????? ? ???? ?????? ?????? ????? Service Pack 4 MSDTC ??????? ??? ?????? ????? ??????? ?? ??? ?????? ????? ??????? ????????. ?? ?????? ??????? ?? ???? ????? ???????? ??? ?????? ???? ?? ????? MSDTC ?????. ??? ????? SQL Server Enterprise Edition ?? ????? ?????? ???????? ?? ???? unclustered ??? ????? SP4 ?????? ????? ????????. ??? ????? ????? ?????? SQL Server? ??????? "????? ??????" ?????? ?? ?? ????? ???? ?????? ???? ????? ??? ??? ????? ???? ???????? SQL Server ?????? ???????:
  • ??? ?????? SQL
  • ????? IP SQL
  • ???? SQL
  • ???? ???? SQL
  • VServer SQL
????? ?? ?????? ????? ???? ????? ????????? ??? ????? ???? ??????. ??? ???? ????? Microsoft ???? "??? ????? ????????" ?????? ????? ??? ??? ?????? SQL ? ??? ?? ???? ???? ???? "??? ??????? ?? ????? ??????" ??? ?????. ?? ??? ??????? ?????? ??? ??? ??? ?????? ??? ?? ??? ????????. ??? ??? ???? ????? ??????? ?????? ?? ???????? ????? ??? ???? ?????. ?? ??? ??????? ??? ??? ???? ??????? ???. ????? ??? ??? ???? ????? ??? ????? SP4.

????? ????? ?????? SQL Server? ???? ??????? ???????:
  1. ?? ???????? ?????? SQL Server 7.0 ???? ??? ????? ???? ?????? ????? ?????.
  2. ????? ??? ??????? ?????? ????? ?????? SQL Server Enterprise Edition ??????? ?? ???? ????????? ???? ???? ?????? ???????.
???? ??????? ??????? ??? ???? ????? ?? ???? Windows NT ?? Windows 2000 ?? ?????? SQL Server ??. ???? ?? ?? "????? ???? ?????? ????? ?????" ???? ???? ????? ??????? SQL Server ??????.

??? ????? ???? ?????? SQL Server 7.0 ???? ???? ?? ???? ??? SP4 ??? ?? ??? reclustered.

????? ?? ????????? ??? ?????? SQL Server ?? ???? ????? ??? ??? ???? SQL Server clustering white paper.

????? ????????? ??? ????? ?????? ??????? SP4

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

??? ????? ?????? ??????? SP4 ?????? SP4 ?????? ????? ?????? ????? ???????? ???????:
  • ????? Microsoft Search ? MSDTC MSSQLServer MSSQLServerOLAPService ? SQLServerAgent
  • ????????? Microsoft Server "?" ??? ??????? ?? ????? ?????? "?" ?????? ????????? Microsoft COM (COMTI)
  • ???? ?????????. ????? ??? "???? ??????"
??? ??? ???? ?????? SP4 ?? ???? Windows NT ???? ?? ????? ??? ????????? ???????? ??? ???? ????? ?? ???? ????????.

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

????? SP4 ?????? ????? ????????

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

????? ??? ???? Setup.bat ?? ?? ?? ??????? ???????:
  • ?????? ???? ????? ??? ????? ???? ??????? ????????? ?? Sql70sp4.exe
  • ???? ???? ?????? ??? CD SP4 ????? ?? SQL Server 7.0
?????? ?? ??? ?????? ??? ???????? Setup.bat ???????? ???? ????? ?????? ??????? Microsoft. ??????? ?? ??? ?? SP4 ???????? "??????? ???????" ?????? ??? ?????.

??? ????? ??? ???? Setup.bat ???? ???? ???? ???? InstallShield ?????? ??????? ??? ?? ??? ??? ???? ??????? ?????? ???? SQL ?? ?????? Windows NT. ??? ????? "?????? ???? SQL" ? ??? ????? ?????? "???????" ???????? ???? ???? ????? ?????? sa. ??? ????? "?????? Windows NT" ? ??? ????? ?????? "???????" ????? ??? ????? ????? ??? Windows ???????? ???? ????? ???? Windows ??? ??? ?????? ???? ????? ?????? ???? SQL Server ?? MSDE ??? ???? ????????.

??, ?????? ?????? "???????" SQL ???????? ?????? ???? ????? Server ?? MSDE ?? ??????. ????? ?????? "???????" ????? ??? ????? ??????? ?????? .sql ?????? ???? ????? ?????????.

MSDTC ?????? ?????? ????? ???? ?? MSDTC ??? ?????? ????? ??. ?? ???? ?????? ???????? ??? ??? ??? ???? ????? ?? ???? Windows NT.

????? ???? ?????? "???????" SQL Server 7.0 ?? MSDE 1.0 ?????? .sql ?? ??????? ?????? ??? ????????? ?????? ?????? ???????, ???? ???? ???? ???? ???? ??? ?????? ??? ??? ?? ??????? ?????? "??? ??????" ?? ???? ???? ????? ?????? ?????? sa. ??? ???? ?????????? ???? ??????? ????? ????? ?????? ?? ????? ???? ????? ???? ????? ????? ?????? sa. ??? ???? ???? ????? ?????? sa ????? ???? ?????????? ??? ???????? ?????? ?????? ????? ??? SQL Server ?? MSDE. ?????? ??????? ??? ?? ????? ???? ???? sa ?? ?????? ?????? Windows NT. ?????????? ?? ?????? ???? ?????? ??? ?????? ????????? ??????? ?? ??? ???????. ?????? ???? ?????? ????????? ?????????? ???????:
  • ?????? ???? ??????? ??? ????? ????????? ???? ???? ????? ??????? Microsoft Windows Millennium Edition ? Microsoft Windows 98 ?? ???? ??????? Microsoft Windows 95 ???? ?????? ??? ?????? ????? ??????. ????? ??????? ?? ??? ???????? ?????? ??????? ??? ????? ??????? ???. ?? ???? ???? ?????? ????? ???? ???? ????? ?????? sa. ??? ??? ?????? ???? ????? ?????? "???????" ????? ???? ???? ????? ?????? sa. ??? ???? ???? ?????? ?????? ????? ????? ???????? ??? ????? ???? ??????.
  • ?????? ???? ??????? ??? ????? ????????? ???? ???? ????? ??????? Windows NT 4.0 ?? Microsoft Windows 2000 ?????? "???????" ?????? Windows NT. ????? ??????? ???? ?????? ????? ????????? ??? ?????? Windows NT ?? ??? ????? ??? ???????? ??? "??? ??????" ?? ???? ????? ???? sa ??? ????.
??? ????? ??? ?????? ?? ???? ?????? ?????? ?????? sa ???? ?? ?? ??? ?? ???? ??? ????????? ????????. ??? ???? ??????? ??? ??? ?????? SQL Server ??? ???? ??????? ????? ??? ???? ??????? Windows 2000 ??????? ?? "??? ??????" ??? ??? ?????? Windows NT ????? ??????? ????????? ???????? ???? ?????? ?????? ???? SQL ??? ??? ????? ?????? ?????? Windows NT. ?????? ??? ??? ?????? ???? ???? ????? ?????? sa ????????? ?? ???????? ???????? ???? ?????? ???? ?????? ??????? ?? ???? ??????? ??? ????? ???????? ???? ?????? ???????.

?????? "???????" ?????? ????????? ???? ?????? ?? ????? Sqlsp.log ?? ?????? Temp ????????? ???? ??? ??????.

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

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

??? ?????? "?????? ???????" ? ?? ??? ??????? ?????? ????? ??????. ??? ????? ????? ?????? ?? ??? ?????? "?????? ???????" ??? ??? ????? ????? ?????? ?????? "?????" ?? "???? ??????" ?????? ?? ????? ??????? ???????:
  • Microsoft Search
  • msdtc
  • MSSQLServer
  • MSSQLServerOLAPService
  • SQLServerAgent
????? ??? ??????? ?????? ???????? ???????? ? msdb ??? ??????.

recluster ????? ????

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

??? ??? ?????? SP4 ?? ????? ???? Windows NT ? recluster SQL Server. ??? reclustering ? ??? ?? ????? SP4 ??? ???? ?????? SQL Server 7.0 ??????? ?? ???? ????????.

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756????? ??? ???? ???????? ? ??????? ??????? ?? Windows


??? ??? ?????? ???????? "??? ??????? ?? ????? ??????" ??? SQL Server ????? ???? ??????? ?????? ????? ??????? ??????:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSMQ\Parameters\MachineCache\MQS
??? ??? ??????? ?????? 2 (?? ??? BSC) ? 4 (PSC) ?? 8 (?? ??? PEC) ? ????? ?????? ??????? ??? ?????? ?????? ??? 1. ????? ???? ???? ??????? ???? ?????.

recluster SQL Server ? ???? ??????? ???????:
  1. ?? ???????? ?????? SQL Server 7.0 ???? ??? ????? ???? ?????? ????? ?????.
  2. ??? ??????? ?????? ??????? ????? ????? ?????? SQL Server Enterprise Edition ??????? ?? ???? ??????? ???????? ?? ???? ????????? ???? ???? ???????.
???? ??????? ??????? ??? ???? ????? ??? ???? Windows NT ???? ????? ??? ?????? SQL Server ???? ???? ?????? ?? ???? ????????.

?? ????? ??????? "??? ??????? ?? ????? ??????"
HKEY_LOCAL_MACHINE\Software\Microsoft\MSMQ\Parameters\MachineCache\MQS
. ??? ??? ?????? ???? ??? ??????? ?????? ??? ??????? "????? ???? ?????? ????? ?????" ????? "???? ???????" ???????? ?????? ??????? ?? ????? ??????? ". ??? ??? ?????? ???????? ??? ????? SQL Server ? ????? ??????? ??? ?? ???? ?? ????? "Prepare cluster configurations ???????" ????? ?????? "???????? ????????. ??? ??? ???? ???? "??? ??????? ?? ????? ??????" ?????? ??? SQL Server ? ??? ?????? SQL, ?????? & "????? ?????? &" ???????? ????????. ????? ?????? ??? ?? ??? ???? ??????? ?????? ???? ??? ???????? ?? ?????? Prepare cluster configurations. ??? ??? ?????? ??? ???? ????? ???????? ????? IP ?? ?????? Prepare cluster configurations ??????. ????? ?? ???? "??? ??????? ??????? ??? ?????? ?? ????? ??????".

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

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

????? ????? ????????? ????? ??? ????? ??????? SP4 ????????.

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

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

???? ?????? ???? ?????? ??? ??? ???? ??????? SQL Server 7.0 ????????? ?? ???????? ????? ????????:
  • ??????
  • ????
  • ?????????
?? ???????? ??????? ??????? ?????? ??? SP4 ??? ???????? ????? ????????:
  1. ???? ??? ??? ?????? ?? ??????
  2. ??????
  3. ?????
?????? ???? ???? ???? ?? ????? ???????? "??? ???? ? Publisher ??? ??? ?????? ?? ??? ????? ?? ??? ?????.

?? ????? ???????? "???" ? ??? ??????? ????? ???????? ??????? ??? ?????? ??????? ????. ???? ???? ?????? ???????? ??????? ?? ???????? ????? ?????? ??? ?????? ??? ??? ????????? ??? ????? ???????? ????????. ??? ???? ???? ????? ?? ???? ???? ????? ?????? ????? ???? ????? ???????? ??? ????? ?????? sign ????? ???? ????? ?????????.

?? ?? ?????? ??? ????? ???? ??????? ?? ???????? ????? ?????? ?????. ????? ?????? ????? ???????? ????? ????? ??? ???????? ???? ?????? ??????? ?????? ?? SQL Server 7.0 ?? ??? ??????? ??????? ???? SP4 ?????????. ??? ????? ??????????? ?? ??????? ???????:
????? SP4 ??? ???? ???? ????? ?????? ????? ???? ??????? ?????
?? ???? ????? ???? ??? SP4 ??? ?????? ????? ??? ????? ?????? ????? ???? ????????? ??? ??? ????? ????? ?? ????? ???????? ??? Publisher ?????? ????? ???????? ??????? ??? SP4. ???? ??? ??????? ?? ???? ????? ?????? ??????? ???????? ?? ????? ???????? ????? ??????? ?????? ?????? ?? ????? ??? (???) ???? ??? ??????? ??? ????.

????? ??? Publisher ????? ?????????? ????? ??? SP4 ?? ??????? ?????? ?? SQL Server 7.0
?????? ??? ???? ????????? ????? ???????? ?? ???????? ???? ??? ???? ??????? ?????? ?? SQL Server 7.0 ?????? ??? ????? -70Subscribers ??????? ?????????? ??? ???? ?? ???? "???? ???????".

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

??? ???? ????? ??? ??????? ??????? ?????? ?? SQL Server ?????? ??????? ??????, ????? ??? ??????? ????? ?????? ??? ??? ???????? ??? ???? ??? ???????. ??? ???? ??? ?? ????? ???????? ?? ????? ?????? ?? ??? ??? ??? ?? ???? reinitialized ???????? ??????? ?????. ??? ?? ?????? ?????? ??????? ??? SP4 ????? ?? ??????? ???????. ??? ??? ???? ?? ?????? ?? ????? ????? ??????? ??? ???? ?????? ?? ?? ?? ????????? ??? ????? ??? SP4.

????? SP4 ??? ??? ????? ?????? ???????
?? ???? ????? ????? ?????? ??? SQL Server ??????? ??? SP4 ????? ??? ????? ?? ?? ????? ???????? ????? ??????? ???????? ??? SP4. ??? ?????? ??????? ??????? ???????? ?? ????? ???????? ????? ??????? ?????? ?????? ?? ????? ??? (???) ???? ??? ??????? ??? ???????. ???? ???? ????? ??? ???????? ????? ????? ???? Publisher ??????? ?????? ?? Installing on replicated servers ??????.

????? ????? ???????? SP4 ?? ????????? ??????? ?? SQL Server
?? ???? ?? ???????? ???????? ?? ??????? ???? ???? SP4 ?? SQL Server 6.0 ?? SQL Server 6.5 ?????? ? ????????? ????????? ?? ??????? ???? ???? ??????? ?????? ?? SQL Server 7.0 ?? ??? ????????? ???????.

????? ????? ???????? ??? Access 2000 (Jet 4.0) ?????????
???? Microsoft ???????? ??? Jet Microsoft Access 2000 ????????? ????????? ?? ????????? ?? SP4 ? ??? ??? ????? SP4 ?????? ????? ???????? ??????? ??? ????? ????? ???? ???? ?? Access 2000:
  • X86\Binn\Replres.dll
  • X86\Binn\Replrec.dll
  • X86\Binn\Replprov.dll
  • X86\Jet\Msrpjt40.dll
??? ?? ??? ??? ?????? ?????? ??? ???? ????? ?????? ?? ???? ?????:
\Program Files\Common Files\Microsoft Shared\Database ????? ????????
?????? ?? ??? ???? ???? ??????? ??????? ??? ???? MSDE 1.0 ?? ??? Access 2000 ???????. ?? ??? ??????? ????? "?????? ?????" SP4.

?????? ????? ?????? ?????? SP4 ?????? ????? ????????

????? SP4 ?? SQL Server 7.0 ? MSDE 1.0 ???? ??????? ???? Sqlredis.exe ???? ?? ????? Mdacredist.txt. ???? ???????? ??? ????? Sqlredis.exe ???? ?? ???:
  1. Sqlredis.exe ?????? ????? Mdac_typ.exe ?? Microsoft Data Access Components (MDAC) 2.1 SP2. ????? ??? ???????? ???????? MDAC 2.1 SP2 ?????????? SQL Server ? MSDE ??????? ?????? ?????? ???? ?? ??????? ?? SP1 SQL Server 7.0 ?? MSDE 1.0.
  2. ?????? Sqlredis.exe ?????? ????? ???? SQL Server ? MSDE ?? ??????? ????? ?? ????? ?????? ?????? SP4.
  3. ??????? Sqlredis.exe ??????? Mswstr10.dll ? Mswdat10.dll Oleaut32.dll Olepro32.dll ? Stdole2.tlb.
??? ???? ????? SP4 ?????? ????? ?????? ??????? ???????? ???? ????? ?????? ?? ???? ???????:
/C:"setupre.exe sqlredis.exe MDAC = 0 -s - SMS"
???? ????? ????? ????? Sqlredis.exe ??? ????? ?????? ??????? ???? ??? ????? ?? ??? Mdacredist.txt ????? ?? ???? ?????? ???.

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

????? ??? ????? ??????? ???? ???? ??? ????? ???? SP4 ???? ?? ???? ?? ????????? ??????? ?? ???? ??????.

??? ????? ????????? ?? ???? ???? ??? ??????? ?????? ????????? ?? ????? ??????? ?? Microsoft ?????? ??? ?? ?????. ?????? ??? ??????? ?????? ??? ????????? ??????? ?? SQL Server 7.0 ?????? ????? ?????? Service Pack 4 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
313980????? ??????? ???? ?? ??????? ?? ???? ??? ?????? ?? SQL Server 7.0

????? ????? ????????? ?????? ??? ??? ????? SP4

?? ??? ???????? ?????????? ????? ?????? ???? SQL Server ??? ??? ??????? ?????. ???? ??? ????? ????? ?? Enterprise Edition Desktop ???? ????? ???????? ??? ???? ????????? ?? ???? ????? ?????? "???????" ?? ????? ??????? ????? ?? SQL Server. ??? ?? ????? ?????? ?????? ??? ???? ????????? ?????? ??? SP4 ? ??? ?????? ????? SQL Server ?????? ????? ????? ???????:
?? ????? ????? ????? ?????? (7.00.623) ?? ??????? ??????? ??? ?????? ????? ?? (7.00.1063). ????? ????? ??????? ??????.
?????? ?????? ?? Enterprise Edition Desktop ???? ????? ???????? ??? ??????? ???? ?????? ?????? ?????? SP4 ???? ??????? ???????:
  1. ??? ??? Bcp.exe ?? ????? ??????? ?????? ?? SQL Server 7.0 ??? ??????? ????. ???? ??? ??? ??????? ??? ??????? SP4 ?? Bcp.exe ?? ?????? C:\Mssql7\Binn.
  2. ????? ?????? "???????" ?? ????? ??????? SQL Server 7.0 ?????? ?????? ??????.
  3. ?? ?????? ?????? ?????? ????? ?????? ?????? ????? Service Pack 4 ????? ???? ???????? ????? ?????? SQL Server ??? ????????? ??? SP4.
?????? ?????? ???? ??????? ?? Enterprise Edition ??????, ??? ???? ????? ???? ?????. ???? ????? ???? Desktop Edition ??? ????? ????????? ??????? ???? ?????? ???????? ?? ??????? SQL Server ???? ???? ??????? (CAL).

????? ?????? ????? ???????? ????????? ??? Windows 2000 ??? ????? SP4

?? ????? ????? SP4 ?????? ????? ???????? ??? ??????? ???? ????? ??????? Windows NT ?? Windows 95 ?? Windows 98 ? ???? ??? ??????? ??? Windows 2000. ??? ???? ??? ??????? ?????? ????? Windows 2000 ??? ????? ?????? ??????? ?? ??? ?????? ????????? ?? ??????? ??????? ???? ?? ??????? ?????? ?? ???? SP4. ??? ??????? ?????? ????????? ?? ????? ?????? SQL Server ????? ?? ????? ????? ????? Sqlredis.exe ??????? ?? SP4 ??? ??????? ??? Windows 2000. ????? ?? ????????? ??? ????? Sqlredis.exe ???? Redistributing Database Components SP4 client components ??????.

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

????? SP4 ??? ????? ????

??? ?????? ????? ????? SQL Server ?? ??????? ??????? ??????? ???? ????? ???????? ???????? ??? ??????? ?? ????? ???? ?? ??? ???? ??? ??????? ?? SP4 ?????? ????? ???????? ?? ??? ????? ???????? ?????? ????? Service Pack 4 ? ?? ????? ????? ????? ???????:
??? ??????? ?? ?????? SQL Server ???? ?? ??? ???????? ?? "???? ???????". ?? ??? ?????? ?????? ???????.
???? ???? ???? ????? ????? ??? ??? SP4 ?? ????? ???? ?? ?????? ?????? ??? ???? SQL Server ??? ?????? ? ????? ??? ??????.

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

????? SP4 ??? Windows NT 4. 0? ????? ?????? ??????

?? ??? ?????? ??????? ?????? ?? SQL Server 7.0 ??? ???? ??????? Windows NT 4.0 ????? ?????? ??????. ????? SQL Server 7.0 ?????? ????? ?????? SP1 ??? ?????? SQL Server ??? "???? ??????? Windows NT 4. 0? ????? ?????? ??????". SQL Server 7.0 ?????? ????? ?????? SP3 ? SP4 ?????? ??? "???? ??????? Windows NT 4. 0? ????? ?????? ??????".

?????? ???? ??????? ??????? ??? ??? ??? ???? ?????? ????? SQL Server 7.0 ???? ??? ??? ???? ??????? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????". ??? ??? ?????? ?????? ??? ????? ?? SQL Server 7.0 SP2 ?? SP3 ?? ???? ??? ??? ??????? ??? ????? ??? SP4.

????? SQL Server ?????? ????? ?????? SP4 ????? Windows NT Server 4.0 SP4 Edition ???? ?????? ??????? ??? ???? ??????? ???? ?????? "????? ?????? ??????" ??? ????? SQL Server. ???? ?????? ??? ??? "????? ?????? ??????" ?????? ?????? ?? Windows NT Server 4.0 ?????? ????? ?????? SP4. ?????? ??? ??????? ?????? ??? ??? ?????? ????? ?????? ?????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
152734????? ?????? ??? ???? ???? ???? ?? Windows NT 4.0
????? SQL Server 7.0 ? SQL Server ?????? ????? ?????? SP4 ??? ???? ??????? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????" ???? ??????? ???????:
  1. ???? ?? ??? ?? ????? Windows NT 4.0 ? Terminal Server Edition ?????? ????? ?????? SP4.
  2. ?????? ?????? "?????" ?? "???? ??????" ?????? "???? ????? ??????" ??????.
  3. ???? ????? SQL Server ODBC System32 ???? ??? ??????? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????".
  4. ?? ?????? ????? ??????? SQL Server 7.0 ?? ???? ????????? ?? ?? ???? ??????? ?? ?????? X86\ODBC ??? ????? ??????? ??? C:\Winnt\System32 ???? ????? ??? ??????.
  5. ?????? ?????? "?????" ?? "???? ??????" ?????? ????? "???? ????? ?????? ??????".
  6. ????? SQL Server 7.0 ???????? ????? SQL Server 7.0. ?? ????? ????? SQL Server ???????? ???? ????. ??? ???? ????? SQL Server ???????? ???? ?????? ??? ??????? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????". ?? ????? ??????? ???? ?????? ????? ??????? ???????? ???? ???? ??? ?????? ????? ??????? ???? SQL ?????? ???? SQL ??? ??????? ???? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????". ????? ?? ???? ???? ??????? ???????:
    1. ?? ?????? ?????? "??????? ????????".
    2. ?? "???? ???????" ???? ????? ?? ????? "???????".
    3. ???? ??? ????? ?? ???? ?????????. ????? ?????? ??????? ?????? ?? ????? ??????? SQL Server 7.0 ?? ?????? ??????:
      X86\Setup\Setupsql.exe
    ???? ????????? ?? ?????? ????? SQL Server. ??? ??? ???? ?? ????? ????? ?????? ?????? ??? ??????? ???? "???? ??????? Windows NT 4. 0? ????? ?????? ??????" ????? ????? SQL Server ???? ?????? ?????? ??????? ?????? ????? ????? ????????. ??? ??? ???? ??? ??? ?????? ??? ??????? ??? ????? ?????? SQL Server ??? ??????? ?????? ??? ????????? ???? ???? ??? ??? ???? ????????? ?? "???? ??????? Windows NT 4. 0? ????? ?????? ??????" ??? ????? ?????? ????? ??????. ?????? ??? ???? ?? ????????? ??? ????? ????? ????? ?????? ???? ?? ???? ????? - ??? ???? "????? ????? SQL Server" ?? "??? SQL Server ???????" ?? SQL Server 7.0.
  7. ????? SQL Server ?????? ????? ?????? SP4 ?????? ????????? ???????? ?? ??? ???????. ??? ???? ????? SP4 ?? ???? ?????? ????? ??????? ???? ?????? "???? ??????? Windows NT 4. 0? ????? ?????? ??????". ?????? ??? ???? ????? Service Pack 4 (Setup.bat) ?????? ??????? ?? ???? ????? ?? ????? "???????" ?? "???? ??????".

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

????? SP2 ?????? ????? ?????? ????? ???? ?? ????? "???? ??????? ??????? ????????" ?? "??? SQL Server ???????" ?? SQL Server 7.0. ????? ?????? ?????? SP4 ????? ?????? ??? ??????? ?????? ?? ??????. ????? ?????? ?????? ??? ??????? ?????? ?? ?????? "??? SQL Server ???????" ?? SQL Server 7.0 ?????????? ??????? ??????? ?? ????? ??? SQL Server:
  • ??????? ?????? ?? ??????? ????????? (FAQs)
  • ??????? ?????? ?????????? ?? "?????? ??? ??????" ???? ????? ??? ??????? ???? proficient ?? SQL Server 7.0
????? SP4 ?????? ????? ?????? ??? ???? ???? ????? Tblshsp2.chm ?? ?????? \Mssql7\Books ??? ???? ????????? ????? ??. ?? ?????? ???? ??????? ??????? ???????? SP2 ?????? "???? ??????? ??????? ????????" ?? ??????? ?????? ?? "??? SQL Server ???????". ?? ???? ????????? ?? "??? SQL Server ???????" ??? ???? ??????? ??????? ???????? SP2. ??? ????? "???? ??????? ??????? ????????" ???? ???? ????? ???????? ??? ???????? ???????:
  • ???? ????? ??????? ??? ????? Tblshsp2.chm.
  • ????? ?????? ??? ??? ??????. ?? ???? ????? ??????? ??? ????????. ??? ????? ???????? ??? ??? ????? \Mssql7\Books\Tblshsp2.chm.
???? ??????? ??????? ???????? SP2 ????? ?? ???? ???? SQL Server ???????? ?? SQL Server 7.0 ?????? ??? ?????????.

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

????? ????????? ????? ???????? ?? SP4 ?? ???:
  • ????? ???? ?????? ????? ????????
  • ??????? ?? ?????? ??????? ????? ????? ???????? ???
  • ??????? ???? ????? ?????? ????? ????? ????????
?????? ?????? ????? ????????
??????? ?? Service Pack 2

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

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

??? ???? ??????, ????? ?????? ??????? ?????? ???????? ???????? ??? ??????? ????????. ??? ??? ??????? ?????? ???????? ???????? ??? ????? ??????? ??? ????? ????? ???????? ?? ??? ??????? ?????? ?? ??? ??????. ??? ????? ??????? ???????? ? ??? ?? ???? repartitioned ???????? ??? ????????? ??????, ??? ????? ???????? ?? ????? ????? ????? ???? ??? ????????? ??? ??? ??? ????? ???????? ?????? ?????? ??? ??????.

?????? ?????? ???? ???????? ???? ??? ??????? ??? ?????? ????? sp_addmergepublication ?????? ??????? ?????? ?????? @ keep_partition_changes ??????? ??? true.

??????? ?? ?????? ??????? ?????? ??? ?? ???? ??????
??????? ?? Service Pack 2

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

????? ????? ???? "???? ????" ?????? ??? ???? ????? ????? ????? MSmerge_contents. ???? SQL Server 7.0 ?????? ????? ?????? SP4 ???? ???? ??? ????? ?? ??? ??????? ????? ??????? ??? ??? ??? ?????? ???? ????? ??????? ???? ????? ??? ????? ??????? ????????? ?? ???????.

?? ????????? ??????? ?? SP2 ? ???? ???? ????? ??? ???? ????? ????? ????? MSmerge_contents ? ????? ????? ???? ?????? ?? MSmerge_contents ????? ?????? ??? ????? ?? ?????? ??????? ???? ?? ?????????. ????? ????? ????? ????? ????? ??????? ??? ???? ??? ???? MSmerge_contents ??? ????? ???. ??? ?????? ????? ?????? ??? ????? ???? ??????.

?? SP2 ?? ????????? ?????? ???? ????? .bcp ???? ?? ??????. ???? ????? ???? ?? ????? ???? ??? ??? ?????? ??? ??? ??? ????????? ??? ???????? ???? ??? ?????. ????? ????? ????? ????? ?????? ?? "???? ???" ??? ????? ?????? ??? ?????????.

??? ????? ??? ??????? ??? ??? ??? ????????? ?? ???? ?? ????? ??????? ??? ??? ?????? MSmerge_contents ??? ?????? ??? ????? ??? ????? ????? ??????? ????? ???? ????? ??? ????? ??????? ???????.

??? ???? ??????? ????? ??? ????? ????? ???????? ????? ???????? ????? Order Details ?? ??? ????? ??????? ??? ??????? ??? ?? ????? Northwest. ??? ????? ?????? ?? ??? ?????? ?? ???? MSmerge_contents ??? ????? ??? ???????? ???????? ?? ????? ???? ?? ?????? ?? ???????? ???? ??? ??? ??? ????? ?????. ???? ???? ?????? ?? ?????? MSMerge_contents ?? ????????? ??????? ??????? SP2 ? ????? ????? ???? ?? ?????.

??? ?????? ??????? ?????
??????? ?? Service Pack 2

????? ?????? sp_mergecleanupmetadata ??????? ???? ????????? ????? ?????? ??????? ?? ????? ?????? MSmerge_contents ? MSmerge_tombstone. ??? ????? ?? ??? ???? ????? ??? ??????? ???? ??? ?????, ?? ???? ????? ?????? ??????? ????? ???? ???. ???? ??? ??????? ????? ????? ?? ???? ????? ??? ??? ??????? ?? Publisher ? ?????????.

????? ??? ????? ??????? sp_mergecleanupmetadata ????? ??? ?????? ????? ??????? ??????? ?????? ??? ???? ?????????? ??????? ?? ????????? ???? ????? ??? ?????? ??????? ??????? ?? Publisher ?? ???????? MSmerge_contents ? MSmerge_tombstone:
  • ??? ??? ????? ?????????? ???????.
  • ??? ????? ????????? ??? ???????.
  • ?? ??? ????? ???? ??????? ?????.
?? ???? SQL Server 7.0 ??????? ?????????? ????? ?? ??????.

??? ?? ???? ??? ?? ??????? ??? ???????. ??? ????? ??? ??????? ?????? ??? ???? ???????? ?? ????????? ?? Publisher ????? ??????? ???????? ??????? ???? ??? ?? ??? ???. ????? ????? ???? ?? ??? ???? ????????? ???????? ?? ???? ??????? ??? ?? ???? ????? ??? ????? ??? ??????? ??????. ??? ????? ??? ???? ????? ?????? ????? ??? ??????? ?????? ??????.

?? ??????? ?? ??? ???????? ????? ????????. ??? ??? ??????? ????? ???? ?????????? ?? ?? republisher ??????.

?????????? @ reinitialize_subscriber ????? ??????? ??????? sp_mergecleanupmetadata ????? ??? true ?? ??? ??? ????? ??? ???? ?????????? ?????? ???????. ??? ??? ?????? @ reinitialize_subscriber ??????? ??? false ? ?????????? ?? ??? ??? ????? ??? ???????. ??? ???? ????? ??????? ??? false ? ???? ???? ??? ????? ??? ?????????? reinitialized ??? ?????? ?? ?????? ???????? ?? Publisher ? ?????????.

??? ??? ???? ?? ????? ????? sp_mergecleanupmetadata ????? ??? ??? ????? ?????????? ??????? ???? ??????? ???????:
  1. ?????? ???? ?????????.
  2. ????? ???? ?????? ????? ????? ?????? ????? ? ??????.
  3. ????? ????? ??? ??????? ?? ??? ???????? ??????? ?? ?????? ?????? ????? "???? ???" ???????? ???? ??? ????? - ?????? ?? ????? ?? ?? ?????.
  4. ????? ????? ?????? ?????? sp_mergecleanupmetadata. ??? ????? ??????? ??????, ????? ?????? ?????????? ????? ????? ?????? ????? ? ?????????? ??? ????.
???????? ??? ??????? ?????? ?????? "?" ?? ????????? ??? ????? SQL Server 7.0 ?????? ????? ?????? SP4. ???? ??? ?????? ?????? sysadmin ??????? ??? ??????? ??????. ????? ??? ?????? ??????? ??? ????? ????? ?????? ?????? sp_mergecleanupmetadata. ??? ??????? ?????? ??? ?????? ????? ??? ???? ?? ????? ?????? MSmerge_contents ? MSmerge_tombstone.

?????? ?? ???? @ tablename ??????? ????? ???? ??? ??????? ??? ???? ????. ?? ????? ??? ???? ??? ???? ??? ?????? 2 ? 3.

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

???? SQL Server 7.0 ?????? ????? ?????? SP4 ?????? ?? ????????? ?????? ????? ????????.
???? ????? ???????? ???????
??????? ?? Service Pack 2

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

??? ????? ?????? ??????? ??????? ??? TRUE, ?? ???? ?????????? ????? ????? ?? ???????? ?? ????? ????????. ?????? ???? ????? ????? ????? ?? ???????? ????? ????? ????? ??????? ???????:
????? ????/????? ??? ????? ???????? ????? ????? ??????? ??????? ????? ????? ????????.
??? ???? ???? ????? ?????? ??? ?? ????? ?????? ??????? ??????? ??? TRUE ????? ????? ???? ?????? ???????? ? ?? ???? ???? ?? ????? nonclustered.

?? ???? ????? ?????? ??????? ??????? ??????? ??? ????? ???????? ?????????:
  • ???? ????? nonclustered ?????? ??? ??? ????? ???? ?????? ????????.
  • ?? ????? ?????? ??????? ??????? ??? TRUE ????? ????? ??????.
The pending upgrade option should always be set to FALSE, as shown in the following line of code, for any SQL Server 7.0 system that is not interoperating with the future version of SQL Server:
sp_dboption 'database_name', 'pending upgrade', 'FALSE'
The sp_dboption system stored procedure reports the status of the pending upgrade option if the stored procedure is called without parameters or with only the database_name parameter, for example:
sp_dboption 'Northwind'
The DATABASEPROPERTY function supports a new IsPendingUpgrade property that is used to report the status of the pending upgrade database option, for example:
DATABASEPROPERTY(Northwind, IsPendingUpgrade)
The IsPendingUpgrade property returns 0 if the pending upgrade option is FALSE, and returns 1 if the pending upgrade option is TRUE.

???? ??? ??????? sqlservr ??????
??????? ?? Service Pack 2

????? SQL Server 7.0 ?????? ????? ?????? SP2 ???? ?g ???? ??? ????? ?????? ??? ?????? ???????? sqlservr. ??? ???? ??????? ????? ??????? ?????? ??????:
-g memory_to_reserve
????? ??? ?????? ??? ???????? ?? ??????? ????? ?????? ?? ??? ?????? ????? ??????? SQL Server ?? ????? ???? SQL ???? ???? ????? ??????? SQL Server. ??? ?? ???? ????? ???? ????? ??? ????. ????? ??????? ?? ????? ?????? SQL Server ?? ??? ????? ???????, ??? ????? ????? ????? .dll ??????? ?????? OLE DB ???? ??? ?????? ????? ?????? ??????????? ??????? ??????? ??? ???????? ???? ??? ?????? ????? ?? ?????? SQL ????????. ????? ?? ????????? ??? ????? ??????? SQL Server ???? "????? ???????" ?? "??? SQL Server ???????" ?? SQL Server 7.0.

???? ???????? ????? ??? ?????? ?? 128 ???? ????. ??? ?????? ?????? ?????? ?? ????? ??? ???????. ?? ????? ??????? ??? ?????? ?? ????? ????? ??????? ??? ?????? ??????? ??????? ??? ?????? ????? ??????? ???:
  • ?????? ??? SQL Server Edition ??? ?????? ?? SQL Server Standard Edition: 2 ???? ????
  • ?????? ??? SQL Server Enterprise Edition: 3 GB
?? ?????? ??????? ?? ??????? ??????? ??? ?? ??????? ??? ??????.

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

??? ???? ??????? ?????? ?????????? -g ??? ??????? ??????? ?? ?? ????? ????? ??????? ??????? ??? ??? ?? ??? ????? SQL Server:
?????: ??? ????? ??????? ?????? ??????? ?????? ??????? ???????.
???? ????? ????? ??? ??? SQL Server ?? ???? ?????? ????? ????? ?? SQL Server ????? ???? ????? ?? ????? ??????? ??? ????? ????? ????? .dll ??????? ?? ?????? ???????. ?? ??? ??????? ?? ???? ???????? ????? ????? ??????? ????? ?? ??? -g ????? ??? ???????. ???????? ???? ??? ?? ????????? ?????? ????? ??????? ???????? ???? ?????? ?????? ?? ???? ????? ?????. ?? ???? ??? ????? ??? ?? ??????? ?????? ??? ????? ????? ??????? ?????? ????? ?? ??????? ???? ?? ?????? ?????? ?? ????????? ??????? ?? ????????? ??????? ?? ?????? ???????.

????? ?? ???? ??? ??????
??????? ?? Service Pack 1

?? ????????? ??????? ?? SQL Server 7.0 ? MSDE 1.0 ?????? ??? ?????? ??????? ????? ???? ???????? ???????? ???? ???????? ???? ???? ???? ?????? ???????:
  • ?? CURSOR_CLOSE_ON_COMMIT OFF.
  • ???? ?????? ?????.
  • ????? ?????? ??? worktable ????? ??.
?????? ??????? ?? ????????? ??????? ?? SQL Server SP1 ?????? ????? ????? ??? ?????? ??? ??? ????? ???? ?????? ??? ?????? ??? ?????? ??????? ??? ??? ????? ???? ??????? ???????:
  • ?? CURSOR_CLOSE_ON_COMMIT ON.
  • ??? ?????? ??? ???? ???? ???? ??? ??????.
??? ????? ???? ??????? ?? ????? ?????? ?????? SP1 ??? ?????? ?? ??? ?????? ??????.

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

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

????? ?????? "????? ????? SQL Server 7.0 Enterprise Edition ??? ???? ?????? Microsoft: ??????? ???? ?????" ???? ??????? ??????? ???? ??? ?????? ?? "??? SQL Server ???????" ?? SQL Server 7.0. ????? ?? ????????? ??? ??? ?????? ??????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/kb/842192

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

??? ??? ????? ????????? ???? ??? ??????? ?? ?????? ????? ????? (DTS) ??? ???? ??????.
????? ??? ????? ?????? Oracle
??????? ?? Service Pack 1

??? ??????? ????? ????? DTS ????? ??? Oracle, ??? ??? ?????? DTS ?????? ????? ?????? DTS ?????? ????? ???? ???? ?????? ???????? ?????? ???????? ??? ????? ?????? ???????. ??? ?? ???? ??? ?????? ???? ???? ?? ????? ??????? ???? ??????? ???????? ?? ???? ????? ??? ??????? ???? (""). ??? ??? ???? ????? ??? ??????? ???????? ??? ?? ????? ??? ??????? ??? ???? ????? ?????? ???????? ?????? ????? ?? ???? ?????? ????? ??? DTS.

???????? ???? ?????? DTS
??????? ?? Service Pack 1

?? ????? ????? ???? ?????? DTS ?? ????? ?????? ????? ?????????? ???????? ????. ????? ?????? DTS ????? ??? ???? ?????? ?? ?????? ?????? ????? ???????:
  • ?? ????? ????? ???????? ?????? ? ???? ??? ????? ??????? ???????. ? ?? ???? ??? ?????? ?????? ??? ??? ?????? ???? ???? ??????? ??????. ????? ??????? ???? ???? ??? ???? ????? ??????.
  • ???? ????? ??????? ??? ???? ?????? ????? ?????? Script ActiveX ??? ?? ???? ??? ??????.
????? ??? ?????????? ???? ?????? ????? ?????????? ????????. ?? ??? ?????? ?????????? ??? ????? lineage.

????????? ?? ???? ?????? "????? ????"
??????? ?? Service Pack 1

??? ????? ???? DTS ?? ????? ??????? DTS ?? ????? ??????? DTS ???? DTS ??? ????? ????? ?????? ??? ???? ?????? ????? ???? ???? ??? ????? ??? ???????? ??????. ?? ????? ??? ??????? ??????? ?????? ?????? ???????? ???? ???? ??????.

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

????? ????? "????? ?????" ????????
??????? ?? Service Pack 1

?? ????? DTS ????? ?????. ????? ????? ???? ?????? ??????? ???? ???? OLE DB ???????? ??? ??????? ???? ????.

??????? ?????? ???????? ?????? ?? ??????? ?????? ?? Microsoft Visual Basic
??????? ?? Service Pack 1

????? Microsoft ActiveX ?? ????? ???????? ??? DTS ????????? ???????? ?? ??????? ?????? ?? Microsoft Visual Basic Scripting Edition (VBScript) ???? ???? ???????? ???? ????? Visual Basic ?? ?? ????.

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

??? ??? ????? ????? ????? ???? ???? ??? ??????? ?? ?? "?????? ????????" ????? "?" ?????? ???????? .Value ?????? ????? ???? ????. ??? ???? ??????:
  • ??????? ??????? ?????? ???? ??? ???? ??????? x: ????? ?????
    Set DTSGlobalVariables("x").Value =
                       CreateObject("ADO.Connection")
    
  • ????? ??????? ??????? ????? o ??? ???? ??? ???? ???????:
    Set o = DTSGlobalVariables("x")
  • ????? ??????? ??????? ????? o ??? ???? ????? ????? ????? ??? ???? ??? ???? ???????:
    Set o = DTSGlobalVariables("x")
????????? ?? ??? DTS
??????? ?? Service Pack 2 ? Service Pack 3

SQL Server 7.0 ?????? ????? ?????? SP2 ? SQL Server 7.0 SP3 ? SQL Server 2000 ????? ????????? ??? ??????? ??????? ?????? DTS ???? ?????. ??? ??? ???? ??? ??? ?? SQL Server ???? ???? ???? ??? ?????? ????????? ??????? ?????? ??? ??????? ???? ???? ??????.
?? ??? ??????????? ??? ??????
???? ??????????????
SQL Server 7.0 SP1SQL Server 7.0
SQL Server 7.0 SP1
SQL Server 7.0
SQL Server 7.0 SP1
SQL Server 7.0 SP2SQL Server 7.0 SQL
???? 7.0 SP1
SQL Server 7.0 SP2
SQL Server 7.0 SP2
SQL Server 7.0 SP3SQL Server 7.0
SQL Server 7.0 SP1
SQL Server 7.0 SP2
SQL Server 7.0 SP3
SQL Server 7.0 SP4
SQL Server 2000
SQL Server 2000 SP1
SQL Server 2000 SP2
SQL Server 7.0 SP2
SQL Server 7.0 SP3
SQL Server 7.0 SP4
SQL Server 2000
SQL Server 2000 SP1
SQL Server 2000 SP2
SQL Server 7.0 SP4SQL Server 7.0
SQL Server 7.0 SP1
SQL Server 7.0 SP2
SQL Server 7.0 SP3
SQL Server 7.0 SP4
SQL Server 2000
SQL Server 2000 SP1
SQL Server 2000 SP2
SQL Server 7.0 SP2
SQL Server 7.0 SP3
SQL Server 7.0 SP4
SQL Server 2000
SQL Server 2000 SP1
SQL Server 2000 SP2
??????? ???? ?????? ???? ???? SQL
??????? ?? Service Pack 4

?? ????????? ?? SQL Server ???? ?? SQL Server 7.0 ?????? ????? ?????? SP4 DTS ????? ???? ?? ??????? ??? ?????? ???? ????? ??? ?????? ?????? "???? ?????? ????? ?? SQL Server ????" ??? ??? ??? ???? ?????? ???? ?? ?????? ??? ?????? TEMP ???????? ????? ??? ?? ??? ?????? ?? ?????? ?? ???????. ??? ????? ?????? ?? ??? ???? ????? ?? xp_cmdshell ????? ??????? ??????. ??? ????? ?????? ?? ??? ???? ????.

????? ???? ?????????? ?????? ??? ??? ????? ?????? TEMP ?????? ??? ???? ??? ??????? SQL Server ?? SQL ???? ??????? ??? ???? ???? ?? ?????? ??? ??? ??????? ?? ??????? ??????. ??? ???? ??????? C:\TEMP. SP4, ?? ????? DTS ???????? ???? TEMP ?????? ??? ?? ????? ?????? TEMP ????????. ???? ??? ??????? ???? ???? ???? ??? ?????????.

SQL Server 7.0 ? Exchange 5.5

??? ??? ?????? ??????? ?? ?? SQL Server 7.0 ? Microsoft Exchange Server 5.5 ??? ??? ????????? ??? ?? ???? ?????? ??????? ??????? ???? ???? ?? SQL Server. SQL Server ?? ???? ???? ???? ??? ???? SQL Server ?????? ????? ?????? ??????? ??????????? ?? ?????? ?????????? 0.

??????? ????? ????? ?????? ???? ???? ????? ??? ????? ???????? ?? ??? ????? ??? ???? ????? ??????? ??????????? ?????? SQL Server 7.0 ?? ?????? ????? ?????? ????? sp_configure ??? ????? ??????? ???????? ???? ?????? ?????? ??????? ?? SQL Server. ?? ??? ?????? ?????? SQL Server ????? ????? ?????? ??? ??????? ?????? ??????? ??????? ?? ?????? ????? ?????? ???? ?????? sp_configure ??. ????? ?? ???? ???? ????? SQL Server ????? ?? ????? ??????? ??????? ?? ?????? ??????? ??????????? ???? ??????. ????? ??? ?? ???? ????? ???? ?????? ??????? ??????? ????? ?????? SQL Server ??? ????? ?? ??? ?????.

?????? ????? ??????? ???? ????? ???? SQL ?????? ????? ??????? ???? ?????? SQL Server ????? ??????? ???????:
  • ?? ???? ????? ????? ???????? ?????? ?? ?? ??????? ? ?????? SQL Server ??????? ??????? ??? ????? ?????? ?? ??? ?????.
  • ??? ?? ??????? ??????? ???? SQL in-house ? ????? ???????? ??????? ????? ?????? ??????? ????????? ?? ??? ???? SQL.
  • ??? ?? ??????? ??????? ???? SQL ?? ??? ??????, ?? ????? ??? ???? ????? ??????? ?? ????? ?????? ????? ??????? ??? ??????? ??????? SQL Server.
????? ?? ????????? ??? ?????? ??????? SQL Server ?? ????? ?????? ????? SQL Server ???? ???????? "?????? ??????? ???????" ? "?????? ????? ??????" ?? "??? SQL Server ???????" ?? SQL Server 7.0.

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

??????? ?? Service Pack 1

??? ??????? ??????? ?????? ?? "??? SQL Server ???????" ???? ??? ???? ???????. ????? ??????? ??????? ?? SQL Server 7.0 ?????? ????? ?????? SP4 ??? ??????? ???? ????? ??? ??? ???? "???????? ??? SQL Server ???????" ?? ???? ????????? ???? ?? ??????.

?????? ??????? ??????? ???? ?? ?????? ?? "??? SQL Server ???????" ???? ??????? ???????:
  1. ??? ??? Sqlbolfr.exe ?? ?????? ???? ?????? ??? ???? ???? ??? ???? ????????? ????? ??.
  2. ????? Sqlbolfr.exe ???????? ????? Sqlbol.chm.
  3. ??? ??? Sqlbol.chm ???? ??? C:\Mssql7\Books ??????. ????? ??? ??? ??????? ??? ??????? ??? ?????? ?? ?????.

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

??????? ?? Service Pack 2

??? ?????? ????????? ????????? ???? ??? ??????? ?? ?????? ???? ???? ??????.
??????? ?? ????? ?????? DB2 ? Informix
??????? ?? Service Pack 2

????? ?????? ?????? OLE DB ???????? ?? ????? ?????? DB2 ?? Informix ? ?????? Microsoft ???? ?????? ????? ?????? ??? ??????? ?????? ?? ????. ????? ??? ?????? ??????? ????? ???????? ???? ?????? ?????? ????? ODBC Microsoft DB2 "?" ?????? ????? ODBC Informix Intersolv "?" ?? Intersolv OLE DB ????? ?? ODBC "?" Intersolv ???? OLE DB ?? Informix.

??????? ????? ?????? ????? ?????
??????? ?? Service Pack 2

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

???????

???? ???????: 889543 - ????? ??? ??????: 27/?? ?????/1427 - ??????: 1.5
????? ???
  • Microsoft SQL Server 7.0 Service Pack 4
  • Microsoft Data Engine 1.0
????? ??????: 
kbmt kbpubtypekc kbservicepack kbhowto kbinfo KB889543 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????889543

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

 

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