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

?????? ????????? ?????? ?????????
???? ???????: 321185 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

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

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

SQL Server ????? Studio (SSMS)

?????? ????? ????? ?????? ???? ?? ??????? ??? ?????? ????? ??? ???? Studio ?????? ????? ??? ??? ??? ??????? ???????.

?? ??? ??????????? ??? ??????
2560485

SQL Server Studio ????? ???? ??????? (?????????)

?????? ?? ??????? ???? ????? ??????? ?? ???? ????? ????? ?? ???? ????? ?????? ???? SQL? ???? ??????? ???????:
  1. ??? ?????? ????? SQL ?????? ??? ???? ????? SQL Server Business Intelligence Development Studio.
  2. ??????? ??????? ? ???? ??? ???.
  3. ?? ????? ???????? ??????? ? ??? ?????? ???????? ??? ?? ???? ????? ?????? ??? ???? ???? ?????? ?????? .

    SQL Server 2005 / Visual Studio 2005

    ?? ??? ??????????? ??? ??????
    2560486



    SQL Server 2008 / SQL Server 2008 R2 / Visual Studio 2008

    ?? ??? ??????????? ??? ??????
    2560487
?????? ????? "????????? ???????" ??? ????? ????? ?????? ????????? ?????? ???????? ?? ????? ????? ???? ??? ?????? ?????????? ????????? ????????? ??????? ??? ????? ????????? ?????? ?????? ??? ???? ????????? ????? ????? ??? SSIS ?? SSRS ?????? ?????? "????? ???????".

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

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

??????? ??????: ??????? ????? ???????? "?????? ??????" ?? Studio ????? ???? SQL. ??? ??????? ?? Object Explorer? ????? ???? ??????? ??????? ??? ????? ? ?? ??? ???????? ????????? ??????? ????? ????? ?? SQL Server.

??????? ???????: ???? ??? ?????? ??????? ?????? ?? ????? Errorlog ???? ??????. ???? ???????? ???? ??? ??????? ?? ???????? ?????????? SQL Server\MSSQL.\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 Server? ?????? OS ??? ?? ???? SQL Server ??? ???????.

??????? ???????: ??????? ????? SQL Server? ?? ?? ?????? ????????? ??????:
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: )

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

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

