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

???? ?????? ???? ??????
???? ID: 889543
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ?????? Microsoft SQL Server 7.0 ?? Microsoft ???? ????? (MSDE) 1.0 ?????? ??? 4 (SP4) ??????? ??? SQL Server 7.0 ?? MSDE 1.0 ?? ??? ??????? ?? ??? ?????? ?????? ????? ??? ?? ???? ?? introduces SP4 ?? ???? ??? ????? ???????:
  • ?????? ??? ??????? ?? ?????? ??? 4 ??? ?? ???????
  • ?????? ??? 4 ?? ??????? ?? ??? ?? ??????? ???? ?? ??? ???? ????
  • ?????? ??? 4 ?? ??????? ???? ?? ??? ???? ????
  • ??????? ?? ??? ?? ?????? ??? 4 ??????? ??? ??????????? ???? ?? ??? ???? ????
  • ?????? ?? ???????? ???? ???? ?????? ??? 4 ??? ??? ?? ???????? ?? ????? ???? ??

???? ????

???? ???????

?????

?? ?????? Microsoft SQL Server 7.0 ?????? ??? 4 (SP4) ?? Microsoft ???? ????? (MSDE) 1.0 SP4 SQL Server 7.0 ?? MSDE 1.0 ?? ??? ??????? ?? ??????? ????? ?? ?????? ???? ??? ?? ????? ??? ????? ???:
  • ???? ?????
  • ??????? ?????????? ???? SQL Server ?????????? ??????? ??????? ??osql(SQL Server 7.0 ????)
  • SQL ?????, SQL Server ODBC ??????? ?? ??????? ?? ??? ???? OLE DB ??????? ??????? ??????????? ????? ?? ??????? ???-???????????
SQL Server 7.0 SP4 SQL Server 7.0 ???? ????? ?? MSDE 1.0 ??? ??? ???????? ?? ??? ???? ???? ?? ???? ??? ?????? ??? 4 ????? ????????? ?? SQL Server 7.0 ?? MSDE 1.0 ?? ?? ?? ???????? ?? ?? ?? ???? ??? ?? ?? ?? ?? ??????? ??? ???????? ??????? ????: ??? ?????? ????? ????????? ???? SQL Server 7.0 ??????????? ??????? ??? ??? ?? ?? ?? ????? ????????? ??????????? ??????? ?? ??????? ?? ??? ????? ?? ??? ?? ???????? ???? ?? ?????? ????? ?????? ??? MSDE 1.0 ??? ??? ???????? ?? ???? ???? ??, ?? ??? ???? ?????? ??? ???? ??? ???????? ???? ?? ??? SQL Server 7.0 ?? ??? ????? ??? ?? ?? ??? ??? ???????? ???? ??????? ??????? ??? ???? ??? ???? ??, ?? ???? ???? ?? ?????? ???? ?? ??????? ????? ??? ?? ???????? ?????

SQL Server ??????? ??? ???? ??? ????? ???? ???, ??????? SP4 ?? ??? ????? SQL Server 7.0 ?????? ????? ??????? ????? ???? ?????, SP4 SQL Server ??????? 7.0 ?? MSDE 1.0 ?? ??? ??????? ???? ?? ??? ???? ???? ?? ????, ?? ?? ???? ?? ??? ??? SQL Server 7.0 ?? MSDE 1.0 ??????? ???? ?? ??? ??? ?????? ??? ??? ???? ??? ?????

SQL Server 7.0 SP4 ????? CPU ??? ?? ?????? ?????????? ?? ?????? ???? ????? SQL Server 7.0 ?????? Pacl 3 (SP3) ?? ????? SQL Server 7.0 ?????? ??? ?? ?????-?????? ?????????? ?? ?????? ???? ???

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

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

??? ?? ???? ????????? ?????? ??? ?? ??????? ???? ?? SQL Server 7.0 ??????? ????? ?? MSDE 1.0 ?? ?? ?????? ??, ???? ??????? ?? ?? ?? ??? ???? @@ ??????? ???? ?????osqlSQL ?????? ????????, ??isql. ????? ?????? ??????? ???????? @@ ??????? ???? ?????? ??????? ?? ?? ?? ?? SQL Server 7.0 ?? MSDE 1.0 ?????? ??? ?? ??? ????? ?? ??????? ??:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
@@ ???????SQL ????? ???????
7.00.623??? SQL Server 7.0 ?? MSDE 1.0 ??????
7.00.699??????? ??? ?????? ??? 1 (SP1)
7.00.842??????? ??? ?????? ??? 2 (SP2)
7.00.961??????? ?? ??? SP3
7.00.1063??????? ?? ??? SP4
??? ?? ???? ????????? ??????? 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 ?? ???? ??????? ????? ???, reattach ?????? SQL Server 7.0 ?? MSDE 1.0 ?? ?? ?? SP1, SP2 ?? SP3 ???????????? ???? ?? ???? ????? ?? ???? ??? ??????? ?? ???sp_attach_db, ??sp_detach_dbSQL Server 7.0 ?? ??? ????????????, SQL Server ???????? ?????? ?????? ??? ?? ?? ??????? ?? ?? ??? ??? ?????? ????? re-create ???? ????? ?? ??????? ??? ?? ??????? ??? ??????? ?? ?????? ???? ??? ?? re-create ?? ???? ????msdb???? ??? ??? ??? ?? ???????? ?? ????????, ??????????????????:. ??? ?? ????????? ?? ????? ?? ????????? ???? ???????? ???? ?????

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

?? ?????? ??? ?? ????? ?? ?????? ??? ?????? ???? ???? ??:
  • SP4 CD ??
  • Self-extracting ????? ??? Sql70sp4.exe ??????? ?? ??????? ???? ?? ???? ?? ?? ???
???????? ?? ?????? ???? ???????? ?? ?? ??????? ?? ???? ???? ??? ?? SP4 CD ?? ??????? ?? ?? ??? ????? ?? ??? Sql70sp4.exe self-extracting ????? ?? ????? ????? ???? ???, ????? ????????? ?? SP4 CD ?? ?????? ?? SP4 ??????? ?? ??? ?????

??? ?? SP4 ??????? ????, ???? ????? ????? ?? ???? ???? ??? ????????? ?? ????? ?? ??? ??????? ?? ??????? ?????? ??????????

???:Several ???? ??? ??? ?? ??????? ?? ?????? ??????? ???? ????????? ???? ?? ????? ??????? ??????Microsoft Windows NT Explorer ?? Windows ??? ?????? ??? ???? ??? ?? ?? ?? ?????? ??? ?? ??? ??? ?? ??? ???, ?? Explorer. ?? ?????? ?? ????? ???? ?? ??? ????? ????? ?? ???? ????:
  1. Windows Explorer ?? Windows NT Explorer ??????? ?????
  2. ????? ????????????? ??,??????.
  3. ????? ???????????? ?? ??? ???? ?? ??? ????? ??????? ??????? ??????.

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

??? ?? self-extracting ???????? ????? ????? ??????? ?????? C ?? ??? ???? ???????? ?? ?? ???? ??? ?? ????? ??????? ???? ?? SP4 unpack ???? ?? ??? ????? ????? ?? 231 MB ???? ?????? ???

??? ???? ??? ???? ???????? ?? ?????? C ?? ??? SP4 ??????? ???? ?? ??? ????????? ????? ????? ??, ?? ?? ???? ???????? ?????? ?? ??? SP4 ZIP ????? ??????? ?? ????? ????? ???? ???? ???? ???? ???, ?? ?????? C. ??? ???? ?? ??????? ?? ???? ??? ?? ???? ???????? ?????? ?? ?????? C ?? 43 MB ?? 188 MB ?? ???????? ???

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

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

?? ???? ??? ??????? ?? ??????? ???? ?? ?? C:\70sp4 ??????? ?? ??? ?? Microsoft ???????? ??????? ????? ??????? ?? ????????? ?????? ?????? ??? ??????? ?? ??? ??? ?? \X86 ????????? ??? ?? ?? ??????

