???? ID: 321185 - ????? ???????: 23 ????? 2012 - ??????: 13.0

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

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ???? ????? ?? ?? ???? ???? ??????? Microsoft SQL ????? ??????? ?????? ?? ?????? ?????? ?? ?????? ??? ???? ????????? ???? ?? ???? ?? ?? ?? ????? ?? ??? ??? ?? SQL ????? ?? ??????? ??????? ?? ???????? ???? ?? ????? ?? ????? ???? ???

??? ?? ???? ?????? builds SQL ????? ?? ??? ??? ???? ????? ???, ?? ????? ???? ?? ???????? ?? ???? ???? ??, ???? ?? ???? ?? "???? ???????" ??? ??? ???? ?????? ?? ??????? ???????? ???? ?? ???? ????
957826 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;957826) ?? ?????? SQL ????? ?? ???? ??? ??????? ??????? ???? ?? ??? ????

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

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

SQL ????? ??????? ???????? (SSMS)

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

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


SQL ????? ??????? ?????????? ????? ???????? (BIDS)

???????? ?????? ????????, ?????? ?????? ???????? ??, ?? SQL ????? ?????????? ?????? ???????? ??????? ?? ???? ???? ?? ???, ????? ????? ?? ???? ????:
  1. ???? SQL ????????? ???? ?? ???, SQL ????? ??????? ?????????? ????? ???????? ?? ??????? ?????
  2. ?? ??? ???? ??, ????? ???? ?? ???? ???.
  3. ??? ??????? ???????? ????, ?????? ??? ??? ????, ?? ?? ??????? ?? ??? ???? ??? ?? ????? ??? ?????? ????? ??? ??????

    SQL ????? 2005 / ????? ???????? 2005

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



    SQL Server 2008 / SQL ????? 2008 R2 / ????? ???????? 2008

    ?? ??? ?? ??????? ?????? ??? ?? ??????? ????
??? ?????? ??????, ?????? ?????????? ?? ???????? ?????? ???? ??????? ?????????? ???????? ?? ???, ?????? ?????? ?????, ????? ???????? ?? ?????????? ?????? ???????? SSIS ?????, ??????? SSRS, ?? ???????? ?????? ????? ??????? ??? ??????? ???? ?? ??? ???????-???? ?????????? ?? ??????? ???? ??? ???? ???
????? ?? ???? ????

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

SQL ????? ?? ??????? ?? ???????? ???? ?? ???, ?? ????? ??????? ??? ?? ???? ?? ?? ?? ???? ???:

???? 1: ????? ?? ?????? SQL ????? ??????? ???????? ??? ???????? Explorer ?? ????? ??? ???????? Explorer ?? ?????? ???? ?? ???, ?? SQL Server ?? ??????? ?????? ?? ??? ?????? ???? ?? ??? ????? ???? ???? ?? ?????????? ??? ?? ??? ?????? ??? ??????? ??????? ????? ??????

???? 2: ?? ?? ?????? ?? ??? Errorlog ????? ?? ???? ??? ????????? ?????? ???????? ??? ??, ?????? ??? ????????? Files\Microsoft SQL Server\MSSQL ?? ????? ???n\MSSQL\LOG\ERRORLOG ?? ERRORLOG.n ???????? ???????????? ????? ?? ???? ????? ?? ???? ??:

2011-03-27 22:31:33.50 Server      Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)                 Mar 29 2009 10:11:52                 Copyright (c) 1988-2008 Microsoft Corporation                Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
???? ?? ?? ??? ???? ???, ???? ?? ???????, ?????? ????, 64-??? 32-??? ????, SQL ????? ?? ??????? ?? OS ??????? ?? SQL ????? ?? ??? ?? ?????? ?? ???? ??? ??? ?????? ??????? ?? ????????? ?????? ???? ???

???? 3: SQL ????? ??????? ?? ?????? ????, ?? ???? ??? ????? ?????? ?????:
Select @@version
?? ?????? ?? ?????? ?? ?? ?????? ?? ??? ??? ????? ?????? ??:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 
10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express 
Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

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

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
??? ?? ?????? ???? ?? ?????? SQL Server 2000 ?? ??? ?? ??????? ?? ??? ??? ???? ???

????? ?????? ??? ?? ???:
  • ?????? ??????? (?????? ?? ???, 10.0.1600.22)
  • ?????? ???? (?????? ?? ???, RTM)
  • (?????? ?? ???, ???????????) ???????

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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
10.0.1600.22RTM??????????? ???????

??? ??? SERVERPROPERTY ??????? ???? ??????? ??????? ?? ???, ?? ???-??? ??? ?????? @@ ?????????????? ?????? ??? ?? ???????? ?? ?????? ??? ???? ????????? ???????? ????????? ??? ?? ???????? ???? ??, ?? ?? ????? ?? ???? ??? SERVERPROPERTY ???????? ?? ???? ?????? ???? ?? ??? ??????? @@ ??????????????

