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

????? ???

????? ??? ??????? ?? 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: ?????? ??? ??????? ?????? ??? ??????? ??? SQL Server 7.0 ?????? ????? ?????? Service Pack 4 ???? ?? ??? ????? ?? ??? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:

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

??? ?? ??? ??????? ?? ???? ?????? ???? ??? ??????? ??? ???? ?? ???? ????? ?????? SQL Server 7.0 ?? MSDE 1.0 ? ?????? ?? ??????? ?? ???? ????? ??? SELECT @@ VERSION ?? osql ?? ???? ??????? SQL isql. ???? ?????? ?????? ??????? ??? ????? ????? ???? ??? ????? ?????? ????? @@ VERSION ??? ???? SQL Server 7.0 ? MSDE 1.0: ??? ?? ??? ??????? ?? ????? SQL Server 7.0 ??? ??????? ?? ??? ??? ???????? MSDE 1.0 ????? ?????? ?? ??????? ???? ?? ??????? ?????? ????? @@ ????? ?????? ??????? ???? ?? ??????? ??. ??? ???? ??????? ?? ???? ??????? ?????? ??? ???: ????????? ??????? ???????

??? ????? ??????? ?????? ??? 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 ???????? ???????:

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

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

?? ?????? ??????? 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:

??? ??? ?????? ???????? "??? ??????? ?? ????? ??????" ??? SQL Server ????? ???? ??????? ?????? ????? ??????? ??????: ??? ??? ??????? ?????? 2 (?? ??? BSC) ? 4 (PSC) ?? 8 (?? ??? PEC) ? ????? ?????? ??????? ??? ?????? ?????? ??? 1. ????? ???? ???? ??????? ???? ?????.

recluster SQL Server ? ???? ??????? ???????:

1. ?? ???????? ?????? SQL Server 7.0 ???? ??? ????? ???? ?????? ????? ?????.
2. ??? ??????? ?????? ??????? ????? ????? ?????? SQL Server Enterprise Edition ??????? ?? ???? ??????? ???????? ?? ???? ????????? ???? ???? ???????.

???? ??????? ??????? ??? ???? ????? ??? ???? Windows NT ???? ????? ??? ?????? SQL Server ???? ???? ?????? ?? ???? ????????.

?? ????? ??????? "??? ??????? ?? ????? ??????" . ??? ??? ?????? ???? ??? ??????? ?????? ??? ??????? "????? ???? ?????? ????? ?????" ????? "???? ???????" ???????? ?????? ??????? ?? ????? ??????? ". ??? ??? ?????? ???????? ??? ????? 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 ?????????. ??? ????? ??????????? ?? ??????? ???????:

• Installing SP4 on a server that provides a remote distribution database for merge publications
• Upgrading a merge Publisher that receives new subscriptions to SP4 from the original release of SQL Server 7.0
• Installing SP4 on a merge replication Subscriber
• Running SP4 replication with earlier versions of SQL Server
• Updating Access 2000 (Jet 4.0) merge replication Subscribers

????? 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

??? ?? ??? ??? ?????? ?????? ??? ???? ????? ?????? ?? ???? ?????:?????? ?? ??? ???? ???? ??????? ??????? ??? ???? 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 ?????? ????? ?????? ??????? ???????? ???? ????? ?????? ?? ???? ???????: ???? ????? ????? ????? Sqlredis.exe ??? ????? ?????? ??????? ???? ??? ????? ?? ??? Mdacredist.txt ????? ?? ???? ?????? ???.

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

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

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

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

?? ??? ???????? ?????????? ????? ?????? ???? SQL Server ??? ??? ??????? ?????. ???? ??? ????? ????? ?? Enterprise Edition Desktop ???? ????? ???????? ??? ???? ????????? ?? ???? ????? ?????? "???????" ?? ????? ??????? ????? ?? SQL Server. ??? ?? ????? ?????? ?????? ??? ???? ????????? ?????? ??? SP4 ? ??? ?????? ????? SQL Server ?????? ????? ????? ???????:?????? ?????? ?? 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 ? ?? ????? ????? ????? ???????: ???? ???? ???? ????? ????? ??? ??? 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: ????? 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: 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: The DATABASEPROPERTY function supports a new IsPendingUpgrade property that is used to report the status of the pending upgrade database option, for example: 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. ??? ???? ??????? ????? ??????? ?????? ??????: ????? ??? ?????? ??? ???????? ?? ??????? ????? ?????? ?? ??? ?????? ????? ??????? 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 ?????? ??? ?????:

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

??? ??? ????? ????????? ???? ??? ??????? ?? ?????? ????? ????? (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

??????? ?? 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

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