?? ??? ?? ??????? ?? ??? ??????? ??????? ??????? ?? ??? ??? ???? ???? ???????, ?? ????????? ???? ?? ?????? ?? ??? ?????? ??? ???? ?????? ???? ("")?

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

SP4 ?? ??????? ???? ?? ??? ?? ??????? ???????? ?? ???? ????? ??? ????? ?????? ???, ??????????? ???? ???? ??? ?? ????? SQL Server 7.0 ?? ?????? ??:
  • ??????? ????? ???????????:?? ??? ??? ???????? ???? ???? ?? ???? ??????? ?????????? ?? MSDE 1.0 ?? SQL Server 7.0 ?? ???? ?? ??????? ?? ???? ???? ??? ?? ?????????? ??? ?? ??????? ??????? ??? ???
  • ??????? ???? ??????? ???????????:????? ?? ??? ??? ???????? ?? ???? ???? ??:
    • SQL ?????, SQL Server ODBC ??????? ?? ??????? ?? ??? ???? OLE DB ??????? ??????? ??????????? ????? ?? ??????? ???-??????????? (?? SQL Server 7.0 ?? MSDE 1.0)?
    • SQL ????? ?????????? ??????? ?? (SQL Server 7.0 ????) bcp ???? ??????? ??????? ???????????
  • ??????? ???????????? ??????:SQL Server 7.0 ?? failover ??????? ??? ???????? ???? ??? ?? ?? ??? ??? ???????? ?? ???? ???? ???
  • ????????? ????? ???????????:??? ?? ???? ??????????? ?? ???????? ?? ??? ?? ?? ?? ?? ?? ??????? SQL Server 7.0 ??? ??? ???????? ?? ???? ???? ???
???????? ??????? ??? ?? ??? ???? ??? ???????? ????

???:?????? ??? ?? ??????? ???? ??? SQL ????? ??? ?? ?? ?? ???????? ?? ??? ??? ???? ???? ?? ??? ???? ??? ???? ?????

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

SP4 ????? ????????? ????????? topologies ??? ?????? ??? ?? ????? ??? ?? ?? ?????????? ??????? ?? ??? ?? ??? ?? ?? ?????????? ??????? ?? ???????? ???? ???? ??????? ????????? topologies ??? ????? ???? ??? ?? ?????????? 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 ??????? ???? ?? ???? ????????? ???? ?? ???????????? ?? ??????? ?? ????? ???? ????????? ??? ?? ?? ????? ????????? ?? ??? ?? ?? ?????????? ???? ??????? ?? ??????? ?? ?????? ??? ??????? ????????? topologies ??? ????? ???? ?? ??? SP4 ?? ???? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ??????????????? ??????? ?? ??????? ?? ??? ??.
??????? ?? ?????? ?? ???????? ??????? ????? ?? ??? ????? ?? ??? ??
?? Windows NT ????? ??? ??? ??? ?? ?? ?? ???? ?????????? ?? SP4 ?? ???????? ??? ?? ??????? ???? ?? ??? Microsoft ???????? ??????? ????? ?? ????? ?? ???? ???? Smssql.sms ????? ??? ????? ??????? ????? ?? ???????? ??? ?? ????? ???????? ??????? ????? ??? ??? SQL Server ?????? ??? ??? ??? ???, SQL Server ????? ?? ???? ??? ?????? ???? ?? ???????? ??????? ????? ??? ??? ???????? ?? ??????? ????? Unattspsms.bat ????? ?? ?? ???????? ?? ???????? ?????? ?? ??? ????? ?? ?? ?? ????? ?? ??????? ??????? ???? ?? ??? ????? ??????????

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

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

??? precaution ?? ??? ??? ????? ???? ??? SQL Server ???????? ????? ????? ????????,????, ??msdb???????? ?????? ??? ?? ??????? ???? ??????? ?????????? ???????, ?????????, ??? ????? ??? ?? ?????????? ??????? ?? ??? ?? ?? ????? ?????????????, ??msdb???????? ??????? ?????? ??? ?? ??????? ???? ????????,msdb, ?????????????? ?? ???? ?????? SQL Server 7.0 ?? ?????-SP4 ????????? ?? ??? ????? ??? ?? ????? ?????? ??? ??? SQL ?? ???????????? ???? ?? ??? ?? SP4 ???? Server 7.0?

?????? SP4 ???? ????????? topologies ?? ????? ??? ?? ?????????? ??????? ??? ?????? ???? ????? ?? prudent ???? ?????????? ??????? ?? ????? ?? ??? ?? ???

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

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

You can skip this step if the following conditions are true:
  • Theautogrowoption is on for both the??????, ??msdbdatabases in the SQL Server or MSDE system on which you apply SP4.
  • The disk drive that contains these databases has at least 500 KB of free space available for each database that can autogrow.
In SQL Server 7.0, you can verify that the system databases have sufficient free space. To do this, connect to SQL Server from SQL Server Enterprise Manager, right-click the icon for the database, and then click???. ?????? ???? ??Automatically grow file??? ????? ????? ??? To verify this in MSDE, issue the following SQL statements:
  • sp_helpdb master
  • sp_helpdb msdb
In the output of these statements, verify that the growth column is not 0.

???autogrowoption is not on for either the????????msdbdatabase, the databases that cannot autogrow must have at least 500 KB of free space. To verify this, run thesp_spaceusedsystem stored procedure in the context of the??????, ??msdb???????? If the unallocated space figure in either database is less than 500 KB, increase the size of the database. To do this, follow the instructions in the "Expanding the Database" topic in SQL Server Books Online for SQL Server 7.0.

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

????? ???? ???? failover ??????????? clustering ???? ?? ????

??????? ???? ?? ???? ??????? ?? ??? SP4 SQL Server 7.0 ??????????? ??????? ?? ??? ?? ????? ??????? ???, ????????? ???? ?? Microsoft ?????? ?????? Coordinator (MSDTC) ??? ???? ??? ?? ??? ?? MSDTC ???? ??????? ???? ??? ?? ?? ?????? ?????? ???

??? ???? ?????? ?? ??? ???? ?????? ??, ?? ?????? ??? 4 ????? ????????? ???????? MSDTC ??? ????? ?????? ?? ???? ?? ?????? ?? ?? ???? ?? ??? ????? ???? ?? ?? ????? ??? ?? ?????? ???? ?? ??? ??? ?????????? ???? ??? ?? ??? ?? MSDTC ???? ??????? ???? ?? ??? ?? ?? ?? ?????? ??? ????? ??? SQL Server ??????????? ??????? ?? ????? ??????????? ??? ?? ??? ??, ??? ???? ????? unclustered ???? ?? ???? ???? ??????? ?? ??? SP4 ???? ?? ???? ???? ???? ???? ?? ?? SQL Server uncluster, ????????? ???? ?? ??? ???? ??????? ?????? ????? ???? SQL Server ??????? ???????? ??? ?? ???? ?? ?? ?????? ???? ?? ??? ??????? ?????????? ?? ????? ????:
  • SQL ??????? ?? ???
  • SQL IP ???
  • SQL ?????
  • SQL ????? ?????
  • SQL VServer
???? ?? ?????????? ??? ?? ?? ???????????? ?? ???? ??? ?????? ?????? ??? ?? ??????? ???? ?? ??? ??????? ?? ??????? ????? ?????? INF ???????? Microsoft ????? ???? ???????? SQL ??????? ??? ?? ??, ??? ?? ?????? ?? ????? INF ???????? ?????? ??????? ??? ???? ???, ???? ??????? ??? ??? ?? ?? ???? ?? ??? ???? ???????? ??????????? ???? ??? ??? ???? ??????? ??? ???, ??? ??? ??????? ??????? ??? ?????? ???? ???, ?? ??????? ??? ?? ???????? ???????????? ?? ??????? ??????? ??? SP4 ?? ??????? ???? ?? ??? ??? ???? ????