??? ????? ??????? ???????:
  • ????? ?????? (??? ???? ??????? 10.0.1600.22)
  • ????? ?????? (??? ???? ??????? RTM)
  • ??????? (??? ???? ??????? ??????? (Enterprise)

??? ???? ??????? ????? ??????? ??????? ??? ???:
?? ??? ??????????? ??? ??????
10.0.1600.22RTMEnterprise Edition
?????? ???? ?????? SERVERPROPERTY ??????? ??????? ???? ????? ???????? ???????? ??? ????? ?? ?? @@VERSION??? ?????? ??????? ?? ????? ?????. ??? ??? ??????? ????? ?? ????? ????? ??????? ???????? ????? ??????? ?????? SERVERPROPERTY ?????? ????? ????? ?? ????? @@VERSION???????.

??????? ???????: ????? ?? SQL Server 2008? ????? ???? ??????? ??????? ?????? ????? ????? ???? SQL. ???? ?????? ??? ??? ??????? ?????? ???? ?????? ????? ?? ???? ????? SQL Server. ??? ?????? ??????? ??? ???? ?????? SQL Server ???? ?? ??????? ??? ??????. ????? ??? ????? ???? ??? SQL Server Management Studio. ????? ?????? ???? ??? ?? ????? ?? ?? ?????? ???? ??????? ?????? ??? ??? ?????? ?????? ???? ???? SQL. ??? ???? ???????? ?????? ??? ??????? ??? ????? ?????. ?????? ??? ???? ?? ?????????? ?? ?????? ????? ??? ??????? ??????? ???Microsoft Developer Network (MSDN):
SQL Server 2008 Discovery Report
???? ?????? ????? ??? ???:

?? ??? ??????????? ??? ??????
2560488

??????? ????? SQL Server 2012

???? ?????? ?????? ??????? ???????? ?? SQL Server 2012.
?? ??? ??????????? ??? ??????
???????????? ??????
SQL Server 2012 Service Pack 111.00.3000.00
RTM 2012 ???? SQL11.00.2100.60
????? ?? ????????? ????????? ??? ???? ??? ?????? ? SQL Server 2012? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
2755533 ????? ?????? ??? ???? ???? ???? ? SQL Server 2012

????? ?? ????????? ??? ???? ???????? ????????? ???????? ? SQL Server 2012? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
2692828 ???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012

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

???? ?????? ?????? ??????? ???????? ?? SQL Server 2008 R2.
?? ??? ??????????? ??? ??????
???????????? ??????
SQL Server 2008 R2 Service Pack 210.50.4000.0
SQL Server 2008 R2 Service Pack 110.50.2500.0
SQL Server 2008 R2 RTM10.50.1600.1
?????? ??? ???? ?? ????????? ??? ???? ???? ???? ????? ??????? SQL Server 2008 R2? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft"
2527041 ????? ?????? ??? ???? ???? ???? ?? SQL Server 2008 R2

?????? ??? ???? ?? ????????? ??? ???? ????????? ????????? ????? ???? ??????? SQL Server 2008 R2? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft":
981356 ?????? ????? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
2567616 ?????? ????? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 R2 Service Pack 1
2730301 ???? SQL Server 2008 R2 ???? ?? ??????? ??? ????? SQL Server 2008 R2 Service Pack 2

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

???? ?????? ?????? ??????? ???????? ?? SQL Server 2008.
?? ??? ??????????? ??? ??????
???????????? ??????
SQL Server 2008 Service Pack 310.00.5500.00
SQL Server 2008 Service Pack 210.00.4000.00
SQL Server 2008 Service Pack 110.00.2531.00
SQL Server 2008 RTM10.00.1600.22
?????? ??? ???? ?? ????????? ??? ???? ???? ???? ????? ??????? SQL Server 2008 ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft"
968382 ????? ?????? ??? ???? ???? ???? ?? SQL Server 2008
?????? ??? ???? ?? ????????? ??? ???? ????????? ????????? ????? ???? ??????? SQL Server 2008 R2? ???? ??? ????? ???????? ?????? ?????? ?? "????? ??????? ?? Microsoft":
956909 ?????? ????? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
970365 ?????? ????? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
2402659 ???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 2
2629969 ???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 3

??????? ????? SQL Server 2005

???? ?????? ?????? ??????? ???????? ?? SQL Server 2005.
?? ??? ??????????? ??? ??????
???????????? ??????
SQL Server 2005 Service Pack 49.00.5000.00
SQL Server 2005 Service Pack 39.00.4035
SQL Server 2005 Service Pack 29.00.3042
SQL Server 2005 Service Pack 19.00.2047
SQL Server 2005 RTM9.00.1399
????? ?? ????????? ????????? ??? ???? ??? ?????? ? SQL Server 2005? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
913089 ????? ?????? ??? ???? ???? ???? ? SQL Server 2005
s ?????? ??? ???? ?? ????????? ??? ???? ????????? ????????? ????? ???? ??????? SQL Server 2005 R2? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft":
937137 ???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 Service Pack 2
960598 ???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 Service Pack 3
2485757 ???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 Service Pack 4

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

???? ?????? ?????? ??? ????? ????? Sqlservr.exe.
?? ??? ??????????? ??? ??????
???????????? ??????
SQL Server 2000 Service Pack 48.00.2039
SQL Server 2000 Service Pack 38.00.760
SQL Server 2000 Service Pack 38.00.760
SQL Server 2000 Service Pack 28.00.534
SQL Server 2000 Service Pack 18.00.384
SQL Server 2000 RTM8.00.194
????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
290211 ????? ?????? ??? ???? ???? ???? ????? SQL Server 2000

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

?????? ????? SQL Server Reporting Services? ???? ??????? ?????? ?? "??? SQL Server":
?????: ????? ?? ??????? ??????? (????? ????????)

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

?????? ??????? ?? ????? ????? ???? SQL? ???? ??????? ??????? ?? "????? ??????? ? Microsoft":
942177 ????? ????? ????? SQL Server ????? Services

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

?????? ????? SQL Server Analysis Services? ?????? ???? ????? ???????:

??????? ??????: ??????? ????? ???????? ?????? ?????? ?? Studio ????? ???? SQL. ??? ??????? ?? Object Explorer? ????? ???? ??????? ??????? ??? ????? ? ?? ??? ???????? ????????? ??????? ????? ????? ?? Analysis Services.

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

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

??????? ???????: ??????? ?????? ??????? ??????? ?? ?????? ??????.
?? ??? ??????????? ??? ??????
????? ??????? ????????? Analysis Services??????
2008 R2????? \MSSQLServer\CurrentVersion Server\MSAS10_50.InstanceName SQL HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft: CurrentVersion



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

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



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.?????? \Setup\ ??? ??????: ?????????? ???????? ??????

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



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

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

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

????? ?? ?????????? ?? ?????? ??????? Microsoft TechNet ???????:
????? ????? ?? "????? ???? ??????? ????????? "Analysis Services Server Version"

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

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

??? ???? ??????? ?? ???? Distribution Agent ?? Transactional ?? ??? ?????? ???? ??? ???? ??? ????? ????????? ???? ????? ?? ???? ?????? ????? ?? SQL Server ??? ???? ??? ??????? ????? ???? ?????? SQL Server ?? ??? ????????.

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

?????? ??? ???? ?? ?????????? ???? ???????? ??????? ?? "SQL Server Books Online ??? ????????":
??????? ??????? ?????? ?? SQL Server ?? ???????? ????? ????????

??? ?? ????

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

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

?????? ?? ?? ??? ???????? ?? ???? ??? ?? ????? ???????? ??? ?? ???? ????? ???? ?? ??????? ?????? ?? ???? ????? ?????? ?? RTM. ??? ?? ??? ????? ????? ??? ??????? ?? ??????? ????????.

??????? ??????: ???? ?? ????? SQL Server Full-Text Key (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>

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

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

???? ??????? ??????? ?? ????? ????? Microsoft ?????? ??? ????? ?????? ??????? ??? ?? ???? ?? ?????? ????? SQL Server 2008.
973888 ?? ??? ????? ???? ??? ?? ???? ??? ????? ??????? ?????? Service Pack 1 ??? ????? ????? ??????? ???????? 3 ?? SQL Server 2008 Service Pack 1 ???? ?? ??????? ???????? ????? ????

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

????? ??????? MDS ??? ????? ??? ??????? ?????? ????? ??????.

??? ?? ???? ??? ??? ?? MDS ?? ??????? ????? ????? ???? ??? ?? ????? ????? ???? ????? ?????? SQL Server ??? ???????? ?? ???? ?????? ?????? MDS. ?? ????? ??????? ??? ?????? ????? ????? SQL Server ?????????? ???? ?? ????? ?? ???? MDS ??? ????? ?????? ???? ?????? MDS. ??????? ??????? ???? ?????? ???? ???? ????? MDS ?????? ?????? ?????? ????? MDS ??? ????? ??????? ????? ????????. ????? ?????? ??? ????? ??? ??????? ??????? ??? ?????? ??????? ?????? ?????? ???? ???? MDS:
????? ?????? ????????? ????????? ?? SQL Server 2008 R2 Master Data Services (MDS)

????? ????? ??????? ?????? ????????? ???????? ???? ?? ??????? ??? ???? SQL. ?? ???? ???? ???????? ?? ????? ??? ??????? ???? ??? ????? ????? ?????? ??????? ??? ?? ????? ????? ????? MDS.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Master Data Services 10.5\CurrentVersion

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

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

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

??????? ??????: ??? ?????? ?????? ???? ???? ?????? ??? ????? ?? "?????? ??????"? ??? ????? ????? ODBC (odbcad32.exe) ??? ?? ???? ?? ??????? ???? ??? ????? ??????? ?? ????? ???????.

??????? ???????: ???? ?? ?????? ????????? ?? ????? ??????? ?? ????? ??????? ???????.
?? ??? ??????????? ??? ??????
????? SQL/
????? SQL Server Native Client
?????? ???????
SQL Server 2008 R2
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL Server 2008 /
SQL Server Native Client 10
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL Server 2005/
???? SQL Server ?????? 9
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion
SQL Server 2012HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI11\CurrentVersion

?????? ???? SQL

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

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

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

Microsoft.NET Framework

?????? ??????? ??.NET Framework ??? ?????? ????? ??? ???? ??????? ??????? ?? "????? ??????? ? Microsoft":
318785 ????? ????? ?? ????????? ???????? ???? ?????? Microsoft.NET Framework ?????
????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
2027770 ??? ??????? .NET Framework ?? ????????? ???????? ?? SQL Server

SQL Azure

?????? ??? ??????? ????? ?? ???? SQL Azure ?????????? ??? ?????? ???? ??????? ?????? ?? ???:
SERVERPROPERTY (SQL Azure Database)

SQL Server CE

?????? ??? ??????? ????? ?? ???? SQL Server CE ?????????? ??? ?????? ???? ??????? ???????:
  • ??????? SQL Server Compact Release
  • 325808 ??????? ???????? SQL Server 2000 Windows CE Edition ??????????

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

SQL Server 7.0

??????? ??? ??????? ?? ?????? ?????? ?????? ????? ???? ?????? ?? ??????.
?? ??? ??????????? ??? ??????
??? ???????Service pack
7.00.1063SQL Server 7.0 Service Pack 4
7.00.961SQL Server 7.0 Service Pack 3
7.00.842SQL Server 7.0 Service Pack 2
7.00.699SQL Server 7.0 Service Pack 1
7.00.623RTM SQL Server 7.0

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
301511 ????? ?????? ??? ???? ???? ???? ? SQL Server 7.0

SQL Server 6.5

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

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
273914 ????? Readme.txt for SQL Server 6.5 post-Service Pack 5a

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

? 1: ??? ???? ????? ????? SQL Server ????? ??? ????? SQL Server?

A1: ????? ????? ????? SQL Server ???????? ??????? ??????? ?? ??????? ??????? (? SQL Server 2008 ?? ????????? ??????) ?? ????? "????? ????? ?? ????? ???? ????? ?????? ???? SQL ??? ???????" ?? ??? ???????.

? 2: ????? ?????? ?????? ??????? ???????? ?????? ?????????

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

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

??????? ???????? (CU):?? ????? ?????? ????? ???? ????????? ??????? ??????? ???? ????? ??????? ??? ????? ????????. ???????? ??? ???? ????? ??????? ???????? ??????? ??????? ??? ??????? ???? ??????? ??????. ?? ????? ??? ???????? ???? ??????? ?????? ?? ??????? ??? ?????? ?? ??? ???? ????? ??????? ?? ????? ???????? ???????? ???? ??? ??????? ? ?????? ????.

??????? ??????:????? ?????? ??????? ??????? ????? ?????? ?? ???? ??? ????????? ??????? ????? ???? ?? ??? ???????? ????? ??????? ??? ??????? ??????? ???? ????? ?????. ????? ???? ????? ???? ???? ???? ??? ?? ??? ??????? ???? ????? ??????.

RTM: ????? ?? ???? "??? ????? ???????." ???????? ???? ??? SQL Server? ??? ???? ??? ?? ?? ???? ??? ???? ?? ??????? ????? ?? ??????? ??????.

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

???? ??????: ?????? ????????? ??????? ???????? ?????????? ?????????? ??????? ?????????? ???????? ??????????. ??? ????? ??? ?????? ????? ??????? ?????? ???????? ???? ??? ?????? ????? ??????? ??? ????? ?????? ???????? ??? ??? ????? ?? ??????? ?? ????????? ?? ??????? ???? ??? ??????? ????? ??? ??? ???????.

????? ?? ?????????? ?? ?????? ??????? ??????? ??? ?????:
  • 822499 ???? ??????? ???? ??????? ????? Microsoft SQL Server
  • 824684 ??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
  • 935897 ????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
  • http://en.wikipedia.org/wiki/Software_release_life_cycle

??????? ????

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

?????? ?????? ??????? ?????? ??? ??????? ???? ????? ??? ??? ??????.
?? ??? ??????????? ??? ??????
??? ????? ??????? ?? ?????????? ?????? (KB numberfor ???? ???? ??????)? ????? ???????

SQL Server 2012

?? ??? ??????????? ??? ??????
11.0.3349.00???? ?????? SP1 ?? #3 (2812412) 18 ???? 2013
11.0.3339.00???? ?????? SP1 ?? #2 (2790947) 21 ????? 2013
11.0.3321.00???? ?????? SP1 ?? #1 (2765331) 20 ?????? 2012
11.0.3000.00???? ?????? SP1 RTW/???? 1(2674319)? 7 ?????? 2012
11.0.2405.00RTM 15 ????? 2013 ???? #7 (2823247)
11.0.2401.00RTM 18 ?????? 2013 ???? #6 (2728897)
11.0.2395.00RTM ????? #5 (2777772) ?? 17 ?????? 2012
11.0.2383.00RTM ????? #4 (2758687) ?? 15 ???? 2012
11.0.2332.00RTM ????? #3 (2723749) ?? 31 ???? 2012
11.0.2325.00RTM 18 ????? 2012 ???? #2 (2703275)
11.0.2316.00RTM ????? #1 (2679368) ?? 12 ????? 2012
11.0.2100.60RTM ? 6 ???? 2012

SQL Server 2008 R2

?? ??? ??????????? ??? ??????
10.50.4279.00???? ?????? SP2 ?? #6 (2830140) 15 ????? 2013
10.50.4276.00???? ?????? SP2 ?? #5 (2797460) 18 ?????? 2013
10.50.4270.00???? ?????? SP2 ?? #4 (2777358) 17 ?????? 2012
10.50.4266.00???? ?????? SP2 ?? #3 (2754552) 15 ???? 2012
10.50.4263.00???? ?????? SP2 ?? #2 (2740411) 31 ???? 2012
10.50.4260.00???? ?????? SP2 ?? #1 (2720425) 24 ????? 2012
10.50.2874.00???? ?????? SP1 ?? #12 (2828727) 15 ????? 2013
10.50.2869.00???? ?????? SP1 ?? #11 (2812683) 18 ?????? 2013
10.50.2868.00???? ?????? SP1 ?? #10 (2783135) 17 ?????? 2012
10.50.2866.00???? ?????? SP1 ?? #9 (2756574) 15 ???? 2012
10.50.2822.00???? ?????? SP1 ?? #8 (2723743) 31 ???? 2012
10.50.2817.00???? ?????? SP1 ?? #7 (2703282) 18 ???? 2012
10.50.2811.00???? ?????? SP1 ?? #6 (2679367) 16 ????? 2012
10.50.2806.00SP1 CU #5 (2659694) 22 ?????? 2012
10.50.2796.00SP1 CU #4 (2633146) 19 ?????? 2011
10.50.2789.00SP1 CU #3 (2591748) 17 ?????? 2011
10.50.2772.00SP1 CU #2 (2567714) 15 ????? 2011
10.50.2769.00SP1 CU #1 (2544793) 18 ????? 2011
10.50.2500.0SP1 RTW/PCU 1(2528583)? 12 ????? 2011
10.50.1815.00RTM 16 ????? 2012 ???? #13 (2679366)
10.50.1810.00RTM CU #12 (2659692) 21 ?????? 2012
10.50.1809.00RTM CU #11 (2633145) ?????? 2011
10.50.1807.00RTM CU #10 (2591746) ?????? 2011
10.50.1804.00RTM CU #9 (2567713) ????? 2011
10.50.1797.00RTM CU #8 (2534352) 20 ????? 2011
10.50.1777.00RTM CU #7 (2507770) 18 ????? 2011
10.50.1765.00RTM ????? #6 (2489376) 21 ?????? 2011
10.50.1753.00RTM CU #5 (2438347)20 ?????? 2010
10.50.1746.00RTM CU #4 (2345451)18?????? 2010
10.50.1734.00 RTM CU #3 (2261464) 16 ????? 2010
10.50.1720.00 RTM CU #2 (2072493) 21 ????? 2010
10.50.1702.00 RTM CU #1 (981355)18 ???? 2011
10.50.1617.00??????? ?????? GDR (2494088)? 21 ????? 2011
10.50.1600.1 RTM ? 10 ???? 2010

SQL Server 2008

?? ??? ??????????? ??? ??????
10.00.5835.00SP3 ?? #10 (2814783) 18 ???? 2013
10.00.5829.00SP3 ?? #9 (2799883) 21 ????? 2013
10.00.5828.00SP3 ?? #8 (2771833) 19 ???? 2012
10.00.5794.00SP3 ?? #7 (2738350) 17 ???? 2012
10.00.5788.00SP3 ?? #6 (2715953) 16 ????? 2012
10.00.5785.00SP3 ?? #5 (2696626) 21 ???? 2012
10.00.5775.00SP3 ?? #4 (2673383) 19 ???? 2012
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 ?????? 2011
10.00.5500.00???? ?????? SP3 RTW/???? ????? 3 (2546951) 6 ?????? 2011
10.00.4333.00???? ?????? SP2 ?? #11 (2715951) 16 ????? 2012
10.00.4332.00???? ?????? SP2 ?? #10 (2696625) 21 ???? 2012
10.00.4330.00???? ?????? SP2 ?? #9 (2673382) 19 ???? 2012
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) 18 ????? 2011
10.00.4285.00SP2 CU #4 (2527180) 16 ???? 2011
10.00.4279.00SP2 CU #3 (2498535) 17 ???? 2011
10.00.4272.00???? ?????? SP2 ?? #2 (2467239) 17 ????? 2011
10.00.4266.00???? ?????? SP2 ?? #1 (2289254) 15 ?????? 2010
10.00.4064.00??????? ?????? GDR(2494089)? 24 ????? 2011
10.00.4000.00???? ?????? SP2 RTW/???? ????? 2 (2285068) 29 ?????? 2010
10.00.2850.0SP1 CU #16 (2582282) 19 ?????? ? 2011
10.00.2847.0???? ?????? SP1 ?? #15 (2555406) 18 ????? 2011
10.00.2821.00SP1 CU #14 (2527187) 16 ???? 2011
10.00.2816.00SP1 CU #13 (2497673)17 ???? 2011
10.00.2808.00SP1 CU #12 (2467236) 17 ????? 2011
10.00.2804.00SP1 CU #11 (2413738) 15 ?????? 2010
10.00.2799.00???? ?????? SP1 ????? #10 (2279604) 20 ?????? 2010
10.00.2789.00SP1 CU #9 (2083921) 19 ???? 2011
10.00.2775.00SP1 CU #8 (981702) 17 ???? 2011
10.00.2766.00???? ?????? SP1 ?? #7 (979065) 26 ???? 2010
10.00.2757.00???? ?????? SP1 ?? #6 (977443) 18 ????? 2010
10.00.2746.00???? ?????? SP1 ?? #5 (975977) 16 ?????? 2009
10.00.2734.00???? ?????? SP1 ????? #4 (973602) 21 ?????? 2009
10.00.2723.00???? ?????? SP1 ?? #3 (971491) 20 ????? 2009
10.00.2714.00 SP1 CU #2 (970315) 18???? 2011
10.00.2710.00SP1 CU #1 (969099) 16 ????? 2009
10.00.2573.00 ??????? ?????? GDR (2494096)? 24 ????? 2011
10.00.2531.00 ???? ?????? SP1 RTW/???? ????? 1 ?????? 2009
10.00.1835.00 RTM CU #10 (979064) 15 ???? 2010
10.00.1828.00 RTM CU #9 (977444) 18 ????? 2010
10.00.1823.00 RTM CU #8 (975976) 16 ?????? 2009
10.00.1818.00 RTM CU #7 (973601)21 ?????? ? 2009
10.00.1812.00 RTM CU #6 (971490)20 ?????? 2008
10.00.1806.00 RTM CU # 5 (969531) 18 ???? 2009 SP1
10.00.1798.00 RTM 16 ???? 2009 ????? #4 (963036)
10.00.1787.00 RTM ????? #3 (960484) 19 ????? 2009
10.00.1779.00 RTM ????? #2 (958186) 19 ?????? 2008
10.00.1763.00 RTM CU # 1 (956717) 22 ?????? 2008
10.00.1600.22 RTM ? 6 ????? 2008

SQL Server 2005

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

SQL Server 2000

?? ??? ??????????? ??? ??????
8.00.2283Post-SP4 ??????? ?????? ????? ?? MS09-004 (971524)
8.00.2282MS09-004: ?????? KB959420 29,2008
8.00.2273MS08-040 - KB 948111 8 ????? 2008
8.00.2040????? Post-SP4 AWE (899761)
8.00.2039SQL Server 2000 SP4
8.00.1007Update.exe Hotfix Installer Baseline 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 ???? ????????? ???????? ???? ?? ??????? v.1
8.00.534 SQL Server 2000 SP2
8.00.384 SQL Server 2000 SP1
8.00.194 SQL Server 2000 RTM or MSDE 2.0

???????

???? ???????: 321185 - ????? ??? ??????: 28/????? ???????/1434 - ??????: 20.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
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
????? ??????: 
kbsqlsetup kbhowtomaster kbmt KB321185 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????321185

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

 

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