???? 5: ???? SQL ????? 2008 ?? ??? ?? ??????? SQL ????? ???????? ??? ??????? ?? ?? ????? ?? ???? ???? ?? ??????? ?? ?????? ??? ?? ??? ???? ??? ????? SQL ????? ??????? ?????? ?? ?????? ?? ????? ???? ?????? ?? ??????? ?? ??? ??? ?? ??? ?????? SQL ????? ?? ???? ??? ??????? ???? ??? ?? ??????? ???? ?? SQL ????? ??????? ???????? ????? ????? ???? ?? ????? ??????? ?????? ?? ???? ???? SQL ????? ??????? ?? ????? ?? ???? ??? ?? ????? ???? ??? ?? ???? ???? ???? ?? ??? ???? ????? ??? ?? ?????? ????? ?? ???? ??? ??????? ??????? ???? ?? ??? ???? ?? ????? ???? ??????? ?? ???, Microsoft ?????? ??????? (MSDN ??) ????? ??? ?? ????? ?? ????:
SQL Server 2008 ??? ??????? (http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx)

?? ????? ??????? ?? ?? ???????? ??????????? ??:

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


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

SQL Server 2008 R2 ??????? ???????

????? ?????? SQL Server 2008 R2 ?? ?????? ????????? ???????? ???? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????????? ???????
SQL ????? 2008 R2 ?????? ??? 110.50.2500.0
SQL Server 2008 R2 RTM10.50.1600.1
?? ???? ??????? ????? ?? ??? ?????? ?????? ??? SQL Server 2008 R2 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2527041  (http://support.microsoft.com/kb/2527041/ ) SQL Server 2008 R2 ?? ??? ?????? ?????? ??? ??????? ???? ?? ??? ????

???? ??????? ?? ??? ?????? ????? ?????? ?????? SQL Server 2008 R2 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
981356  (http://support.microsoft.com/kb/981356/ ) SQL Server 2008 R2 ?? ?????? ??? ?? SQL Server 2008 R2 ?????? ???? ??? ?? ?? ??? ??
2567616  (http://support.microsoft.com/kb/2567616/ ) SQL Server 2008 R2 ?? ?????? ??? ?? SQL Server 2008 R2 ?????? ??? 1 ???? ???? ?? ??? ??

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

SQL Server 2008 ??????? ???????

????? ?????? SQL Server 2008 ?? ???? ????????? ???????? ???? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????????? ???????
SQL Server 2008 ?????? ??? 310.00.5500.00
SQL Server 2008 ?????? ??? 210.00.4000.00
SQL Server 2008 ?????? ??? 110.00.2531.00
SQL Server 2008 RTM10.00.1600.22
?? ???? ??????? ????? ?? ??? ?????? ?????? ??? SQL Server 2008 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
968382  (http://support.microsoft.com/kb/968382/ ) SQL Server 2008 ?? ??? ?????? ?????? ??? ??????? ???? ?? ??? ????
???? ??????? ?? ??? ?????? ????? ?????? ?????? SQL Server 2008 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
956909  (http://support.microsoft.com/kb/956909/ ) SQL Server 2008 ?? ???? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008
970365  (http://support.microsoft.com/kb/970365/ ) ?? ?????? ??? ?? SQL Server 2008 ?????? ??? 1 ???? ???? ?? ??? ?? SQL Server 2008
2402659  (http://support.microsoft.com/kb/2402659/ ) SQL Server 2008 ?????? ??? 2 ?? ???? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008
2629969  (http://support.microsoft.com/kb/2629969/ ) SQL Server 2008 ?????? ??? 3 ?? ???? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL Server 2008

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

SQL ????? 2005 ??????? ???????

????? ?????? SQL ????? 2005 ?? ?????? ????????? ???????? ???? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????????? ???????
SQL ????? 2005 ???? ??? 49.00.5000.00
SQL ????? 2005 ???? ??? 39.00.4035
SQL ????? 2005 ???? ??? 29.00.3042
SQL ????? 2005 ???? ??? 19.00.2047
SQL ????? 2005 RTM9.00.1399
?? ???? ??????? ????? ?? ??? ?????? ?????? ??? SQL ????? 2005 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
913089  (http://support.microsoft.com/kb/913089/ ) SQL ????? 2005 ?? ??? ?????? ?????? ??? ??????? ???? ?? ??? ????
s ???? ??????? ?? ??? ?????? ????? ?????? ?????? SQL ????? 2005 ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
937137  (http://support.microsoft.com/kb/937137/ ) SQL ????? 2005 ???? ??? 2 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL ????? 2005
960598  (http://support.microsoft.com/kb/960598/ ) SQL ????? 2005 ???? ??? 3 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL ????? 2005
2485757  (http://support.microsoft.com/kb/2485757/ ) SQL ????? 2005 ???? ??? 4 ?? ???? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ?? ?? SQL ????? 2005

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

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

????? ?????? Sqlservr.exe ????? ?? ??????? ??????? ?? ???????? ???? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????????? ???????
SQL Server 2000 ?????? ??? 48.00.2039
SQL Server 2000 ?????? ??? 3a8.00.760
SQL Server 2000 ?????? ??? 38.00.760
SQL Server 2000 ?????? ??? 28.00.534
SQL Server 2000 ?????? ??? 18.00.384
SQL Server 2000 RTM8.00.194


???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
290211  (http://support.microsoft.com/kb/290211/ ) ?????? SQL Server 2000 ?????? ??? ???? ??????? ????

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

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

SQL ????? ?????????? ?????? ?? ?? ??????? ????????? ???? ?? ???, SQL Server ???????? ?????? ??? ????? ???? ?????:
???? ?? ???: ??????? ??????? (?????????? ??????) ?? ??? ????? (http://msdn.microsoft.com/en-us/library/bb630446.aspx)


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

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

SQL ?????, ??????, ?????? ?? ?? ??????? ????????? ???? ?? ???, ????? ???? ?? Microsoft ???????? ??? ?????:
942177 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;942177) SQL ?????, ??????, ?????? ?? ?? ??????? ????????? ???? ?? ??? ????



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

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

SQL Server ???????? ?????? ?? ?? ??????? ????????? ???? ?? ???, ????? ??????? ??? ?? ???? ?? ?? ????? ????:

???? 1: ?? ??? ????? ?? ????? ?? ?????? ???? Explorer ???????? SQL ????? ??????? ???????? ???? ???????? Explorer ?? ?????? ???? ?? ???, ?? ???????? ?????? ?? ????? ?????? ???? ?? ??? ?????? ???? ?? ??? ????? ???? ???? ?? ?????????? ??? ?? ??? ?????? ??? ??????? ??????? ????? ??????

???? 2: ???????? ?????? ??? ??????? ??? Msmdsrv.exe ????? ?? ?? ??????? ?? ???? ????? ???????? ????? ?? ????? ?????? ??? ????? ???? ???:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????? ?????? ????????????
2008 R2C:\Program Files\Microsoft, SQL, Server\MSAS10_50.InstanceName\OLAP\bin\MsMdSrv.exe
2008C:\Program Files\Microsoft SQL Server\MSAS10.InstanceName\OLAP\bin\MsMdSrv.exe

2005C:\Program Files\Microsoft, SQL, Server\MSSQL.n\OLAP\Bin\MsMdSrv.exe
2000C:\Program Files\Microsoft, ????????, Services\Bin\MsMdSrv.exe

???? 3: ?????????? ?????? ??? ???????? ??? ????????? ???????? ?? ????? ????:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
???????? ?????? ????????????
2008 R2HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \MSSQLServer\CurrentVersion ?????: CurrentVersion



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \Setup ????????: PatchLevel, ???????, ????? ???????

2008HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.InstanceName\MSSQLServer\CurrentVersion ?????: CurrentVersion



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.InstanceName \Setup\ ????????: PatchLevel, ???????, ???????

2005HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\CurrentVersion ?????: CurrentVersoin



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\Setup ????????: PatchLevel, ???????, ???????

2000HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion ?????: CSDVersion

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Setup ?????: PatchLevel

???? ??????? ?? ???, ????? Microsoft TechNet ????? ??? ?? ????? ?? ????:
???????? ?????? ????? ??????? ?? ????? ?? ??? ???? (http://blogs.technet.com/b/sqlman/archive/2008/03/25/how-to-find-analysis-services-server-version.aspx)

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

SQL Server ?????????

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

?????? ?? ???, ????? ????? Transactional ?? ????-??-???? ????????? ??? ?? SQL ????? ?? ??????? ?????? ???? ?? ??????? ????? ?????????? ?? ??????? ??? ???? ??? SQL ????? ?? ????? ?? ???? ?? ???????? ?? ????? ?? ???? ???

???????????? ?? ???? ?? SQL Server 2000 Windows CE ??????? ????????? ?? ??? ??? ?????????????? ?? ????? ???? ???, ?? IIS ??? ????? ???????? ?? SQL ????? ?? ??? ?? ?? ??? ??? ?? ?? ???????? ???? ?? ????? ?????, ??? ?? ??????????? ????? ??????? IIS ??? ????? ?? ??????? ??? ?? IIS ??????? ?????????? ??? ??. dll ??????? ?? ??????? ?? ???? ???? ?? ?????? ?????? ??? ?? ?????? ?????? ?????, ????? ???????? ?? ?????????? ???? ??? ???????? ?? ??? ??????? ???? ?? ??? ?????? ???? ??? ???? ???

???? ??????? ?? ???, SQL Server ???????? ?????? ??? ????? ???? ?????:
????????? ???????? ??? SQL ????? ?? ?????? ????????? ?? ????? ???? (http://msdn.microsoft.com/en-us/library/ms143241.aspx)
????? ?? ???? ????

?????-??? ???

?????-??? ??? ??? ??? ????? ????? ???:
  • Sqlserver.exe
  • Sql_fulltext_keyfile.dll
  • Iftsph.dll
  • Fd.dll
  • Fdhost.exe
  • Fdlauncher.exe
Sqlservr.exe ?? ?????, ?? ????? ???????? ????? ?????? ?? ?????? SQL ????? ?????? ?? ??? ?????? ??? ?? ??? ?????? ???? ?? ???? ?? ????? ?? ??????? ?? ??????? ???? ???? ?? ?? ??? ?????? ?????? ??? ?? ??? ??? ?????? ????????:, ?? ???????? ?????. dll ??????? ?? ????? ?? ??????? ???? ?? ???? ???? ???? ??? ???? ??????? ?????? ?? ??????? ???? ??? ?? ?????-??? ??? ??? ?? ??????? ???

????? ??????? ??? ?? ?? ?? ???? ?????? ?? ??????? ???? ??? ?? ?????-??? ??? ??? ?? ??????? ????????? ???? ?? ??? ????? ?? ???? ????

??? ?? ??????? ?? ???????? ????? ?? ???? ?? ?? ?????-??? ??? compnent ?? ??????? RTM ?? ?? ??????? ??? ?? ??????? ??????? ?? ???? ?? ?? ??????? ??? ?? ?? ?? ?? ?????? ?? ?? ?? ?????? ?????? ??? ??? ??? ?? ??? ??? ???????

???? 1: SQL Server ?????-??? ????? (Sql_fulltext_keyfile.dll) ?? ??????? SQL Server 2008 R2 ?? SQL Server 2008 ??????? ??????? ??? ?????? ??????????, SQL Server 2008 R2 ?? ???, ????? ??????? ??? ?? ????? ????? ??:
%ProgramFiles%\Microsoft SQL Server\MSQL10_50.<Instance name="">\MSSQL</Instance>

SQL Server 2008 ?? ???, ?? ????? ?????????? ????? ??????? ??? ????? ??:
%ProgramFiles%\Microsoft SQL Server\MSQL10.<Instance name="">\MSSQL</Instance>

???? 2: ????? ????????? ??????? ?? ??? ????:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft sql server\Mssql10_50.instname\Setup\SQL_FULLTEXT_ADV
?? ????????? ????? ?? ?????? ????????? ????? ??:
featurelist:          SQL_FullText_Adv=3 SQL_FullText_CNI=3ProductCode:    {9DFA5914-C275-42E0-810E-C88E46A7F9EA}Patchlevel: 10.50.1765.0Version: 10.50.1600.1
?? ?????? ??? ?????????, ????? ?????? (Patchlevel) ??????? ????? ?????-??? ??? ??? ??????? ??, ?? ???? (???????) ?????? ?? ????? ?? ??? ??????? ??????? ?? ?????-??? ??? ?? ???? ????? ???? ??? ?? ?????? ???, SQL Server 2008 R2 ???

3 ????: ????? ?? ????? ????? Summary.txt ????? ?? ????? ????? SQL Server 2008 R2 ?? ???, ?? ????? ??????? ??? ????? ???? ??:
%ProgramFiles%\Microsoft SQL, Server\110\Setup, Bootstrap\LOG\Summary.txt

SQL Server 2008 ?? ??? ?? ????? ?? ????? ??????? ??? ????? ???? ??:
%ProgramFiles%\Microsoft SQL, Server\100\Setup, Bootstrap\LOG\Summary.txt


?????-??? ??? SQL Server 2008 ????????? ??? ????? ?? ??? ????? ???? ?? Microsoft ???????? ??? ??? ????? ?????? ?? ??? ?????:
973888  (http://support.microsoft.com/kb/973888/ ) SQL Server 2008 ?????? ??? slipstream ??????? ?? ????? ?? ???? ???? ?? ?? 1 ?? ??? ????? ?????? 3 ?? ??????? ???? ???? ?? ??? ?????-??? ??? ??? ???? ??? ?? ???? ???? ?? ??? ?????? ??? 1 ??????? ?????? ?? ????

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

SQL ????? ????? ???? ?????? (MDS)

MDS ???????????? ??????? ??????? ??????? ??? ??????? ?? ?????? ???? ???? ?????? ???

MDS ???????? ?????? ???????? ??? ?? SQL ????? ??????? ???? ??????? necessarily MDS ??????? ??? ???? ?? ???? ??? ?? ?? SQL ????? ??????? ????????? MDS ??????? ?? MDS ?????? ?????? ??????? ??? ???? ???? ?? ??? ????? ??????? ???-??? ?? ???? ??? MDS ???????????? ??????? ????? ?? ????? ???????? ????? ?? ?????? ???? ?? ??? ?? MDS ??????? ?? ??????? ?????? ?? ???????? ???? ?? ??? ?????? ???? ?? ????? ????????? ?? ?????? ??? ?????? ????????? ?? ????? ??? ?? ????? ???? ?? ??? MDS ?? ??? ?????? ?? ???? ???:
??????? ?? ??? ??, ?? SQL ????? 2008 R2 ????? ???? ?????? (MDS) ????? ?????? ??????? ?? ??? ?? (http://sqlblog.com/blogs/mds_team/archive/2010/08/25/downloading-and-installing-sql-server-2008-r2-master-data-services-mds-cumulative-updates.aspx)

????? ????????? ????? ?? SQL ????? ?? ??????? ?????? ??????? ?????? ??? ???????, ?? ??????? ??????? necessarily ??? ???? ?? ??????? ?????? ??????? ?? ????????? MDS ???????? ????? ???
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Master ???? ?????? 10.5\CurrentVersion

??? ?? ??????? ?????? ??????? ?? ?????? ??????? MDS ?????? ??? ?????????? ?????? ?? ????? ???? ???? ?? ???? ???:
select * from mds.mdm.tblSystem
????? ?? ???? ????

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

SQL ????? ??? ??????? ?? ??????? ????????? ???? ?? ???, ????? ??????? ??? ?? ???? ?? ?? ????? ????:

???? 1: ?? ???? ?? ??? ??????? ?? ??????? ?? ????? ?? ???, ?????? (odbcad32.exe) ODBC ?????????? ??????? ????, ?? ???? ??? ?? ???? ???? ??????? ????? ?? ??? ????????? ????

???? 2: ????? ????????? ????? ?? ????? PatchLevel ?? ??????? ???????? ?? ???? ????:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
SQL ??????? /
SQL ????? ??? ??????? ?? ???????		????????? ????????
SQL ????? 2008 R2
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL Server 2008 /
SQL ????? ??? ?????? 10		HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL ????? 2005 /
SQL ????? ??? ?????? 9		HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL ??? Client\CurrentVersion

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

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

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

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

SQL ????? ????

SQL ????? ???? ?? ?? ??????? ????????? ???? ?? ???, ????? ????????? ????? ??? ?? ???? ????:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SqlWriter\CurrentVersion

????????: PatchLevel ?? ???????

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

Microsoft.??? ?????

??????? ?? ???????? ???? ?? ???????? ?????? ?? ??? ????? ????? ???? ?? Microsoft ???????? ??? ?????:
318785 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;318785) ??? ?? ??????? ?? Microsoft ?? ?????? ??? ???? ????????? ???? ?? ??? ???????? ??? ??? ????? ???????

???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2027770  (http://support.microsoft.com/kb/2027770/ ) ?? ??????SQL Server ?? ??????? ????????? ?? ??? ??? ????? ??????????

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

SQL Azure

SQL Azure ?? ??????? ??????? ?? ???? ?????? ?? ??????? ??? ???? ?? ???, ???????? ?????? ??? ????? ???? ?????:
SERVERPROPERTY (SQL ??????? Azure) (http://msdn.microsoft.com/en-us/library/ee336261(en-us).aspx)

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

SQL ????? CE

SQL ????? CE ?? ??????? ??????? ?? ???? ?????? ?? ??????? ??? ???? ?? ???, ????? ?????? ?????:
  • SQL ????? ??????? ?????? ??????? (http://blogs.msdn.com/b/sqlservercompact/archive/2008/02/08/sql-server-compact-release-versions.aspx)
  • 325808 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;325808) ??? ????????? SQL Server 2000 Windows CE ??????? ?? ?????????

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

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

SQL Server 7.0

?????? ?? ???? ??? ???? ?? ????? ???? ?? ??? ????? ?????? ??? ??????? ?? ?????? ?? ????? ????:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
??? ??????? ?? ???????????? ???
7.00.1063SQL Server 7.0 ?????? ??? 4
7.00.961SQL Server 7.0 ?????? ??? 3
7.00.842SQL Server 7.0 ?????? ??? 2
7.00.699SQL Server 7.0 ?????? ??? 1
7.00.623SQL Server 7.0 RTM

???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
301511  (http://support.microsoft.com/kb/301511/ ) SQL Server 7.0 ?????? ?????? ??? ???? ??????? ????

SQL Server 6.5

?????? ?? ???? ??? ???? ?? ????? ???? ?? ??? ????? ?????? ??? ??????? ?? ?????? ?? ????? ????:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
??? ??????? ?? ???????????? ???
6.50.479SQL Server 6.5 ?????? ??? 5a ??????
6.50.416SQL Server 6.5 ?????? ??? 5a
6.50.415SQL Server 6.5 ?????? ??? 5
6.50.281SQL Server 6.5 ?????? ??? 4
6.50.258SQL Server 6.5 ?????? ??? 3
6.50.240SQL Server 6.5 ?????? ??? 2
6.50.213SQL Server 6.5 ?????? ??? 1
6.50.201SQL Server 6.5 RTM

???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
273914  (http://support.microsoft.com/kb/273914/ ) Readme. txt SQL Server 6.5 post-Service ??? 5a ?????? ?? ???

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

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

Q1: SQL ????? ???? ?? ??? ??, ?? ???? ?? SQL Server ?? ??????? ????????? ????

A1: ??? ?? SQL ????? ?? ??????? (???? 2 ?? ???? 5 SQL Server 2008 ?? ??? ?? ????????? ?? ???) ?? ????? ?? ?? ???? ?? "SQL ????? ??????? ????? ?? ??? ?? ??????? ?? ???????? ???? ??? ??" ?????? ??? ????????? ?? ???? ????

Q2: ???? ??? ?????? ??????? ?????? ????? ?? ??? ?????

A2: ?? ?????? ?? ??? ??? ?? ????? ?????? ?? ????? ?? ???? ???:
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
??????? ????????SQL ??????
10.5.x.xSQL ????? 2008 R2
10.00.x.xSQL Server 2008
9.00.x.xSQL ????? 2005
8.00.x.xSQL Server 2000

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

????? ????? ??? ???? ???? ?????? ?? acronyms

????? ?????? (CU): ?? ???-?? ?????? ??? ????? ?????????? ??-?????? ?????????? ?????? ??? ???? ????????, ?? CU ???????? ???????? ???????? ?? ???? ???????? ?? ??? ???????? ???? ?? ???????? ?? ???????? ?? ??? ??????, ??????, ?????? ?? reproducibility, ?? ????????? ???? ???? ????? ??? ?? ?????? ?? ??????, ?? ???? ?????? ????? ?? ???? ????

????????: ?? ?????? ??? ?? ?????? ?? ?? ???? ?? ??? ????? ???? ???? ??, ?? ?????? ?? ????? ???? ?? ????? ???? ??? ?? ?? ?? ???? ??????? ????? ???? ??? ?? ???? ???, ????? ?????? ?? ???????? ?? ??????? ?????? ?????? ??? ?? ?????? ?? ????? ?? ???? ?????? ???? ???? ?? ???? ???

RTM: ????? ?? ?????? "??????? ?? ??? ??????." ???? ?? SQL ????? ?????? ?? ?????? ???, ?? ??? ?????? ??? ?? ?????????? ?????? ?? ???? ??? ?? ?? ?? ????? ???

RTW: ????? ?? ?????? "??? ?? ??? ??????." ?? ????? ?? ??? ???? ?? ??? ???? ???? ??? ?? ?? ???????? ?? ??? ??????? ?? ??? ?????? ???? ????? ???? ???

???? ???: ?? ?? ??? ??????????, ??????? ??????, ?????????? ??????, ????? ??? ?? ???????, ?? ??????? ?????? ??? ?????? ?????? ?? ??????-???????? ??????? ???????? ?? ???????? ?? ?? ????? ?????? ?? ??? ?????? ??? ?? ??? ???? ??? ???????? ?? ??? ???????? ?????? ?? ???? ???

???? ??????? ?? ???, ????? ??? ?????? ?? ????:
  • 822499 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;822499) Microsoft SQL ????? ?????????? ?????? ???????? ?? ??? ?????? ??????
  • 824684 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;824684) Microsoft ?????????? ???????? ?? ????? ???? ??? ???????? ???? ???? ???? ?????? ?? ?????
  • 935897 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;935897) ?? ????????? ????? ???? ?????????? ??????? ?? ?? ???????? ?? ??? ?????? ???? ?? ??? SQL Server ??? ?? ?????? ???? ??
  • http://en.wikipedia.org/wiki/Software_release_life_cycle (http://en.wikipedia.org/wiki/Software_release_life_cycle)

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

???? ???????

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

??? ?? ???????? ????? ?????? ?? ????? ???? ?? ?? ?????? ??????? ?????? ???? ??? ????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????? ?? ??????? ???????????? ?? ?????, (?? ?????? KB numberfor), ?????? ??????

SQL ????? 2008 R2


?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
10.50.2806.00SP1 CU # 5 (2659694) 22 Feb, 2012
10.50.2796.00SP1 CU # 4 (2633146) 19 Dec, 2011
10.50.2789.00SP1 CU # 3 (2591748) 17 Oct, 2011
10.50.2772.00SP1 CU # 2 (2567714) ?? 15, 2011
10.50.2769.00SP1 CU # 1 (2544793) Jul 18, 2011
10.50.2500.0SP1 RTW/PCU 1(2528583), 12 ?????, 2011
10.50.1810.00RTM 21 Feb, 2012, CU # 12 (2659692)
10.50.1809.00RTM Dec 19, 2011, CU # 11 (2633145)
10.50.1807.00CU # 10 (2591746) 17 Oct, 2011 RTM
10.50.1804.00RTM ?? 15, 2011, CU # 9 (2567713)
10.50.1797.0020 ???, 2011 CU # 8 (2534352) RTM
10.50.1777.00RTM Apr 18, 2011, CU # 7 (2507770)
10.50.1765.00CU # 6 (2489376), 21 Feb, 2011 RTM
10.50.1753.00CU # 5 (2438347) RTM Dec 20, 2010
10.50.1746.00CU # 4 (2345451) RTM Oct 18, 2010
10.50.1734.00 CU # 3 (2261464) RTM ?? 16, 2010
10.50.1720.00 CU # 2 (2072493) RTM, ??? 21, 2010
10.50.1702.00 CU # 1 (981355) RTM, ?? 18, 2010
10.50.1617.00GDR ??????? ?????? (2494088), ??? 21, 2011
10.50.1600.1 RTM ? ?? 10, 2010

SQL Server 2008

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
10.00.5770.00SP3 CU # 3 (2648098) ?? 16, 2012
10.00.5768.00SP3 CU # 2 (2633143) 21 ??, 2011
10.00.5766.00SP3 CU # 1 (2617146) 17 Oct, 2011
10.00.5500.00SP3 RTW / PCU 3 (2546951) Oct 6, 2011
10.00.4326.00SP2 CU # 8 (2648096) ?? 16, 2012
10.00.4323.00SP2 CU # 7 (2617148) 21 ??, 2011
10.00.4321.00SP2 CU # 6 (2582285) ??? 19, 2011
10.00.4316.00SP2 CU # 5 (2555408) Jul 18, 2011
10.00.4285.00SP2 CU # 4 (2527180) 16 ??, 2011
10.00.4279.00SP2 CU # 3 (2498535) 17 Mar, 2011
10.00.4272.00SP2 CU # 2 (2467239) 17 ??, 2011
10.00.4266.00SP2 CU # 1 (2289254) ?? 15, 2010
10.00.4064.00GDR ??????? ?????? (2494089), ??? 14, 2011
10.00.4000.00SP2 RTW / 2 (2285068) PCU ??? 29, 2010
10.00.2850.0SP1 CU # 16 (2582282) ??? 19, 2011
10.00.2847.0SP1 CU # 15 (2555406) Jul 18, 2011
10.00.2821.00SP1 CU # 14 (2527187) 16 ??, 2011
10.00.2816.00SP1 CU # 13 (2497673) 17 Mar, 2011
10.00.2808.00SP1 CU # 12 (2467236) 17 ??, 2011
10.00.2804.00SP1 CU # 11 (2413738) ?? 15, 2010
10.00.2799.00SP1 CU # 10 (2279604) ??? 20, 2010
10.00.2789.00SP1 CU # 9 (2083921) ????? 19, 2010
10.00.2775.00SP1 CU # 8 (981702) ?? 17, 2010
10.00.2766.00SP1 CU # 7 (979065) ????? 26, 2010
10.00.2757.00SP1 CU # 6 (977443) ?? 18, 2010
10.00.2746.00SP1 CU # 5 (975977) ?? 16, 2009
10.00.2734.00SP1 CU # 4 (973602) ??? 21, 2009
10.00.2723.00SP1 CU # 3 (971491) 20 Jul, 2009
10.00.2714.00 SP1 CU # 2 (970315) ?? 18, 2009
10.00.2710.00SP1 CU # 1 (969099) 16 Apr, 2009
10.00.2573.00 GDR ??????? ?????? (2494096), ??? 14, 2011
10.00.2531.00 SP1 RTW / PCU 1 ??????, 2009
10.00.1835.00 CU # 10 (979064) RTM, ????? 15, 2010
10.00.1828.00 CU # 9 (977444) RTM ?? 18, 2010
10.00.1823.00 CU # 8 (975976) RTM ?? 16, 2009
10.00.1818.00 CU # 7 (973601) ??? 21, RTM, 2009
10.00.1812.00 RTM CU # 6 (971490), 20 Jul, 2009
10.00.1806.00 CU # 5 (969531) ?? 18, 2009 SP1 RTM
10.00.1798.00 CU # 4 (963036) RTM, ????? 16, 2009
10.00.1787.00 CU # 3 (960484) RTM ?? 19, 2009
10.00.1779.00 CU # 2 (958186) RTM ?? 19, 2008
10.00.1763.00 CU # 1 (956717) RTM Sept 22, 2008
10.00.1600.22 RTM ? ?? 6, 2008

SQL ????? 2005

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
9.00.5266SP4 CU # 3 (2507769) 22 Mar, 2011
9.00.5259SP4 CU # 2 (2489409) 21 Feb, 2010
9.00.5254SP4 CU # 1 (2464079) Dec 23, 2010
9.00.5000SP4 RTW (PCU4) Dec 16, 2010
9.00.4325SP3 CU # 15 (2507766) 22 Mar, 2011
9.00.4317SP3 CU # 14 (2489375) 21 Feb, 2011
9.00.4315SP3 CU # 13 (2438344) Dec 20, 2010
9.00.4311SP3 CU # 12 (2345449) Oct 18, 2010SP3
9.00.4309SP3 CU # 11 (2258854) ?? 16, 2010
9.00.4305SP3 CU # 10 (983329) ??? 21, 2010
9.00.4294SP3 CU # 9 (980176) 19 Apr, 2010
9.00.4285SP3 CU # 8 (978915) 16 Feb, 2010
9.00.4273SP3 CU # 7 (976951) Dec 21, 2009
9.00.4266SP3 CU # 6 (974648) Oct 19, 2009
9.00.4230SP3 CU # 5 (972511) ?? 17, 2009
9.00.4226SP3 CU # 4 (970279) ??? 15, 2009
9.00.4220SP3 CU # 3 (967909) 20 Apr, 2009
9.00.4211SP3 CU # 2 (961930) 16 Feb, 2009
9.00.4207SP3 CU # 1 (959195) Dec 19, 2008
9.00.4053??????? ?????? (970892) 12 Oct, 2009
9.00.4035SP3 RTW (955706) Dec 15, 2008
9.00.3356SP2 CU # 17 (976952) Dec 21, 2009
9.00.3355 SP2 CU # 16 (974647) Oct 19, 2009
9.00.3330 SP2 CU # 15 (972510) ?? 17, 2009
9.00.3328 SP2 CU # 14 (970278) ??? 15, 2009
9.00.3325 SP2 CU # 13 (967908) 20 Apr, 2009
9.00.3315 SP2 CU # 12 (960485) 16 Feb, 2009
9.00.3301 SP2 CU # 11 (958735) Dec 15, 2008
9.00.3294 SP2 CU # 10 (956854) Oct 21, 2008
9.00.3282 SP2 CU # 9 (953752) ?? 18, 2008
9.00.3257 SP2 CU # 8 (951217) ??? 16, 2008
9.00.3239 SP2 CU # 7 (949095) 14 Apr, 2008
9.00.3228 SP2 # 6 (946608) 18 Feb, 2008 CU
9.00.3215 SP2 CU # 5 (943656) Dec 17, 2007
9.00.3200 SP2 CU # 4 (941450) Oct 15, 2007
9.00.3186 SP2 CU # 3 (939537) ?? 20, 2007
9.00.3175 SP2 CU # 2 (936305) ??? 18, 2007
9.00.3161 SP2 CU # 1 (935356) 16 ??????, 2007
9.00.3152 SP2 ????? (933097) ?? 15, 2007
9.00.3068??????? ?????? (948109) Jul 8, 2008
9.00.3042 SP2 (937137)
9.00.2047 SP1
9.00.1399 RTM

SQL Server 2000

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
8.00.2283?????-SP4 ???????? MS09-004 (971524) ?? ???
8.00.2282MS09-004: KB959420 ??????? 29,2008
8.00.2273MS08-040 - KB 948111 ????? 8, 2008
8.00.2040?????-SP4 AWE ????? (899761)
8.00.2039SQL Server 2000 SP4
8.00.1007???????? update. exe ???????? ???? ???? 2 (891640)
8.00.977???????? update. exe ???????? ???? ???? 1 (884856)
8.00.818 (821277)
8.00.765 ???????? ????? SP3 ?????
8.00.760 SQL Server 2000 SP3 ?? SP3a (8.00.766 ssnetlib.dll)
8.00.701 ???????? Installer v.1 ????
8.00.534 SQL Server 2000 SP2
8.00.384 SQL Server 2000 SP1
8.00.194 SQL Server 2000 RTM ?? MSDE 2.0

????? ?? ???? ????
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Integration Services
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
????? ?? ???? ????
??????: 
kbsqlsetup kbhowtomaster kbmt KB321185 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:321185  (http://support.microsoft.com/kb/321185/en-us/ )
????? ?? ???? ????