SQL ????? uncluster, ?? ????? ?? ???? ????:
  1. ?????SQL Server 7.0???? ?????????, ????? ?????????? ??????? ???????.
  2. ?? ???? ??? ???, ?? ???? ??? SQL Server ??????????? ??????? CD ?????, ?? ?? ??????? ?????? ????????? ??? ???? ???? ????????? ?? ???? ?????
?????? SQL Server clustered ???? ??? ?? Windows NT ?? Windows 2000 ??????? ?? ??? ????? ?? ????? ????? ?? ???? ????? ????????? ???? ?? ??? SQL ????? ?????? ??? ?? ?????? ?????? ??????? ???????? ?? ??????? ???

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

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

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

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

???? ???? ?? ?? ??????? ?? ??? SP4 ?? ???? ???? ?? ??? SP4 ????? ????????? ????? ???, ?? ???? ????? ?????? ?? ?????????:
  • Microsoft ???, MSDTC, MSSQLServer, MSSQLServerOLAPService ?? SQLServerAgent ??????
  • Microsoft ????????? ?????, INF ???????? ????? ?? Microsoft COM ????????? Integrator (COMTI)
  • ??? ????????? ???? ?? ???????? ???? ????? ??
??? ?? ?? Windows NT ??????? ??? SP4 ??????? ?? ??? ???, ?? ????????? ???? ?? ??? ??????? ?? ??? ????? ?? ?? ????????? ?? ?????? ???? ???

?? ??? SQL ????? ???? ??????? ??? ?? ?? ??? ??? ??? ???? ?? ???, ????? ????? ??? ???? ?? ?? SQL ????? ???? ??????? ????? ?? ????-????? ????, ?? ???? ??? ????? ????exit.

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

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

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

?? ?? Setup.bat ??? ????? ???, ??InstallShield????? ????? ????? ?? ?? ???????, ???? ?? SQL ????? ??????? ?? Windows NT ?????????? ?? ????? ???? ?? ??? ????? ????? ??? ?? SQL ????? ??????? ????? ???, ?? ?? ????? ????????? ?? ??? ??????? ?? ??? ?????? ???? ????SA????? ????? ??? ?? Windows NT ??????? ????? ???, ?? ???? ?????? ????? ????????? ????? ??? ?? ?? ?? ????? ?? ?? Windows ????? ???? ?? ????? ?? Windows ?? ??? ?? ???sysadminSQL ????? ?? ?? ???????? MSDE ?? ?????? ?? ??????? ????? ????

????? ???? ???, ????? ????????? ?? ?????? SQL ????? ?? MSDE ??????? ?? ???? ??? ???????? ????? ????????? ?? ?? ???????? ?????? ???????????? ?? ?????? ???? ?? ??? ?? .SQL ????????? ????? ????? ???

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

????? ????????? ?? ??? ?????? ???? ?? ?? .SQL ????? ?? ??? SQL Server 7.0 ?? MSDE 1.0 scripts ?? ?????? ?????? ???????? ????????????, ????????? ???? ?? ??? ????????????? ?????? ?? ???? ?? ??????? ?? ????? ??????? ??? ?? ??? ??? ????? ??????? ?? ??? ????? ?????SA????? ????? ?? ???? ???????????? ?? ??? ??? ????? ??????? ?? ??? ?? ?????? ??? ??? ?? ??????? ??????? ?????? ?? ?? ???? ?? ??? ?? ???? ??SA????? ????? ?? ???? ??????SA????? ??????? ????? SQL ????? ?? MSDE ??????? ???????????? ?? ???????????? ???? ????? ?? ??? ?????? ????? ??? ???? ?????? ?? ??????? ???? ?? ???, ???? ?? ???????? ????? ???SA??????? ?? Windows NT ?????????? ?? ????? ????? ???????? ??? ??,?????????? ???????? ????? ??????? ???????? ??????? ?? ??? ????? ????? ????? ????? ????? ??????? ?? ????? ???? ??:
  • ???????? ??? ??, Microsoft Windows 95, Microsoft Windows 98, ?? Microsoft Windows Millennium ???????, ??? ??? ???????? ???????????? ???????? ????? ??? ??????? ??? ?? ????? ???? ??? ??????? ??? ??? ???? ?????????? ??? ?? ????? ???????? ???????? ?? ??????? ??? ???, ????? ????? ?? ?????? ???? ?? ??? ??? ??????? ????????? ????SA????? ????? ??? ?? ??? ??????? ????????? ??, ?? ????? ????????? ?? ????? ??SA????? ???????? ??? ?? ??????? ????? ??, ?? ????? ????????? ?? ???? ??????? ????????? ???? ?? ?????? ???? ?? ?? ???? ????
  • ???????? ??? ??, Windows NT 4.0 ?? Microsoft Windows 2000 ??? ??? ???????? ?? ????? ????????? ????? Windows NT ???????? ?????????? ??? ?? ??? ??????? ??? ?? ????? ???? ?? ??? ?? Windows NT ?????????? ??? ?? ???????? ?? ??????? ???? ?? ??? ????? ????? ?? ????? ?? ???? ??? ???SA????? ??????? ????? ???? ???
?????????? ??? ?? ?? ??? ??????? ????????? ???? ?? ????SA????? ?? ???, ????????? ???? ?? ?? ?????? ????????? ???????? ?? ???? ?????? ?????? ?? ???, ??? ?? ?? Windows 2000-?????? ???????? ?? SQL Server ??? ??? ??? ?? Windows NT ?????????? ??? ??? ????? ?? ??????? ???, SQL ????? ??????? ?? ????? ???? ???? ?????? ????????? ?????? ???? ?? ???? ?? ?? ?? ?? Windows NT ?????????? ?? ????? ???? ?? ??? ???????? ???? ??? ???? ??? ??, ??? ?? ?????SA????? ???????, ????????? ?? ?????? ??????? ?? ????? ???? ???? ???????????? ??????????? ?????? ???? ?? ???? ?? ?? ?? ?? ?? ??????? ?? ????? ???? ?? ??? ???????? ???? ??? ????

????? ????????? ?? ??? ?? ????? ???? ??, ?? ???????? Temp ??????? ??? Sqlsp.log ????? ??? ????????? ???? ?? ?? ??????? ???? ???

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

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

When the Setup program finishes, you may be prompted to restart the system. After you restart the system, or after the Setup program finishes without requesting a restart, use the Services tool in Control Panel to make sure that the following services are running:
  • Microsoft ?????
  • MSDTC
  • MSSQLServer
  • MSSQLServerOLAPService
  • SQLServerAgent
Back up the upgraded??????, ??msdb????????

Recluster a cluster configuration

The following applies only to the failover clustering configuration.

If you have applied SP4 in a Windows NT cluster configuration, recluster SQL Server. Before reclustering, you must apply SP4 to all instances of SQL Server 7.0 that are included in the cluster.

???????????? ???, ????, ?? ????? ?? ????????? ?? ??????? ???? ?? ??? ????? ????? ??? ???? ???????, ??? ?? ????????? ?? ??? ??? ?? ??????? ???? ??? ?? ????? ???????? ??????? ?? ???? ???.. ?????, ????????? ???? ?? ?? ?? ????? ?? ??????????? ???? ???? ???.. ?????? ??????? ?? ???, ????????? ?? ??????? ???? ?? ???? ???? ??? ?? ???.. ???, ??? ??? ?????? ??????? ???? ?? ?? ?? ????????? ?? ???????????? ?? ???? ???.. ????????? ?? ??? ?? ???? ?? ???????????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
322756??? ?? ???? ?? Windows ??? ????????? ?? ???????????? ???? ????


If you removed Message Queuing dependencies on SQL Server, run Registry Editor to modify the following registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSMQ\Parameters\MachineCache\MQS
????? (??) BSC ??? 2 ??, ??? (?? PSC) 4 ?? (??? PEC), 8 ??????? ??? ?? ??????? ?? 1 ?? ??? ??? ?????? ??????, ????? ?? ?????????? ?????? ?? ??? ?? ???? ????

SQL ????? recluster, ?? ????? ?? ???? ????:
  1. ?????SQL Server 7.0???? ?????????, ????? ?????????? ??????? ???????.
  2. ?? ?? ??????? ?????? ??? ???, ???? ??? SQL Server ??????????? ??????? CD ?? CD ?????? ??? ????? ??, ?? ?? ???????? ????????? ???? ?? ?? ????????? ?? ???? ?????
?? ??? ????? ?? Windows NT ??????? ?????? ??????? ??? ????? ???? ????? ??? ?? SQL ????? ?? ?????? ????? ????? ?? ???? ?????

????? INF ???????? ????????? ????? ??
HKEY_LOCAL_MACHINE\Software\Microsoft\MSMQ\Parameters\MachineCache\MQS
. ??? ?? ?????? ??????? ??????? ?? ????? ???? ?? ???? ?? ????? ?? ??? ??? ???? ??, ????????? ????? ?? ??? ??? ?? ???????????? ???? ?? ??? ????????? ?????? ?? ?????? ??? ?? ?????? ?? SQL Server ???????? ?? ?????? ?????? ?????????? ??? ???? ??????????? ??????????? ?????????????, ?????????? ?? ???????????? ???? ?? ??? ??????? ?????????? ?? ????? ????? ??? ??? ????? INF ???????? ?????? SQL ????? ?? SQL ??????? ??? ?? ?????????? ???? ?? ????, ?????????? ?? ???????????? ???? ?? ??? ??????? ?????????? ?? ????? ????? ???? ?? ???? ??????? ??? ??? ??????? ???? ???? ?? ?????????? ?????????????? ??????????? ????? ???????? ??? ?? IP ??? ???????? ?? ???? ??? ??? ??????? ??????? ?????????? ??????????? ????? ?????????? ???, ?????? ?????? ????? ?? ?????? ?????? INF ???????? ?????

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

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

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

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

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

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

???? ?????????, ??? ????? ??????? ???? ????? ?????? ?? ?????? ?? ??? ????? ???? ???? ??? ??????????, ????? ??????? ??? ??? ???? ????????? ???????? ????? ???????? ??????? ?? ??? ??? ?? ?? ???????? ??? ??? ??, ?? ?? ?? ???? ???? ????????? ???? ?? ??? ???? ?????? ????? ??????? ????? ?????? ?????? centralize ?????? ???

?? ????? ???? ??????????? ???????? ??? ??? ????? ??? ???????? ???? ??? ????? ???? ?? ???? ??? ?????, ????????? ????????? ????? SQL Server 7.0 ?? ???? ???? ?????? ??? ?? ??? ??????? ??? ??? ??? ?? SP4 ?? ??? ?????????? ????????? ??? ?????????? ??????? ?? ????? ???????? ??? ????? ???:
???? ?????? ????? ??????? ???? ????????? ?? ??? ?????? ????? ?? ?? ???? ????? ?? SP4 ??????? ?? ??? ??
SP4 ???? ?? ??? ??? ????? ?????? ???? ?? ?? ????? ?? ????????? ?? ???? ???? ?? ??? ???? ?????? ????? ??????? ??? ???, ??? ?? ???? ????????? ??????? SP4 ???? ?? ??? ?? ????? ??????? ?? ????? ???? ?? ?? ???????? ?? ???????? ???? ????? ????????? ???? ?? ?? ??????? ???? ????????? ????? ?? ?? ??? ???? ?? ???? (??????) ??????? ?? ?????? ??????? ?? ???? ???????? ?? ????????? ????? ??? ?? ???????? ???? ???

??????? SP4 ???? ?? ??? ?? ??????? SQL Server 7.0 ?? ??? ?????? ?? ????? ???? ???? ???? ???????? ?? ??? ??
???? ?? ??? ??? ???? SQL Server 7.0 ??????? ???? ?? ??? ?????? ??????? ?? ???? ????? ?? ????????? Subscribers, ?? ?????? ??????-70Subscribers???????? ???????? ????? ????? ???? ?? ??? ???????? ?????????

?? ?? ?? ???? ???, ??? ?? ?? SQL Server 7.0 ?? ????????? ????????????? ???? Subscribers ?????? ???? ?? ??? ???-?? ??? ???? ??? ???? ??? ?? ???

??? ??? ??????????? SQL ????? ?? ??? ??????? ??? ??? ?? ?? ????????? ????????????? ???? ?? ?? ??????? ??? ??, ?? ??????????? ?? ???? ?? ???????? ???? ?? ???? ???? ?? ??? ????? ???? ?? ??? ??? ???? ??? ???????, ??? ??????? ????? ?? ?? ?? ?? ?? ???: ????, ?? ??? ??????? reinitialized ???? ?????, ???????? ?????? ??? ??????? ?????? ???????? ?? ????? ???? ?? ???? ??????????? SP4 ???? ?? ??? ???????? ???? ?? ??? ??? ??? ?? ?? ????????? ???? ????? ???, ?? ?? ??? ???? ???????? ?? ?? confident ?? ??? Subscribers SP4 ???? ?? ??? ???????? ??? ????

???? ?? ????????? ??????????? ?? SP4 ??????? ?? ??? ??
SP4 ???? ?? ??? ??? SQL Server ???? ????????? ??????????? ????????, ??? ?????? ?? ???????? ???????? ???? ?????? ???? ????????? ??????? SP4 ???? ?? ???? ?? ???? ???????? ?? ????? ?? ??????? ???? ????????? ??????????? ?? ?? ??? ???? ?? ???? (Pull) ??????? ?? ?????? ??????? optimizes ??? ?? ??? ?????? ?????-???????-??????????? ????????? ???? ?? ????? ???? accomplished ??????? ???????????? ??????? ?? ??????? ?? ??? ??????

SQL ????? ?? ????? ????????? ?? ??? SP4 ????????? ?? ??? ??
?? SP4 SQL Server 6.0 ?? ??? ??? ???? ?? ?? SQL Server 6.5 ??????? ?? Subscribers ????? SQL Server 7.0 ?? ??? ??????? ?? ????? ????????? ?? ??? ??? ???? ?? ?? ?? ????? ?? ????? ?? ????? ???? ???? ????

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

??????? ?? ??? SP4 ??????? ??? redistributing

SQL Server 7.0 ?? MSDE 1.0 ?? ??? SP4 self-extracting ?????, Sqlredis.exe ?? Mdacredist.txt ????? ?? ??????? ????? ??? ???????? ??? ??, ?? Sqlredis.exe ????????? ??, ?? ?? ?????:
  1. Sqlredis.exe ???? Mdac_typ.exe ????? ?? Microsoft ???? ?????? ????? (MDAC) 2.1 SP2. ?? MDAC 2.1 SP2 ??? ??? ?? SQL ????? ?? MSDE ??????? ??????????? ??? SQL Server 7.0 ?? MSDE 1.0 ?? ??? SP1 ?? ??? ????? ?? ?? ?? ??????? ????????
  2. ??????? ?? ??? SP4 ?? ?? ??????? ?? ??? Sqlredis.exe SQL ????? ?? MSDE ??????? ??????????? ????? ?? ??? ???? ???
  3. Sqlredis.exe replaces the Mswstr10.dll, Mswdat10.dll, Oleaut32.dll, Olepro32.dll, and Stdole2.tlb files.
If you want to install only the Database Components SP4 client connectivity components, type the following command at a command prompt:
sqlredis.exe /C:"setupre.exe MDAC=0 -s -SMS"
You can redistribute the Sqlredis.exe file under the same terms and conditions that are listed in the Mdacredist.txt file that accompanies this service pack.

Documentation notes

This section discusses issues that affect sites running SP4 but are not caused by fixes that are contained in the service pack.

Changes in behavior that are introduced by fixes are documented in the Microsoft Knowledge Base article for each fix.SQL Server 7.0 ?????? ??? 4 ??? ????? ??????? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
313980???? SQL Server 7.0 ?????? ????? ?? ?????? ??????? ?? ????

Upgrading client-only computers after you install SP4

???-???, ???????????? ?? ???? ???? SQL ????? ??????? ??? ???????? ?? ???????? ??? ???, ?? ?????? ????, ??????????, ?? ??????? ????? ?? ???????? ??????? ?? ???????? ?? SQL Server CD ?? ????? ????????? ?? ??? ??? ??????? ????? ?? ???????? ?? ???? ?? ?? SP4 ???? ?? ??? ???????? ???, ??? SQL Server ????? ????????? ???? ?? ???? ?? ?? ???? ????? ?????? ????? ??????? ???? ??:
?? ?????? (7.00.623) ?? ???? ???? (7.00.1063) ??????? ?? ?? ?? ???? ??????? ?? ??????? ???? ?? ???? ??? ?????? ??????? ?? ??????? ???? ?????
????? ?? ??? ????, ??????????, ?? ??????? ????? ?? ???????? ??????? SP4 ??????? ??? ?? ??? ?? ?? ??????? ???????? ?? ???, ????? ????? ?? ???? ????:
  1. ??????? ???????? ?? SQL Server 7.0 ?? ???? ??? CD ?? bcp.exe ????? ?? ????????? ?????? ?? SP4 ?? ?? ??????? Bcp.exe C:\Mssql7\Binn ?????????? ??? ???????? ?? ???? ???
  2. ????? ????????? ?? ????? ??? ??????? ???? ?? ??? ???? SQL Server 7.0 CD ?? ??????
  3. SP4 ???? ?? ??? ???????? ?? ??? SQL Server ??????? ??? ???????? ???? ?? ??? ??????? ??? ?????? ??? 4 ????? ????????? ??????
???:???? ?? ????? ?? ??????????? ??????? ?? ??? ?? ??????? ?? ????????, ?? ??? ???? ??? ??????? ????? ??????? ?????? ?????? ??? ???? ???? ?? ??????????? SQL ????? ??????? ????? ??????? (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 ???? ?? ???? ??? ???? ??????? ?? ??? ???????????? ?? ??? SP4 ??????? ??? redistributing????

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

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

??? ?? ?? ?? ??????? ?? ???? ??? ???? ??????? ?? ???? ??????? ?? ??? SP4 ?? ??? ?????? ???? ?? ??? ?? ?? ??????? ????? ???????? ????? ??????? ?? ??? ???? SQL ????? ??????? ?? ???????? ???? ?? ?????? ??, ?? ?????? ??? 4 ????? ????????? ?? ???? ?? ???? ?? ?? ???? ????? ?????? ????? ??????? ?? ???? ??:
????? ?????? ??? ??? ?????? ?? ?? ?? SQL ????? ??? ?? ???? ??? ????? ???? ???? ?? ??????
??????????, ?? ?????? ????? ????? ???? ?? ?? SP4 ?? ???? ??? ???? ??????? ??? ???? ?? ?? ???? ??? ?? ????? ?? ?? ?? SQL ????? ??????? ?? ??? ?? ?? ???????? ?????? ???

???????, ?? ?? ???? ?? ?? ???? ???? ?????? ?? ???? ????? SQL Server ????? ?? ?? ?? SP4 ????? ?? ???? ???????????? ?? SQL Server ?????? ?????????? ?? ??????? ??? ?? ?? ?? ????? ?? ???? ???????? ?? SP4 ???? ?? ??? ???? ?????? ?? ???? ???? ?? ???????? ?? ?????? ???? ????? ???? SQL Server ?????? ???????? ?? ???????? ?? ????????? ?? ???? ??? ??????? ?? ?????? ???? ?? ????

Windows NT 4.0, ??????? ????? ??????? ?? SP4 ??????? ?? ??? ??

Windows NT 4.0 ???????? ??????, ??????? ????? ??????? ?? SQL Server 7.0 ?? ??? ?????? ??????? ???? ??? SQL Server 7.0 SP1 Windows NT 4.0, ??????? ????? ??????? ?? SQL ????? ?? ??? ?? ??? ?????? ???????? ??? SQL Server 7.0 SP2, SP3 ?? SP4 Windows NT 4.0, ??????? ????? ??????? ?? ?????? ???? ?? ??? ???? ?????

???:??? ?? ???? ??? Windows NT 4.0, ??????? ????? ??????? ??? ??? ???????? ?? SQL Server 7.0 ?? ??????? ???? ?? ??? ????? ?? ?? ??? ???, ?? ???? ????? ????? ?? ???? ????? ??? ?? ???? ?? ?????? SQL ????? ?? ??? ????? 7.0 SP2 ?? SP3, ???? ??? ???? ?? ????? ?? ??????? ?? SP4 ??? ???????? ???? ?? ????

SQL ????? SP4 Windows NT ????? 4.0, ??????? ????? ??????? ?? ??? SQL ????? ??????? ???? ?? ???? ???????? ?? ??????? ????? ??????? SP4 ???? ???? ?? ???????? ??? ?? ?????? ??? ?? ??????? ????? ??????? ?? ??? ??????? ?? ?? Windows NT 4.0 SP4 ????? ?? ??? ?????????? ????? ??????? ?????? ??? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
152734?????? Windows NT 4.0 ?????? ??? ?? ??????? ???? ?? ??? ???? ????
Windows NT 4.0, ??????? ????? ??????? ??? ??? ???????? ?? SQL Server 7.0 ?? SQL Server SP4 ??????? ???? ?? ??? ????? ????? ?? ???? ????:
  1. ????????? ???? ?? Windows NT 4.0 ???, ??????? ????? ??????? SP4 ???? ???? ??? ???
  2. ??????? ????? ??????? ???? ?? ????? ?? ??? ???????? ???? ??? ?????? ????? ?? ????? ?????
  3. System32, ?????? ?? Windows NT 4.0, ??????? ????? ??????? ??? ??? ???????? ?? SQL Server ODBC ??????? ?? ????????? ??????
  4. SQL Server 7.0 CD ?? ???????? ??? ?????, ?? ???? ??? C:\Winnt\System32 ???? ?? ??? CD ?? X86\ODBC ??????? ?? ??????? ?? ????????? ??????? ?? ????? ?? ???
  5. ??????? ????? ??????? ???? ?? ???????? ???? ?? ??? ???????? ???? ??? ?????? ????? ?? ????? ?????
  6. SQL Server 7.0 SQL Server 7.0 CD ?? ????? ?? ??????? ????? ?? ???? ??????? ?? ????? ?? SQL ????? ??????? ???? ???? ?? ???? ??? Windows NT 4.0, ??????? ????? ??????? ??? ??? ???????? ?? ????? ?? ????? ?? ?? SQL ????? ??????? ???? ????? ?? ????? ???? ?? ????????????????? ????????? ????? ????? ???? ?? ?? ?? Windows NT 4.0, ??????? ????? ??????? ??? ??? ???????? ?? SQL ????? ?? ??????? ???? ?? ??? SQL Server CD ?????? ???? ????? ??, ????? ????? ?? ???? ????:
    1. ??? ????????????????? ??? ????? ??..
    2. ???????? ???? ??? ????????? ??????/??????? ??????
    3. ????? ????,??????? ????, ?? ???? ??? ??? ???? ???????? ?? ???? ????? ????? ????????? ?? ????? ??????? ??? SQL Server 7.0 CD ?? ?????:
      X86\Setup\Setupsql.exe
    SQL ????? ????? ????????? ??? ??? ???? ???????? ?? ???? ????? If you want to install a database directly on the computer that is running Windows NT 4.0, Terminal Server Edition, run a full SQL Server setup to install both the client communications components and the database engine. If you only want to give the ability to connect to SQL Server databases on other servers to applications that are running on the same computer with Windows NT 4.0, Terminal Server Edition, only install the client connectivity components. For more information about how to perform a full-server or client-connectivity-only setup, see "Running SQL Server Setup" in SQL Server Books Online for SQL Server 7.0.
  7. Apply SQL Server SP4 by following the instructions in this article. You must install SP4 from the console of the computer that is running Windows NT 4.0, Terminal Server Edition. Also, you must run the Service Pack 4 Setup program (Setup.bat) from the Add/Remove Programs tool in Control Panel.

New Troubleshooting Guide

Database Components SP2 introduced a new version of the "Troubleshooting Guide" section from SQL Server Books Online for SQL Server 7.0. Database Components SP4 also installs this new version of the guide. The new guide expands on the information that is in the original SQL Server Books Online for SQL Server 7.0 with the following new information from the SQL Server support teams:
  • Expanded sets of frequently asked questions (FAQs)
  • Additional information and tips from Product Support Engineers that can help customers become proficient with SQL Server 7.0
Database Components SP4 installs a new file that is named Tblshsp2.chm in the \Mssql7\Books folder on your computer. The SP2 Troubleshooting Guide does not physically replace the Troubleshooting Guide that is in the original version of SQL Server Books Online. You cannot browse from SQL Server Books Online to the SP2 Troubleshooting Guide. You must run the new Troubleshooting Guide separately by using one of the following methods:
  • Double-click the Tblshsp2.chm file.
  • Add a shortcut to your desktop. Then double-click the shortcut. When you add the shortcut, point it to the \Mssql7\Books\Tblshsp2.chm file.
The SP2 Troubleshooting Guide requires that you have SQL Server Books Online for SQL Server 7.0 installed on your computer.

Replication enhancements

Replication enhancements in SP4 include the following:
  • Optimization of replication synchronization
  • Performance enhancements for merge replication snapshots
  • ??????????? ???????? ??????? ???? ???? ?? ??? ?????????????
???????????? ????????? ?????????????
?????? ??? 2 ??? ???????? ????

???? ????????? ?? ????? ?????????????? optimizing ???? ??????????? ???? ?? ??? ?? ??????? ?? ??????? ?? ??????????? ???? ?? ???? ??????? ?? ???? ??????? ???????? ???? ?? ?????? ?? ??????? ?? ???? ??? ??????? ?? ???? ?? ???? ??, ?? ?? ????????????? ???????? ???? ???? ?? ????? ???? ???? ???????, ??????? ?? ???? ??????? ???????? ?? ?? ???????? ??????? ????? ?? ???????? ???

??????? ?? ???????? ??????? ???????? ????, ?????? SQL Server ??????? ?? ?????? ??? ?? ???? ?? ???? ????? ??????????? ?? ????? ?? ??? ????????? ?? ???? ???? ?? ?????????????? ????????? ???? ??? ??, ?? ??? ???????? ??????? ?? ?? ??????? ???? ??????, ?????? ?? ???????, ?? ?? ???????? ???? Subscribers ????????? ???? ????? ?? ????????? ???? ?? ??? ??????? ??????? ???? SQL Server ????? ??? ??? ???????? ?? ???? ?? SQL ????? ???? ??? ???????? ?? ???? ?? ?? generations Subscribers ?????? ?? ?? ?? ????????? ???? ?? ??? ???? ??? ????? ???? ???

?????? ?? ??? ??? ?????? ?????? partitions ?? ???? ?? ???? ?? ?????? territories ?????? ???? ??? ??? ??????? ????????????? ????????? ???? ?? ??? ????? ???? ??? ??, ?? ???? ???? partitioned ?? ?? ???? ??? ??????? ???????? ?? ??? ??????? ?? ??? ???????? ?? ????? ??? ?????? territories ??????? ?? ???? ?????? Subscribers ???? ?? ??? repartitioned ???? ?????? ??, ?? ???? ?????? ?? redistributed ??????? ?? ???? ??????? ?? ???? ???? ??? partitioned ?? ?? ???? ??? ??????? ???? ?? ?? ?? ????????

???:??????? ?? ???? ?? ?? ?? ???? ?? ?????? ?? ???? ????, ???? ?? ??? ?????sp_addmergepublication?????? ???????? ????????? ?? ??? ????keep_partition_changes @???? ?? ??? ????????True.

????????? ???????? ?? ????????? ?? ???? ???? ?? ??? ???????? ?????????????
?????? ??? 2 ??? ???????? ????

???? ????????? ??, ?? ?????? ??? ?? ??????? ?? ????? ???? ?? ??? ????????? ???????? ????? ?? ??? ?? ?? ????????? ?? ????? ???? ??? ???

???????? ?????, ?? ????? ?? ??? ???? ?????? ????? ????? ????? ???????? ?????MSmerge_contents?????? ??? SQL Server 7.0 SP4 ??? ???????? ?? ????? ?????? ????? ??, ?? ????? ?????? ????? ???? ???? ?? ??????? ?? ???? ????????? ????? ???? ???? ?? ?? ?????? ?? ?????? ?? ??????? ??? ???????? ?? ??????? ??? ?? ????????? ????? ???

????????? SP2 ?? ?????? ???, ??? ?? ???? ?????? ????? ????? ?? ??? ????? ???????? ?????MSmerge_contents??????, ?? ????? ????? ?? ??? ?????????MSmerge_contents??? ???????? ?????? ?? ??? ?????? ?????? ?? ???? ?? ????? ???? ??? ??? ??????? ?????? ?? ???? ?? ?????? ?????? ?? ???? ???????MSmerge_contents?????? ????? ???? ?? ??? ??? ?? ??????? ???? ??????????? ?? ?? ????????? ???????? ????? ?? ??? ???

SP2 ?? ??? ?? ?????????, ?? ??? ????? ???? ??? ?? ?? .BCP ???? ???? ??? ???? ??? ?? relate ???????? ?? ?? ?? ???? ?? ?????? ???? ?? ??? ????????? ?? ????????? ???? ?? ??? ??????? ????? ???? ??? ?????, ???? ????? Subscribers ???? ?? ??? ???????? ???? ???? ??? ?? ???????? ??? ?? ????? ???

?? ???????? ???? ??????? ?? ??? ????????? ?? ????? ??? ???? ???? ?? ??? ??????? ??????? ?? ????MSmerge_contents?????? ???? ?????? ???????? ???????? ??????? ??? ?? ???? ????????? ?? ??? ????? ??? ?? ????????? ???? ???? ???

For example, a merge publication includes the Customers, Orders, and Order Details columns, and the publication is filtered to publish only the customers in the Northwest region. When the snapshot is generated, only rows in theMSmerge_contentstable that are relevant to the data that is in the filtered partition of data that is being published are bulk copied. In releases that are earlier than SP2, all rows from theMSMerge_contentstable were bulk copied.

Merge metadata cleanup
Introduced in Service Pack 2

Thesp_mergecleanupmetadata?????? ?????????? ?? ????? ?? ??? ???????? ???????? ????????? ???? ??MSmerge_contents, ??MSmerge_tombstone?????? ????????? ?? ???????? indefinitely ??????? ?? ????, ?????? ????? ?? ???????? ?? ??? ?? ???? ?? ???? ???????? ???????? ?? ????????? ?? ??????? ?? Subscribers ?? ???????? ?? ???? ?? ???? ????? ???? ???? ????

???????????? ?? ???sp_mergecleanupmetadata??????? ?? ???????? ????????? Subscribers ???????? ??? ??????? ?? ???????? ?? ?? ?? ??? ???????? ??????? ?? ??? ????? ????? ??MSmerge_contents, ??MSmerge_tombstone??????:
  • ??????? reinitialization ?? ??? ??????? ?? ??? ????
  • ??????????? ?? ???????? ?? ???? ????
  • ??????? ???????? ???????? ??????? ???
SQL Server 7.0 ?? ??????? ?? ???? ??????? reinitialization ?? ?????? ???? ?????

Reinitialization ??????????? ?? ??????? ???? ?????? ???? ???? ?? ?? ?? ???????? ????????? ????? ???, ??? ???? ?? ????? ???? ?????? ?? ?? ??????????? ???? ???????? ??? ???? ?? ??? ??????? ?? ??? Subscribers ?? ????? ???????? ?????? ??? ????????? ??? ?????? ?? ????? ??? ?? ???? ?? ??? ?????? ?? regenerated ?? ???????? ????????? ?? ????? ?? ???? ??? ?? ???? ???????? ?? ???? ???? ???? ???? ?? ?????? ????, ?? ???????? ????? ?? ??? ??? ????

Reinitialization ???? ???????? ???????? ??? ?? ????????? ????? ?????????? ???????? republisher ?? ??? ??????? ?? ???????? ??? ?? reinitialize ???? ?????

???????? ??? ??,reinitialize_subscriber @?? ????????sp_mergecleanupmetadata???????? ????????? ?? ??? ??? ??True, ?? ??? ??????? reinitialization ?? ??? ??????? ???? ??? ?? ??? ????reinitialize_subscriber @???? ?? ??? ????????FALSE, ??????? reinitialization ?? ??? ??????? ???? ???? ???? ?? ???, ??????? ???????? ??? ????FALSE??????? ?? ??? ?? ??????? reinitialized ?? ?? ??? ' ???? ????? ???, ??? ?? ????? ????? ??????? ????????? ??????? ?? Subscribers ?? ?? ???? ?????????? ?????

??? ?? ????? ????? ???sp_mergecleanupmetadata???????? ????????? ?? reinitialization, ?? ??? ??????? ??? ???? ?? ????? ?? ???? ????:
  1. ??? Subscribers ??????????? ?????
  2. ??????? ?? subscribing ??????? ?? ??? ??? ?????? ?? ????? ???
  3. ??????? ?? ??? ??????????? ???? ?? ??? ???? ????? ????? validates ???? ?? ???? ???? ?????-????? ???????????? ??????????? ?? ????-?????? ???????
  4. ?????sp_mergecleanupmetadata?????? ????????? ???????? ??? ???????? ????????? ???? ??, ?? ??? ?? ?????????? ??????? ?? subscribing ??????? ?? ??? ?? ?????? ?????? ?????? ?? ?????
?? ???????? ????????? ?? ?????, ??????? ?? ??? Subscribers ???? ????? SQL Server 7.0 SP4. ???? ?? ?????sysadmin???? ?? ?? ???????? ????????? ?? ????? ?? ???? ???? ???? ???????? ??? ????, ?????sp_mergecleanupmetadata?????? ????????? ???????? ??? ?? ???????? ????????? cleans ??? ??? ???? ????????MSmerge_contents, ??MSmerge_tombstone?????? ?????????

???:????tablename @???????? ?? ?? ???? ?? ??? ???? ?? ??? ???? ????????? ?????? ????? ??? ?? ?????? ??? 2 ?? 3 ?? ??? ??? ????? ?? ???? ???? ??? ???

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

SQL Server 7.0 SP4 ??????? ????? ??? ?? ???????? introduces ???
?? ??????? ??????
?????? ??? 2 ??? ???????? ????

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

??????? ???????????? ?? TRUE ?? ??? ??, ?????????? ???? ??? ??????????? ?? ????? ??????? ??? ??? ??????????? ?? ????? ????? ?? ?????? ???? ?? ?? ???? ?????????? ?? ?? ????? ?????? ????? ??????? ????:
?????/??????????? ????? ?? ??????? ?? ???????? ????? ????? ????? ?? ?????? ???? ?? ???
However, index creation succeeds if thepending upgradeoption is set to TRUE while a clustered index is being created and if no nonclustered indexes exist.

Index creation may fail, rolling back the whole operation, if the following conditions are true:
  • Nonclustered indexes already exist when the creation of a clustered index is initiated.
  • The????? ??????option is set to TRUE while the index is being created.
The????? ??????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'
Thesp_dboptionsystem stored procedure reports the status of the????? ??????option if the stored procedure is called without parameters or with only thedatabase_name????????, ?????? ?? ???:
sp_dboption 'Northwind'
The DATABASEPROPERTY function supports a newIsPendingUpgradeproperty that is used to report the status of the????? ??????database option, for example:
DATABASEPROPERTY(Northwind, IsPendingUpgrade)
TheIsPendingUpgradeproperty returns 0 if the????? ??????option is FALSE, and returns 1 if the????? ??????option is TRUE.

New sqlservr startup option
?????? ??? 2 ??? ???????? ????

SQL Server 7.0 SP2 ?? ??? ?????????gcommand-line option for thesqlservr?????? ?? ???? For example, you may use the following option:
-g memory_to_reserve
This option specifies the number of MB of memory that SQL Server will leave available for memory allocations in the SQL Server process but outside the SQL Server memory pool. The number that you specify must be an integer. ?????? ??? SQL ????? ?? ????? ???? ??, ???? ?? ??? ?? ??? ?? ???? ????????? ??????? ???????? ?????????. dll ???????, ?????? ??????? ?????? ???????? OLE DB ??????? ?? ??????? ???????? ??? ?? Transact SQL ??? ??? ???????? ??? SQL ????? ?????? ??????? ?? ???? ??? ???? ??????? ?? ??? SQL Server 7.0 ?? ??? "?????? ???????????" ??? SQL Server ???????? ?????? ??????

???????? ??? ??, ?? ?????? ?? ??? ??? ?? 128 MB. ?? ??? ???? ??-???? ???????? ?? ??? ??????? ??? ?? ?????? ?? ????? ???? ??? ?????? ?????, ????? ????? ?? ????? ?????? ????? ??? ?? ???? ?? ??? ?? ???? ????? ???? ??? ?? ???? ??:
  • SQL ????? ???????? ??????? ?? SQL Server Standard Edition ?? ???: 2 GB
  • SQL ????? ??????????? ???????: ?? ??? 3 GB
??????????? ?? ?? ????? ?????? ?? ??? ?? ?????? ?? ????? ???? ?? ??? ???? ???

?? ?? ?????? ?? ????? ???? ?????? ??????????? ?? ??? ???? SQL ????? ?? ?????? ?? ?????????? ?? atypical ??? ?? ???? SQL ????? ????????? ?? ??????? ??? ????? ??? ??? ?????? ????? ???? ?? ??? ?? ?? ????? ?? ?????? ?? ???? ????? ?? ???? ????????? ???? SQL ????? ??????? ???? ?? ???? ?? ?? ??-???? ?????? ?? ????? ?? ???? ????

??????? ??? ?? ??? ????? ???? ?????-g????-?????? ????? ???? ?? ?? ?? SQL ????? ?????? ??? ??? ????? ??????? ?????? ????? ???????:
???????: ?????? ?????? ????? ???? ?? ??? ????????? ??? ??? ???? ?? ??? ???
?? ?????? ????? ????? ???? ?? ?? SQL ????? SQL ????? ?? ????? ?? ???? ???? ?? ??? ?????? ???? ?? ???? ?? ?????? ?????? ?? ??? ????? ?? ???? ?? ??? ???? ????????? ??? ???????? ?????????. dll ??????? ?? ??????? ??????????? ?? ?????? ???, ?????? ???????? ?? ?? ?????? ?? ?????? ?? ?????? ?? ????? ????-g????-?????? ?????? ???????? ??? ?? ?? ?? ??? ?? ????? ??, ?????? ???? ??? ?? ????? ?? ??? ?????? ?????? ?? ?????? stacks ??????? ?? ???????? ????????????, ?????? ??????, ?? ???????? ?? ??????? ?? ????? ???? ?? ?????? ??? ??????-intensive ??????? ???? ?? ??? ??? ??????????? ??? ????????? ?????? ?? ???? ???

????? ??????? ??? ?????
?????? ??? 1 ??? ???????? ????

??? SQL Server 7.0 ?? MSDE 1.0 ?? ??? ?????????, ?? ?????? ??? ?????????? ?????? ???? ???? ???? ????? ?? ??? ?? ??? ???? ??? ?????:
  • CURSOR_CLOSE_ON_COMMIT, OFF ???
  • ????? ????? ???
  • ????? ?? ???? worktable populating ?? ???? ???
To increase compatibility with earlier versions of SQL Server, Database Components SP1 changed this behavior so cursors are closed on rollback only if one of the following conditions is true:
  • CURSOR_CLOSE_ON_COMMIT is ON.
  • An asynchronously populated cursor is currently populating.
The behavior that is introduced in Database Components SP1 is carried forward in later service packs.

Changes in SQL Profiler
Theconnection iddata column in SQL Profiler will not be supported in a future version of SQL Server. We recommend that you use theSPIDdata column instead.

SQL ????? ?????????? ????? ????

????? ???? "???? ??????? SQL Server 7.0, ??????????? ??????? ???, Microsoft ??????? ????? ??: ??? ?? ??? ???????" SQL Server 7.0 ?? ??? SQL Server ???????? ?????? ??? ??? ?? ?????????? ??????? supplements. ?? ????? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://support.Microsoft.com/KB/842192

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

?? ??? ????? ???????? ?? ???? ???? ??? ???????? ???? ?? ?? ??????????????? ?????? (DTS) ?????? ??? ???
Oracle ??????? ?? ??????? ????
?????? ??? 1 ??? ???????? ????

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

DTS ??????? ?????? ?? ????? ????
?????? ??? 1 ??? ???????? ????

DTS ??????? ?????? ??????????? ??? ????? ?? ?? ?? ??????? ?? ?? lookups ?? ?????? ???? ??? DTS ?????????? ??????? ????? ?? ????? ????? ??? ??? ??????? ?????? ??:
  • ????????? ??????????????? ???????? ????? ???, ????? ????Transformations??? ?? ????? ????.. ???, ????-????? ?? ??? ?? ????????? ????? transformations ??? ????? ????? ???? ???? ???? ??? ??? ??????? ???? ???? ????
  • ???-????? ????ActiveX ????????? ????? ???????? ????? ??? ??? ????? ?? ???? ????, ?? ???? ???Test.
?? ??????? ?? ?????? ??????? ?? ?? lookups. ??????? lineage ????? ?? ??????? ???? ????

???????? ?????? ????? ????? ??? ??? ?? ????????
?????? ??? 1 ??? ???????? ????

?? ?? DTS ???? ???????, DTS ??????? ???????? ?? DTS ??????? ??? ?? DTS ????? ?????????, ???????? ??????? ?? ??? ????? ???? ???????? ????????? ????????? ????? ??????? ???, ??????? ??? ?? ???? ?? ????????? ???? ?? ??? ??? ?? ??? ????? ??? ?????????? ?? ??????? ?? ??? ?????? ?? ????? ?? ?????? ???? ????

??? ??, ????? ???????? ?? ????? ?????????? ????? ??????? ?????? ???

???? ??????????????? ???? ?????? ?????
?????? ??? 1 ??? ???????? ????

DTS ?????? ????? ?? ????? ???? ??? ??? ?????? ????? ??? ??????? OLE DB ???????-??????? ??????? ?? ???????? ???? ?? ???? ??? ????????

Microsoft Visual Basic ????????? ??? ??? ?????? ?? ????? ????
?????? ??? 1 ??? ???????? ????

Microsoft ActiveX ????????? ?? ???????? ?????? DTS ???? ?? ??? Microsoft Visual Basic ???????????? ??????? (VBScript) ????????? ??? ??????? ?? ?? ???????? ???? Visual Basic ??? ???????? ?? ????? ????

?????set??????, ?? ?? ??? ???????? ?????? ?? ????? ???? ????? ???? ????? ????, ?????? ???????? ?? ??????? ??? ????? ?? ????

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

SQL Server 7.0 SP2, SQL Server 7.0 SP3 ?? SQL Server 2000 DTS ????? ?? ?????? ?? ??? ????? ???? ?? ?? ?????? ?????? ??? ???????? ????????? ?? ??? ??????? ?? ???? ???? ???? ?? SQL ????? ?? ??? ??? ????? ????? ??? ??, ?? ????? ?????? ?? ???? ??? ??????? ?? ??? ??????? ????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????? ???????????? ??
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 ????? ????? ???????? ???? ?????
?????? ??? 4 ??? ???????? ????

?? ????????? ??? SQL Server SQL Server 7.0 SP4 ?? ?????? ???, DTS ????? ????? ?? ???????? ??? ?? ?? ?? ??? ???? ????? ?? ???? SQL Server ????? ???????? ???? ?? ????????????? ?? ??????? ?? ?? ?? ???????? ???? ?? ??? ???-?? ?? ????? ?? ????? ?? ?? ???? ?? ??? ?????????? TEMP ?????? ??? ????? ??? ????? ?? ???? ???? ?? ???? ?? ????? ?? ????? ?? ???xp_cmdshell???????? ????????? ????????? ????? ????? ?? ????? ???? ?? ??? ????? ????? ???? ???

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

SQL Server 7.0 ?? Exchange 5.5

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

?????? ?? ????? ?????? ?? ?? ?? ???? ?? ?? ?? ?? ??? ??? ?? ?????? ????? ??? ?? ???, ???? SQL Server 7.0 ??????? ???????? ??????, ??? ???? ???? ??sp_configure ??????? ?????? ???????????, SQL ????? ?? ???????? ?????? ??? ?? ?????? ???? ?? ??? ?????? ?? ?? ?????? ?? ?????? ?? ???? ?? ??????? ??? SQL Server ????? ???? ??????? ?????? ???????? ?????? ???????? ?? ??????? ?? ??? ???????? ?????? ??sp_configure ?????? ????? ????????????? ???? ????, SQL Server ???????? ??????? ?????? ?????? ??? ????????? ???? ??? ?????? ?? ?????? ?? ??? ????? ?????????? ?????? ?????, ???????? ?????? ??????? ?????? ?? ???? ?????? ???????? ?? ?? SQL ????? ?? ????? ?? ??? ???????? ???? ??????

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

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

?????? ??? 1 ??? ???????? ????

SQL ????? ???????? ?????? ?? ?????? ??? ??????? ?? ???? ?????? ?? ??????? ?? ??? ??? ?????? ??????? SQL Server 7.0 SP4 self-extracting ????? ?????? corrected ?????? ?? ??????? ?? ??? ?? ?????? SQL Server ???????? ?????? ????? ??? ????? ???

SQL ????? ???????? ?????? ?? corrected ?????? ??????? ?? ??????? ????, ????? ????? ?? ???? ????:
  1. ???? ???????? ?? ?? ????? ??????? ?? ??? ???? ??? ??????? ?? Sqlbolfr.exe ????? ?? ????????? ??????
  2. Sqlbolfr.exe Sqlbol.chm ????? ?? ??????? ?? ??? ??????
  3. ?? Sqlbol.chm ????? ?? ????????? C:\Mssql7\Books ??????????? ?? ????? ?? ???? ??????? ?? ???????? ?? ?????

Repository ????????

?????? ??? 2 ??? ???????? ????

?? ??? ?? ????????? ???????? ?????? ??? ?? ????? ??? ???????? ?? ????
DB2 ?? Informix ??????? ?? ???? ?? ??? ??
?????? ??? 2 ??? ???????? ????

?? ?? OLE DB ?????? ?? ????? DB2 ?? Informix ??????? ?? ???? ???? ?? ??? ??, Microsoft ????? ?? ????? ???????? ?? ?????? ?? ?????? ?? ??????? ?? ???? ?? ??????????? ??????? DB2 ?? Intersolv Informix ODBC ???????, Intersolv OLE DB ??????? ODBC ?? ???, ?? Intersolv OLE DB ??????? Informix ?? ??? ?? ??? Microsoft ODBC ??????? ?? ????? ???? ?? ??? ???? ???? ???

Versioned ?????????? ?? ????? ?????????????
?????? ??? 2 ??? ???????? ????

?? ?? ???? ??? ?? ??????? ?? ????? ??? ???? ?? ???????? ??????? ?? ?? ?? ??????? ??????? ???? ???? ?? ??????? ????? ??? ????, ??? ?? ??? ???????? ??????? ???? ?? ?? ??? ???????? ?? ??? ??? ??????? ?????, ???? ???? ?? ?????? ????? ??? ?? ?????? ??????? ??????? ???? ?? ?????? ?????

???

???? ID: 889543 - ????? ???????: 05 ?????? 2010 - ??????: 2.0
??????: 
kbPubTypeKC kbservicepack kbhowto kbinfo kbmt KB889543 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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