Microsoft sql server 2005 для windows server 2003 - Доктор Windows

Эта информация была полезна?
0
m
n
0
‘

Требования к аппаратному обеспечению

Минимальные:

Процессор: Intel (или совместимый) Pentium III 600 МГц или выше;
Память: 512 МБ или более (192 МБ для Express Edition);
Жесткий диск: 10 ГБ или более.

Рекомендуемые:

Процессор: Intel Pentium4 3000 МГц или выше;
Память: 1024 МБ или более;
Жесткий диск: 100 ГБ или более.

Требования к программному обеспечению

Необходимо наличие установленных пакетов: MDAC 2.8 (входит в XP), Windows Installer 3.1 и Microsoft .NET Framework 2.0.
Операционная система: MS Windows 2000 SP4 (Server, Advanced Server или Data Center Server), MS Windows 2003 Server SP1 (Standard Edition, Enterprise Edition, Data Center Edition), MS Windows 2003 Small Business Server SP1 (Standard Edition, Premium Edition).
Кроме того, некоторые редакции SQL Server 2005, в том числе бесплатную редакцию (Express Edition), можно устанавливать на следующие ОС: MS Windows 2000 SP4 (Professional Edition), MS Windows XP SP2 (Home Edition, Professional Edition, Media Center Edition, Tablet Edition), MS Windows 2003 SP1 (Web Edition).

Примечание. 64-разрядные редакции SQL Server 2005 предъявляют другие требования к аппаратно-программному обеспечению. Более подробную информацию можно найти на сайте корпорации Microsoft.

Для «тихой» установки (со стандартными параметрами) бесплатной версии SQL Server Express Edition With Advanced Services запустите программу установки компании «Альта-Софт» (setup.exe или altastp.exe) с правами администратора и воспользуйтесь кнопкой «SQL» (при запуске с фирменного DVD-диска доступ в интернет не потребуется). При необходимости проделайте дополнительные действия, описанные в примечаниях про Брандмауэр (FireWall) и Не русскоязычную ОС, все остальные нижеописанные действия выполнять уже не понадобится. Для доступа к SQL Server с правами администратора используйте логин «sa» и пароль «Alta-Soft», либо вариант «Авторизация Windows», зайдя в систему под учетной записью администратора локального компьютера.

Установка MS SQL Server 2005

Запустить программу-установщик (в бесплатной версии Express Edition обычно называется SQLEXPR_ADV_RUS.EXE) с правами администратора на данном компьютере.
Прочитать лицензию, установить галочку и нажать кнопку «Далее»:

Нажать кнопку «Установить»:

Нажать кнопку «Далее»:

Нажать кнопку «Далее»:

Нажать кнопку «Далее»:

Примечание. Если кнопка «Далее» недоступна, то проверить выполнение всех аппаратно-программных требований.

Снять галочку «Скрыть дополнительные параметры…», ввести регистрационные сведения и нажать кнопку «Далее»:

Выбрать ВСЕ доступные компоненты для установки, и нажать кнопку «Далее»:

Внимание! Для нормального функционирования ПО «Альта-ГТД» требуется установить «Компонент Full-Text Search» (д.б. помечен белым прямоугольником)!
Кроме того, для управления самим SQL Server необходимо установить компонент «Среда Management Studio»!

Примечание. С помощью кнопки «Обзор» можно указать путь для размещения файлов текущего компонента (например, для хранения «Файлов данных» рекомендуется использовать отдельный от ОС физ. диск).

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Примечание. В большинстве случаев рекомендуется использовать для запуска служб SQL Server встроенную учетную запись «Локальная система» (не путать с «Локальная служба»!). Однако, если Вы устанавливаете НЕ бесплатную версию SQL Server (Standard Edition, Enterprise Edition и т.п.) и хотите использовать «SQL Server Agent» (встроенный планировщик заданий, в бесплатную версию не входит) для выполнения регулярного резервного копирования файлов БД на другой компьютер в своей локальной сети (рекомендуется) и Ваша сеть построена с использованием домена Windows NT, то необходимо завести в Вашем домене отдельную учетную запись для SQL Server и предоставить ей права на соответствующие ресурсы (более подробную информацию можно найти в справочной системе SQL Server). При такой конфигурации, в этом окне необходимо указать имя домена, учетную запись и ее пароль.

Выбрать смешанный режим проверки подлинности и задать пароль для системной учетной записи «sa» (эта учетная запись обладает максимальными правами доступа ко всем функциям и объектам на SQL Server). Нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Внимание! Данную настройку нельзя будет изменить после установки. Будьте внимательны!

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Нажать кнопку «Установить»:

После завершения установки нажать кнопку «Далее»:

Нажать на ссылку «Средство настройки контактной зоны»:

Нажать на ссылку «Настройка контактной зоны для служб и соединений»:

В разделе «Удаленные соединения» установить переключатель «Локальные и удаленные соединения» и «Использовать только TCP/IP»:

Примечания:

Если НЕ предполагается подключаться к данному SQL-серверу с других компьютеров, то шаги 17 – 19 можно пропустить.
Если же подключаться предполагается и при этом на компьютере установлен какой-либо FireWall, то в нем необходимо разрешить входящие соединения по протоколу TCP/IP на порт 1433 (для подключения к SQL Server с других компьютеров), а также по протоколу UDP на порт 1434 (для того чтобы другие компьютеры могли обнаруживать данный экземпляр SQL Server). В стандартном «Брандмауэре Windows» (Панель управления→Брандмауэр Windows) для этого необходимо на закладке «Исключения» дважды «Добавить порт»:

Примечание. В Windows 7 вместо этого надо создать два правила – см. статью

Нажать кнопку «Готово» в окне шага 17.
После завершения установки рекомендуется перезагрузить компьютер или, как минимум, перезапустить службу SQL Server (Пуск→Все программы→Microsoft SQL Server 2005→Средства настройки→Диспетчер конфигурации SQL Server):

ВНИМАНИЕ! При установке SQL Server на НЕ русскоязычную ОС Windows необходимо в «Control Panel»→«Regional and Language Options» на закладке «Advanced» поставить язык «Russian» в параметре «Language for non-Unicode programs», затем перезагрузить компьютер:

Эта информация была полезна?
0
m
n
0
‘

Источник

README

This is a document of the steps taken to install SQL Server 2005 on Windows Server 2003 R2.

Background

I am trying to create a fail-over cluster installation of MS SQL Server 2005.

I followed the instructions on MSDN. They do not work (for me).

Installation to both nodes in the cluster fails as the target drives are only available on the active node in the cluster group. The setup process does not move the group to a node before starting the installation on it. Nice.

Attempting installation on a single node in the cluster group also fails. This is where this document comes in handy.

When installation of the database engine fails it is uninstalled. This does not make debugging easier.

Server Specification

Processors
- 2 X 3.896 GHz
Memory
- 5120 MB
CD/DVD Drive 1 (IDE 1:0)
SCSI Controller 0
- LSI Logic
SCSI Controller 1
- LSI Logic
Network Adapter 1
- VMnet2
Network Adapter 2
- VMnet3
Hard Disk 1 (SCSI 0:0)
- 32.00 GB
- OS
Hard Disk 2 (SCSI 1:0)
- 624.00 GB
- V:
- SQL-DATA
Hard Disk 3 (SCSI 1:1)
- 208.00 GB
- U:
- SQL-LOG
Hard Disk 4 (SCSI 1:2)
- 48.00 GB
- T:
- tempdb
Hard Disk 5 (SCSI 1:3)
- 512 MB
- M:
- DTC
Hard Disk 6 (SCSI 1:4)
- 512 MB
- Q:
- Quorum
Hard Disk 7 (SCSI 1:5)
- 250 MB
- D:
- SQL-INSTALLER (Sucks)

Hosts

There are two hosts in the cluster group

2k3-sql-05de01a

IP Address
- 192.168.2.71
  LAN
- 192.168.3.71
  Heartbeat

2k3-sql-05de01b

IP Address
- 192.168.2.72
  LAN
- 192.168.3.72
  Heartbeat

Cluster Administrator

There are three cluster groups

Cluster Group
- Cluster Disk (Q:)
- Cluster IP Address
  - 192.168.2.76
- Cluster Network Name
  - 2k3-sql-05de01m
MSDTC
- MSDTC
- MSDTC Disk (M:)
- MSDTC IP Address
  - 192.168.2.77
- MSDTC Network Name
  - 2k3-sql-05de01t
MSSQL
- MSSQL Data Disk (V:)
- MSSQL Installer Disk (D:)
- MSSQL Log Disk (U:)
- MSSQL Tempdb Disk (T:)

The ‘m’ is for cluster management and the ‘t’ is for distributed transaction coordinator.

Domain Accounts

First	Middle	Last	Login
Cluster		Service	cluster
SQL	Server	Database	ssde
SQL	Server	Agent	ssag
SQL	Services	Analysis	ssas
SQL	Services	Reporting	ssrs
SQL	Services	Notification	ssns
SQL	Services	Integration	ssis
SQL	Server	Browser	ssbr
SQL	Server	Full Text Search	ssft

The accounts

ssde
ssag

are made Local Administrators on both of the cluster nodes.

Setup

I run the installer selecting

Database (fail-over)
Notification Services
Integration Services
Workstation Components

I complete the cluster information

IP Address
LAN / 192.168.2.70 / 255.255.255.0
Network Name
2k3-sql-05de01
Cluster Group
MSSQL / V: Drive

I customize the accounts using those created on the domain earlier.

Go!

Fail

When it gets to the database engine it tells me it has failed. I can retry or cancel.

I’ll retry …

Analyze Errors

I now run the SQL Server Database Engine from the console.

C:Documents and Settingsswenmouth>cd «Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn»

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn>sqlservr.exe -c
2012-02-09 01:31:56.21 Server Authentication mode is MIXED.

2012-02-09 01:31:56.30 Server Microsoft SQL Server 2005 — 9.00.1399.06 (X64)
    Oct 14 2005 00:35:21

    Copyright (c) 1988-2005 Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
2012-02-09 01:31:56.30 Server (c) 2005 Microsoft Corporation.

2012-02-09 01:31:56.30 Server All rights reserved.

2012-02-09 01:31:56.30 Server Server process ID is 3040.

2012-02-09 01:31:56.30 Server Logging SQL Server messages in file ‘V:Micro soft >
SQL ServerMSSQL.1MSSQLLOGERRORLOG’.

2012-02-09 01:31:56.30 Server Registry startup parameters:

2012-02-09 01:31:56.33 Server -d V:Microsoft SQL ServerMSSQL.1MSSQ >
LDATAmaster.mdf

2012-02-09 01:31:56.33 Server -e V:Microsoft SQL ServerMSSQL.1MSSQ >
LLOGERRORLOG

2012-02-09 01:31:56.33 Server -l V:Microsoft SQL ServerMSSQL.1MSSQ >
LDATAmastlog.ldf

2012-02-09 01:31:56.33 Server Command Line Startup Parameters:

2012-02-09 01:31:56.33 Server -c

2012-02-09 01:31:56.51 Server SQL Server is starting at normal priority bas e (=7). This is an informational message only. No user action is required.

2012-02-09 01:31:56.51 Server Detected 2 CPUs. This is an informational mes sage; no user action is required.

2012-02-09 01:31:56.85 Server Error: 8316, Severity: 16, State: 1.

2012-02-09 01:31:56.85 Server Cannot open registry key ‘HKLMSYSTEMCurrent ControlSetServicesMSSQLSERVERPerformance’. SQL Server performance counters ar e disabled.

2012-02-09 01:31:57.60 Server Using dynamic lock allocation. Initial alloc ation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an infor mational message only. No user action is required.

2012-02-09 01:31:58.15 Server Attempting to initialize Microsoft Distribute d Transaction Coordinator (MS DTC). This is an informational message only. No us er action is required.

2012-02-09 01:32:00.75 Server Attempting to recover in-doubt distributed tr ansactions involving Microsoft Distributed Transaction Coordinator (MS DTC). Thi s is an informational message only. No user action is required.

2012-02-09 01:32:00.83 Server Database Mirroring Transport is disabled in t he endpoint configuration.

2012-02-09 01:32:01.00 spid5s Starting up database ‘master’.

2012-02-09 01:32:01.80 spid5s Recovery is writing a checkpoint in database ‘master’ (1). This is an informational message only. No user action is required.

2012-02-09 01:32:02.58 spid5s SQL Trace ID 1 was started by login «sa».

2012-02-09 01:32:02.91 spid5s Starting up database ‘mssqlsystemresource’.

2012-02-09 01:32:02.91 spid5s Error: 17207, Severity: 16, State: 1.

2012-02-09 01:32:02.91 spid5s FCB::Open: Operating system error 3(The syste m cannot find the path specified.) occurred while creating or opening file ‘D:W INDOWSTEMPmkmastr_resultmssqlsystemresource.mdf’. Diagnose and correct the op erating system error, and retry the operation.

2012-02-09 01:32:02.96 spid5s Error: 17204, Severity: 16, State: 1.

2012-02-09 01:32:02.96 spid5s FCB::Open failed: Could not open file D:WIND OWSTEMPmkmastr_resultmssqlsystemresource.mdf for file number 1. OS error: 3( The system cannot find the path specified.).

2012-02-09 01:32:03.01 spid5s Error: 5120, Severity: 16, State: 101.

2012-02-09 01:32:03.01 spid5s Unable to open the physical file «D:WINDOWS TEMPmkmastr_resultmssqlsystemresource.mdf». Operating system error 3: «3(The s ystem cannot find the path specified.)».

2012-02-09 01:32:03.33 spid5s Error: 17207, Severity: 16, State: 1.

2012-02-09 01:32:03.33 spid5s FileMgr::StartLogFiles: Operating system erro r 2(The system cannot find the file specified.) occurred while creating or openi ng file ‘D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf’. Diagnose and c orrect the operating system error, and retry the operation.

2012-02-09 01:32:03.35 spid5s File activation failure. The physical file na me «D:WINDOWSTEMPmkmastr_resultmssqlsystemresource.ldf» may be incorrect.

2012-02-09 01:32:03.38 spid5s Error: 945, Severity: 14, State: 2.

2012-02-09 01:32:03.38 spid5s Database ‘mssqlsystemresource’ cannot be open ed due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

2012-02-09 01:32:03.40 spid5s SQL Trace was stopped due to server shutdown. Trace ID = ‘1’. This is an informational message only; no user action is requir ed.

Okey dokes — it thinks the database is somewhere it is not.

FIX

Create the missing directory

C:Documents and Settingsswenmouth>mkdir D:WINDOWSTEMPmkmastr_result

Copy the files

C:Documents and Settingsswenmouth>copy «V:Microsoft SQL ServerMSSQL.1MSSQLDatamssqlsystemresource.*» D:WINDOWSTEMPmkmastr_result

V:Microsoft SQL ServerMSSQL.1MSSQLDatamssqlsystemresource.ldf

V:Microsoft SQL ServerMSSQL.1MSSQLDatamssqlsystemresource.mdf
    2 file(s) copied.

Try Starting SQL Server (Again)

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn>sqlservr.exe -c -f -T3608

2012-02-09 01:40:09.26 Server Authentication mode is MIXED.

2012-02-09 01:40:09.27 Server Microsoft SQL Server 2005 — 9.00.1399.06 (X64)
    Oct 14 2005 00:35:21
    Copyright (c) 1988-2005 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
2012-02-09 01:40:09.27 Server (c) 2005 Microsoft Corporation.

2012-02-09 01:40:09.27 Server All rights reserved.

2012-02-09 01:40:09.27 Server Server process ID is 956.

2012-02-09 01:40:09.27 Server Logging SQL Server messages in file ‘V:Micro soft SQL ServerMSSQL.1MSSQLLOGERRORLOG’.

2012-02-09 01:40:09.27 Server This instance of SQL Server last reported usi ng a process ID of 2044 at 2/9/2012 1:40:07 AM (local) 2/9/2012 7:40:07 AM (UTC) . This is an informational message only; no user action is required.

2012-02-09 01:40:09.27 Server Registry startup parameters:

2012-02-09 01:40:09.27 Server -d V:Microsoft SQL ServerMSSQL.1MSSQ LDATAmaster.mdf

2012-02-09 01:40:09.27 Server -e V:Microsoft SQL ServerMSSQL.1MSSQ LLOGERRORLOG

2012-02-09 01:40:09.29 Server -l V:Microsoft SQL ServerMSSQL.1MSSQ LDATAmastlog.ldf

2012-02-09 01:40:09.29 Server Command Line Startup Parameters:

2012-02-09 01:40:09.29 Server -c

2012-02-09 01:40:09.29 Server -f

2012-02-09 01:40:09.29 Server -T 3608

2012-02-09 01:40:09.29 Server Warning: The server instance was started usin g minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the serve r.

2012-02-09 01:40:09.29 Server SQL Server is starting at normal priority bas e (=7). This is an informational message only. No user action is required.

2012-02-09 01:40:09.29 Server Detected 2 CPUs. This is an informational mes sage; no user action is required.

2012-02-09 01:40:09.45 Server Using dynamic lock allocation. Initial alloc ation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an infor mational message only. No user action is required.

2012-02-09 01:40:09.49 Server Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using th e minimal configuration option. This is an informational message only. No user a ction is required.

2012-02-09 01:40:09.51 spid5s Warning ******************

2012-02-09 01:40:09.51 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2012-02-09 01:40:09.51 spid5s Recovering only master database because trace flag 3608 was specified. This is an informational message only. No user action i s required.

2012-02-09 01:40:09.51 spid5s Starting up database ‘master’.

2012-02-09 01:40:09.66 spid5s 2 transactions rolled forward in database ‘ma ster’ (1). This is an informational message only. No user action is required.

2012-02-09 01:40:09.73 spid5s Snapshot isolation or read committed snapshot is not available in database ‘master’ because SQL Server was started with one o r more undocumented trace flags that prevent enabling database for versioning. T ransaction started with snapshot isolation will fail and a query running under r ead committed snapshot will succeed but will resort back to lock based read comm itted.

2012-02-09 01:40:09.73 spid5s 0 transactions rolled back in database ‘maste r’ (1). This is an informational message only. No user action is required.

2012-02-09 01:40:09.73 spid5s Recovery is writing a checkpoint in database ‘master’ (1). This is an informational message only. No user action is required.

2012-02-09 01:40:09.80 spid5s Server started with ‘-f’ option. Auditing wil l not be started. This is an informational message only; no user action is requi red.

2012-02-09 01:40:09.82 spid5s Server name is ‘2K3-SQL-05DE01A’. This is an informational message only. No user action is required.

2012-02-09 01:40:10.10 Server A self-generated certificate was successfully loaded for encryption.

2012-02-09 01:40:10.10 Server Server is listening on [ ‘any’ 1433].

2012-02-09 01:40:10.12 Server Server local connection provider is ready to accept connection on [ .pipeSQLLocalMSSQLSERVER ].

2012-02-09 01:40:10.12 Server Server named pipe provider is ready to accept connection on [ .pipesqlquery ].

2012-02-09 01:40:10.12 Server Server is listening on [ 127.0.0.1 143 4].

2012-02-09 01:40:10.12 Server Dedicated admin connection support was establ ished for listening locally on port 1434.

2012-02-09 01:40:10.16 Server SQL Server is now ready for client connection s. This is an informational message; no user action is required.

2012-02-09 01:40:10.18 spid5s Recovery is complete. This is an informationa l message only. No user action is required.

Yay. This time it turns on.

Inspect file locations

C:Program FilesMicrosoft SQL Server90Toolsbinn>sqlcmd -U sa -d master -s «|» -W

Password:

1> SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files;

3> GO

name|CurrentLocation|state_desc

—-|—————|———-

master|V:Microsoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf|ONLINE

mastlog|V:Microsoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf|ONLINE

tempdev|D:WINDOWSTEMPmkmastr_resulttempdb.mdf|ONLINE

templog|D:WINDOWSTEMPmkmastr_resulttemplog.ldf|ONLINE

modeldev|D:WINDOWSTEMPmkmastr_resultmodel.mdf|ONLINE

modellog|D:WINDOWSTEMPmkmastr_resultmodellog.ldf|ONLINE

MSDBData|D:WINDOWSTEMPmkmastr_resultMSDBData.mdf|ONLINE

MSDBLog|D:WINDOWSTEMPmkmastr_resultMSDBLog.ldf|ONLINE

(8 rows affected)

Okay. We can see that

tempdb
model
msdb

are thought to be somewhere they’re not.

Update file locations

Here are a sequence of alter statements that will right the wrong file locations.

In between every section restart SQL Server at the command prompt (with Ctrl^C and re-run).

mssqlserverresource

ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=data, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamssqlsystemresource.mdf');
GO

ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=log, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamssqlsystemresource.ldf');
GO

master

ALTER DATABASE master MODIFY FILE (NAME=master, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamaster.mdf');
GO

ALTER DATABASE master MODIFY FILE (NAME=mastlog, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamastlog.ldf');
GO

model

ALTER DATABASE model MODIFY FILE (NAME=modeldev, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamodel.mdf');
GO

ALTER DATABASE model MODIFY FILE (NAME=modellog, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamodellog.ldf');
GO

msdb

ALTER DATABASE msdb MODIFY FILE (NAME=msdbdata, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamsdbdata.mdf');
GO

ALTER DATABASE msdb MODIFY FILE (NAME=msdblog, FILENAME= 'V:Microsoft SQL ServerMSSQL.1MSSQLDatamsdblog.ldf');
GO

tempdb

ALTER DATABASE tempdb MODIFY FILE (NAME=tempdev, FILENAME= 'T:Microsoft SQL ServerMSSQL.1MSSQLDatatempdb.mdf');
GO

ALTER DATABASE tempdb MODIFY FILE (NAME=templog, FILENAME= 'T:Microsoft SQL ServerMSSQL.1MSSQLDatatemplog.ldf');
GO

Try Again

Back in the setup process

Click Retry
Watch it fail
Read event log

Product: Microsoft SQL Server 2005 (64-bit) — Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, «How to: View SQL Server 2005 Setup Log Files» and «Starting SQL Server Manually.»
The error is (1069) The service did not start due to a logon failure.

Local Security Settings

The permissions from the Domain Security Group are not being picked up. Manually add permissions.

Permission	Code	ssde	ssag	ssas	ssrs	ssis	ssbr	ssft
Log on as a service	SeServiceLogonRight	Y	Y	Y	Y	Y	Y	Y
Act as part of the operating system	SeTcbPrivilege	Y	Y
Log on as a batch job	SeBatchLogonRight	Y	Y
Replace a process-level token	SeAssignPrimaryTokenPrivilege	Y	Y
Bypass traverse checking	SeChangeNotifyPrivilege	Y	Y			Y
Adjust memory quotas for a process	SeIncreaseQuotaPrivilege	Y	Y
Create global objects	SeCreateGlobalPrivilege					Y
Impersonate a client after authentication	SeImpersonatePrivilege					Y
Member of «Local Administrators»		Y	Y

Try Once Mode …

It works! Update the local security policy on the b node now.

Источник

Remove From My Forums

Вопрос
Подскажите, можно ли установить 32 битный SQL на 64 ось?

Ответы

В документе, который я приводил выше написано, что поддерживается установка версии MS SQL Server 2005 x32 на платформу MS Windows Server 2003 x64 (это не версия 64bit или Itanium).

Проверьте внимательно еще раз версии ПО, прочитайте документацию по установке SQL Server 2005.

—

А почему не ставите 64 разрядный SQL на 64 разрядную платформу?
- Помечено в качестве ответа
  Иван ПродановMicrosoft contingent staff, Moderator
  13 марта 2013 г. 14:13

Все ответы

Пожскажите как? постоянно выдаеться ошибка.

«Программа установки SQL Server 2005 не может продолжать работу, поскольку пакет установки небыл открыт. В пакете установки отсутствует файл, или на 64-разрядном компьютере запущена 32-разрядная версия програмы установки». Чтобы продолжить, убедитесь в том, что запущенный пакет SQL Server 2005 поддерживаеться на WOW64.»

Используеться лицензионный дистрибутив для установки.
Версии SQL Server и Windows Server 2003 сообщите.
Windows 2003 Server Standart R2 (sp2) x64
MS SQL 2005 Standart SP1 x32
S1on написано:

Windows 2003 Server Standart R2 (sp2) x64
MS SQL 2005 Standart SP1 x32

не «Windows 2003 Server», а Windows Server 2003 ..

точно x64 ? а может 64bit или слово Itanium не присутствует?

64bit, слово itanium невидел

В свойствах пишет что стоит 64х битная версия

Я недано ставил SQL 32 на 32х битную, все норм. А тут баг какойто :/
В документе, который я приводил выше написано, что поддерживается установка версии MS SQL Server 2005 x32 на платформу MS Windows Server 2003 x64 (это не версия 64bit или Itanium).

Проверьте внимательно еще раз версии ПО, прочитайте документацию по установке SQL Server 2005.

—

А почему не ставите 64 разрядный SQL на 64 разрядную платформу?
- Помечено в качестве ответа
  Иван ПродановMicrosoft contingent staff, Moderator
  13 марта 2013 г. 14:13
ок спс

—
«Потому что 64 только англиские, а надо русскую версию»

я долго смеялся когда услышал аргумент))
Ну и что? Чем закончилось приключение? У меня такая же ситуация, незнаю что и делать.

Источник

Требования к аппаратному обеспечению

Минимальные:

Процессор: Intel (или совместимый) Pentium III 600 МГц или выше;

Память: 512 МБ или более (192 МБ для Express Edition);

Жесткий диск: 10 ГБ или более.

Рекомендуемые:

Процессор: Intel Pentium4 3000 МГц или выше;

Память: 1024 МБ или более;

Жесткий диск: 100 ГБ или более.

Требования к программному обеспечению

Необходимо наличие установленных пакетов: MDAC 2.8 (входит в XP), Windows Installer 3.1 и Microsoft .NET Framework 2.0.

Операционная система: MS Windows 2000 SP4 (Server, Advanced Server или Data Center Server), MS Windows 2003 Server SP1 (Standard Edition, Enterprise Edition, Data Center Edition), MS Windows 2003 Small Business Server SP1 (Standard Edition, Premium Edition).

Кроме того, некоторые редакции SQL Server 2005, в том числе бесплатную редакцию (Express Edition), можно устанавливать на следующие ОС: MS Windows 2000 SP4 (Professional Edition), MS Windows XP SP2 (Home Edition, Professional Edition, Media Center Edition, Tablet Edition), MS Windows 2003 SP1 (Web Edition).

Примечание. Бесплатную версию MS SQL Server 2005 Express Edition можно скачать на сайте корпорации Microsoft:
SP2: http://www.microsoft.com/downloads/details.aspx… (рекомендуется)

SP3: http://www.microsoft.com/downloads/details.aspx… (могут быть проблемы с установкой)
Внимание! Для установки ПО «Альта ГТД-ПРО» необходимо скачивать редакцию «Express Edition with Advanced Services»!

Для «тихой» установки (со стандартными параметрами) бесплатной версии SQL Server Express Edition With Advanced Services поместите файл SetupSQL2005.cmd (находится в папке C:ALTAUTILS программы «Альта ГТД-ПРО») рядом со скаченным файлом-установщиком (см. ссылки выше) и запустите с правами администратора. При необходимости проделайте дополнительные действия, описанные в примечаниях про Брандмауэр (FireWall) и Не русскоязычную ОС, все остальные нижеописанные действия выполнять уже не понадобится. Для доступа к SQL Server с правами администратора используйте логин «sa» и пароль «alta», либо вариант «Авторизация Windows», зайдя в систему под учетной записью администратора локального компьютера.

Установка MS SQL Server 2005

Запустить программу-установщик (в бесплатной версии Express Edition обычно называется SQLEXPR_ADV_RUS.EXE) с правами администратора на данном компьютере.
Прочитать лицензию, установить галочку и нажать кнопку «Далее»:

Нажать кнопку «Установить»:

Нажать кнопку «Далее»:

Нажать кнопку «Далее»:

Нажать кнопку «Далее»:

Снять галочку «Скрыть дополнительные параметры…», ввести регистрационные сведения и нажать кнопку «Далее»:

Выбрать ВСЕ доступные компоненты для установки, и нажать кнопку «Далее»:

Внимание! Для нормального функционирования ПО «Альта ГТД-ПРО» требуется установить «Компонент Full-Text Search» (д.б. помечен белым прямоугольником)!
Кроме того, для управления самим SQL Server необходимо установить компонент «Среда Management Studio»!

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Выбрать смешанный режим проверки подлинности и задать пароль для системной учетной записи «sa» (эта учетная запись обладает максимальными правами доступа ко всем функциям и объектам на SQL Server). Нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Внимание! Данную настройку нельзя будет изменить после установки. Будьте внимательны!

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Выбрать опции, как показано на рисунке, и нажать кнопку «Далее»:

Нажать кнопку «Установить»:

После завершения установки нажать кнопку «Далее»:

Нажать на ссылку «Средство настройки контактной зоны»:

Нажать на ссылку «Настройка контактной зоны для служб и соединений»:

В разделе «Удаленные соединения» установить переключатель «Локальные и удаленные соединения» и «Использовать только TCP/IP»:

Примечания:

Если НЕ предполагается подключаться к данному SQL-серверу с других компьютеров, то шаги 17 – 19 можно пропустить.
Если же подключаться предполагается и при этом на компьютере установлен какой-либо FireWall, то в нем необходимо разрешить входящие соединения по протоколу TCP/IP на порт 1433 (для подключения к SQL Server с других компьютеров), а также по протоколу UDP на порт 1434 (для того чтобы другие компьютеры могли обнаруживать данный экземпляр SQL Server). В стандартном «Брандмауэре Windows» (Панель управления→Брандмауэр Windows) для этого необходимо на закладке «Исключения» дважды «Добавить порт»:

Нажать кнопку «Готово» в окне шага 17.
После завершения установки рекомендуется перезагрузить компьютер или, как минимум, перезапустить службу SQL Server (Пуск→Все программы→Microsoft SQL Server 2005→Средства настройки→Диспетчер конфигурации SQL Server):

Источник

Обновлено

2019-09-13 14:41:08

Совместимость

Windows 2000, Windows XP, Windows 2003

Описание

Чтобы управлять ресурсами, защитить сведения, обеспечить запланированную производительность, нужно скачать Microsoft SQL Server 2005 Express Edition. Приложение позволяет работать с локальными хранилищами данных, встроенными «клиентами», web-документами, не требующими вычислительных ресурсов.

Microsoft SQL Server 2005 Express Edition для Windows помогает быстро разворачивать и создавать прототипы, распространять файл с интегрированным пакетом. Установочный документ в свободном доступе, поэтому каждый вправе скачать и использовать на ПК бесплатно.

Главные особенности программы:

возможность интегрировать в Visual Studio, SQL Server Express Manager;
отсутствие трудностей с инсталляцией и настройкой;
повышенная продуктивность при облегченном создании и редактировании программных продуктов;
применение приложения в проектах немыслимых масштабов;
опытное внедрение в разрабатываемый программный продукт и контроль;
появление нового графического интерфейса;
допустимость загрузить бесплатно Microsoft SQL Server 2005 Express Edition и редактировать информацию;

Интегрированные функции:

генерирование запросов для поиска по тексту и отчетов служб;· усовершенствованное обращение к БД;
обмен информацией между платформами, объединение устройств для создания сети;
формирование БД размером до 4 Гб.

Для разработки и редактирования проектов на нашем сайте пользователь может скачать бесплатно микрософт скл сервер 2005 экспрес эдишн для компьютера с разрядностью х64.

Версии

Источник

В свое время из-за немного громоздкой политики по выпуску обновлений для Microsoft SQL Server путался какой же из дистриубтивов нужно установить и откуда его скачать. Углубившись в данную тематику, в интернете нашел замечательные систематизирующие ресусры, которые отвечали на мои вопросы (они приведены в начале статьи).

Надеюсь собранная информация будет полезна не только мне.

Github версия в формате markdown на английском языке: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Version.md

Также, вас возможно заинтересуют другие статьи о Microsoft SQL Server:

Полный список инструментов и утилит для Microsoft SQL Server (175 утилит и инструментов)
Полный список флагов трассировки Microsoft SQL Server (362 флага трассировки на текущий момент)
Разнообразие версий Microsoft SQL Server и какая из них последняя? (все версии от SQL Server 6.0 до V.Next)
Полный список расширений для SQL Server Management Studio (SSMS) (29 аддонов на текущий момент)
Список полезных ресурсов по Microsoft SQL Server (более 200 полезных ресурсов)
10 причин почему именно сейчас стоит попробовать Microsoft SQL Server

Заголовки:

Часто используемые термины и акронимы
Какие самые последние обновления доступны для SQL Server?
Установочные файлы Microsoft SQL Server с прямыми ссылками на загрузку
Версии SQL Server и уровни совместимости
Общая информация по Service Pack
Microsoft SQL Server VNext Builds
Microsoft SQL Server 2016 Builds
Microsoft SQL Server 2014 Builds
Microsoft SQL Server 2012 Builds
Microsoft SQL Server 2008 R2 Builds
Microsoft SQL Server 2008 Builds
Microsoft SQL Server 2005 Builds
Microsoft SQL Server 2000 Builds
Microsoft SQL Server 7.0 Builds
Microsoft SQL Server 6.5 Builds
Microsoft SQL Server 6.0 Builds

Полезные ссылки и статьи

Невероятная по объему и полезности статья — How to determine the version, edition and update level of SQL Server and its components: KB321185
Наименование схем обновления для Microsoft SQL Server: KB822499
Стандартная терминология, которая используется для описания обновлений ПО от Microsoft: KB824684
SQL Server Updates от Brent Ozar с возможность подписки: http://sqlserverupdates.com/
SQL Server Builds от SQLSentry: http://blogs.sqlsentry.com/category/sql-server-builds/
Неофициальный список обновлений для Microsoft SQL Server: http://sqlserverbuilds.blogspot.ru/
Wikipedia: https://en.wikipedia.org/wiki/Microsoft_SQL_Server
SQL Server 2005 Downloads: https://msdn.microsoft.com/en-us/sqlserver/bb671254.aspx
SQL Server 2000 Downloads: https://msdn.microsoft.com/en-us/sqlserver/bb895925
SQL Server 7.0 Downloads: https://msdn.microsoft.com/en-us/sqlserver/bb671066

Часто используемые термины и сокращения

COD Critical On-Demand (критическое обновление по требованию)

CU Cumulative Update (накопительное обновление)
CTP Community Technology Preview (CTP-версия)
GA General Availability (общедоступная версия
GDR General Distribution Release (обновление GDR)
QFE Quick Fix Engineering (обновление QFE) (в мире Windows, это называется LDR — Limited Release Distribution — но этот термин не прижился в команде SQL Server).
RC Release Candidate (версия-кандидат)
RDP Rapid Deployment Program
RTM Released To Manufacturing
RTW Release to Web
TAP Technology Adoption Program
SP Service Pack
SU: Обновление безопасности.
Hotfix

Обычно процедура установки SQL Server выглядит следующим образом:

Устанавливается нужная вам стабильная версия (на текущий момент рекомендуемые это 2014 или 2016)
Затем устанавливается последний из доступных сервис паков
Устанавливается последний накопительный пакет обнволений для устранения различного рода багов
В случае необходимости для устранения конкретных проблем устанавливается нужный Hotfix

Какие самые последние обновления доступны для SQL Server?

Версия	Последние обновления	Номер сборки	Дата релиза	Начало цикла	Поддержка	Расширенная поддержка	Другие обновления
vNext	Install vNext	14.0.200.24	2017-01-20	?	?	?	Other SQL vNext Updates
2016	Install 2016 SP1 then SP1 CU1 KB3208177	13.0.4001.0 13.0.4199.0	2016-11-16 2017-01-18	2016-11-16	2021-07-13	2026-07-14	Other SQL 2016 Updates
2014	Install 2014 SP2 Or Developer Free then KB3204388	12.0.5000.0 12.0.5538.0	2016-07-11 2016-12-28	2016-07-14	2019-07-09	2024-07-09	Other SQL 2014 Updates
2012	Install 2012 Or Developer Free then SP3 2012 then KB3205051	11.0.2100.60 11.0.6020.0 11.0.6579.0	2012-02-14 2015-11-21 2017-01-18	2015-12-01	2017-07-11	2022-07-12	Other SQL 2012 Updates
2008 R2	Install 2008 R2 then SP3 2008 R2 then SU KB3045311	6.1.7601.17514 10.50.6000 10.50.6220.0	2010-11-21 2014-09-30 2015-07-14	Review Note	2014-07-08	2019-07-09	Other SQL 2008 R2 Updates
2008	Install 2008 then SP4 2008 then SU KB3045316	6.0.6001.18000 10.00.6000 10.0.6241.0	2008-01-19 2014-09-30 2015-07-14	2014-07-07	2014-07-08	2019-07-09	Other SQL 2008 Updates
2005	Install SP4 2005 then CU3 KB2507769	9.00.5000.00 9.00.5266	2010-12-17 2011-03-17	2010-12-13	2011-04-12	2016-04-12	Other SQL 2005 Updates

Установочные файлы Microsoft SQL Server с прямыми ссылками на загрузку

SHA1 хэш можно легко получить с помощью встроенной Windows утилиты certutil.

Например, для одного файла:

certUtil -hashfile "d:SQL ServerSQLServer2014SP1-KB3058865-x64-ENU.exe" sha1

Или для всех файлов в директории, имеющих расширение .exe:

FOR /R "d:YaDsikBackupDistribSQL Server" %I IN (*.exe) DO certUtil -hashfile "%I" sha1

Direct x64 Download Link	File Name	Release Date	Build Number	Size, MB	SHA1
SQL Server vNext	SQLServerVnextCTP1-x64-ENU.iso	2017-01-20	14.0.200.24	1975	9a 29 ce b3 96 6e fe cb 08 fa 69 af 7c 99 7b dd 4b 68 32 41
SQL Server 2016	SQLServer2016-x64-ENU.iso	2016-06-01	13.0.1601.5	2050	ce 21 bf 1c 08 ec 1a c4 8e bb 49 88 a8 60 2c 78 13 03 4e a3
SQL Server 2016 SP1	SQLServer2016SP1-KB3182545-x64-ENU.exe	2016-11-16	13.0.4001.0	552	8c 6c f1 88 78 93 1d 8e fd 44 b9 52 e7 94 20 00 2b 8a 48 85
SQL Server 2016 SP1 KB3208177	SQLServer2016-KB3208177-x64.exe	2017-01-18	13.0.4411.0	439	fb d9 69 dd b8 34 07 77 ff ad 7a 39 b5 d3 27 d2 5a 10 a7 43
SQL Server 2014 SP2	SQLServer2014SP2-FullSlipstream-x64-ENU.iso	2016-07-11	12.0.5000.0	3010	16 f1 93 4d c1 f4 79 94 cd 92 44 39 f8 84 a0 5c 6a d4 d1 73
SQL Server 2014 SP2 KB3204388	SQLServer2014-KB3204388-x64.exe	2016-12-28	12.0.5538.0	555	6f 76 bf 1a 04 58 6e e9 b7 a9 1c 77 98 23 90 4c 13 00 b7 bc
SQL Server 2012	SQLFULL_ENU.iso	2012-02-14	11.0.2100.60	4300	be 00 94 2c c5 6d 03 3e 2c 9d ce 8a 17 a6 f2 65 4f 51 84 a3
SQL Server 2012 SP3	SQLServer2012SP3-KB3072779-x64-ENU.exe	2015-11-21	11.0.6020.0	1017	db f0 1b 6d c6 d6 0c 2b 04 5c 92 d9 18 62 e6 08 7a d7 2a 0a
[SQL Server 2012 SP3 KB3205051]	SQLServer2012-KB3205051-x64.exe	2017-01-18	11.0.6579.0	614	43 46 74 9c 43 90 b4 5b 6e d2 34 fc 95 23 d3 e5 91 46 ce 6b
SQL Server 2008 R2	7601.17514.101119-1850_x64fre_server_eval_en-us-GRMSXEVAL_EN_DVD.iso	2010-11-21	6.1.7601.17514	3020	e1 f1 12 e3 b0 b3 03 a0 67 6f 70 dc 35 85 4b d7 6c d2 54 50
SQL Server 2008 R2 SP3	SQLServer2008R2SP3-KB2979597-x64-ENU.exe	2014-09-30	10.50.6220.0	358	19 4c d7 40 d5 81 2b 12 63 9b 47 88 6e bd e0 d0 47 74 b4 ec
SQL Server 2008 R2 SU	SQLServer2008R2-KB3045316-x64.exe	2015-07-14	10.50.6000	58	3a a4 d8 20 55 3b 1e 5d 96 73 55 41 cb b5 5d 97 32 2c 28 6e
SQL Server 2008	6001.18000.080118-1840_amd64fre_Server_en-us-KRMSXFRE_EN_DVD.exe	2008-01-19	6.0.6001.18000	2269	e4 d6 29 00 0f c2 3d a9 f9 e0 77 4b 79 69 80 ff 7f 71 f7 48
SQL Server 2008 SP4	SQLServer2008SP4-KB2979596-x64-ENU.exe	2014-09-30	10.0.6241.0	378	13 61 0d 6c b3 9e 37 fc d4 a3 33 82 44 a3 ca 2a 8a 40 4c d8
SQL Server 2008 SU	SQLServer2008-KB3045311-x64.exe	2015-07-14	10.00.6000	61	37 a1 97 c6 09 90 d2 e8 3e 98 d1 09 01 09 a4 ab 3f 2a be 4b

Версии SQL Server и уровни совместимости

Версия SQL Server	Версия ядра	Кодовое имя	Год релиза	Внутренняя версия	Уровень совместимости	Поддерживаемые уровни совместимости
SQL Server vNext	14	vNext	2017	856	140	140, 130, 120, 110, 100
SQL Server 2016	13	SQL16	2016	841	130	130, 120, 110, 100
Azure SQL Database	12	CloudDB	2010 (2017)	841	130	130, 120, 110, 100
SQL Server 2014	12	SQL14	2014	782	120	120, 110, 100
SQL Server 2012	11	Denali	2012	706	110	110, 100, 90
SQL Server 2012 CTP1	11	Denali	2010	684	110	110, 100, 90
SQL Server 2008 R2	10.5	Kilimanjaro	2010	660 / 661	100	100, 90, 80
SQL Server 2008	10	Katmai	2008	655	100	100, 90, 80
SQL Server 2005 SP2+ with VarDecimal enabled	9	Yukon	2005	612	90	90, 80
SQL Server 2005	9	Yukon	2005	611	90	90, 80
SQL Server 2000	8	Shiloh	2000	539	80	80
SQL Server 7.0	?	Sphinx	1998	515	70	70
SQL Server 6.5	?	Hydra	1996	408	65	65
SQL Server 6.0	?	SQL95	1995	?	60	?
SQL Server 4.21	?	SQLNT	1993	?	60	?
SQL Server 1.1 (16 bit)	?	?	1991	?	60	?
SQL Server 1.0 (16 bit)	?	Ashton-Tate	1989	?	60	?

Общая информация по Service Pack

Version	Codename	RTM (no SP)	SP1	SP2	SP3	SP4
SQL Server vNext	vNext	14.0.200.24
SQL Server 2016	SQL16	13.0.1601.5	13.0.4001.0
SQL Server 2014	SQL14	12.0.2000.8	12.0.4100.1	12.0.5000.0
SQL Server 2012	Denali	11.0.2100.60	11.0.3000.0	11.0.5058.0	11.0.6020.0
SQL Server 2008 R2	Kilimanjaro	10.50.1600.1	10.50.2500.0	10.50.4000.0 10.52.4000.0	10.50.6000.34 10.53.6000.34
SQL Server 2008	Katmai	10.0.1600.22	10.0.2531.0	10.0.4000.0 10.2.4000.0	10.0.5500.0 10.3.5500.0	10.0.6000.29 10.4.6000.29
SQL Server 2005	Yukon	9.0.1399.06	9.0.2047	9.0.3042	9.0.4035	9.0.5000
SQL Server 2000	Shiloh	8.0.194	8.0.384	8.0.532	8.0.760	8.0.2039
SQL Server 7.0	Sphinx	7.0.623	7.0.699	7.0.842	7.0.961	7.0.1063

Microsoft SQL Server VNext Builds

Так выглядит результат выполнения запроса SELECT @@VERSION для актуальной версии SQL Server vNext Developer Edition:

Microsoft SQL Server vNext (CTP1.2) - 14.0.200.24 (X64)
    Jan 10 2017 19:15:28
    Copyright (c) Microsoft Corporation. All rights reserved.
    Developer Edition (64-bit) on Windows …

Последние обновления и фиксы: What’s New in SQL Server vNext

Версия для Linux: What’s new for SQL Server vNext on Linux

Полезные статьи по V.Next:

How I spot not-yet-documented features in SQL Server CTPs
More ways to discover changes in new versions of SQL Server

Билд	Версия файла	Ветка	Тип	KB / Описание	Дата релиза	Дата билда	Размер, Мб
14.0.200.24	2016.140.200.24	CTP	CTP	Microsoft SQL Server vNext Community Technology Preview 1.2 (CTP1.2)	2017-01-18	2017-01-11	1975
14.0.100.187	2016.140.100.187	CTP	CTP	Microsoft SQL Server vNext Community Technology Preview 1.1 (CTP1.1)	2016-12-16	2016-12-11	1975
14.0.1.246	2016.140.1.246	CTP	CTP	Microsoft SQL Server vNext Community Technology Preview 1 (CTP1)	2016-11-16	2016-11-02	1983

Microsoft SQL Server 2016 Builds

Так выглядит результат выполнения запроса SELECT @@VERSION для актуальной версии SQL Server 2016 Developer Edition:

Microsoft SQL Server 2016 (SP1-CU1) (KB3208177) – 13.0.4411.0 (X64)
    Jan 6 2017 14:24:37
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows …

Билд	Версия файла	Ветка	Тип	KB / Описание	Дата релиза	Дата билда	Размер, Мб
13.0.4411.0	2015.130.4411.0	SP1	CU	3208177 Cumulative update 1 for SQL Server 2016 Service Pack 1	2017-01-18	2017-01-06	439
13.0.4202.0	2015.130.4202.0	SP1	COD	3210089 GDR update package for SQL Server 2016 SP1	2016-12-16	2016-12-13
13.0.4199.0	2015.130.4199.0	SP1	COD	3207512 Important update for SQL Server 2016 SP1 Reporting Services	2016-11-23	2016-11-18
13.0.4001.0	2015.130.4001.0	SP1	SP	3182545 SQL Server 2016 Service Pack 1 release information	2016-11-16	2016-10-29
13.0.2193.0	2015.130.2193.0	RTM	CU	3205052 Cumulative update 4 for SQL Server 2016	2017-01-18	2017-01-06	699
13.0.2190.2	2015.130.2190.2	RTM	COD	3210110 On-demand hotfix update package for SQL Server 2016 CU3	2016-12-16	2016-12-13
13.0.2186.6	2015.130.2186.6	RTM	CU	3194717 MS16-136: Description of the security update for SQL Server 2016 CU	2016-11-08	2016-10-31
13.0.2186.6	2015.130.2186.6	RTM	CU	3205413 Cumulative update 3 for SQL Server 2016 Duplicate KB3194717	2016-11-08	2016-10-31
13.0.2170.0	2015.130.2170.0	RTM	COD	3199171 On-demand hotfix update package for SQL Server 2016 CU2	2016-11-01	2016-10-11
13.0.2169.0	2015.130.2169.0	RTM	COD	3195813 On-demand hotfix update package for SQL Server 2016 CU2	2016-10-26	2016-10-05
13.0.2164.0	2015.130.2164.0	RTM	CU	3182270 Cumulative Update 2 for SQL Server 2016	2016-09-22	2016-09-09
13.0.2149.0	2015.130.2149.0	RTM	CU	3164674 Cumulative Update 1 for SQL Server 2016	2016-07-25	2016-07-11
13.0.1722.0	2015.130.1722.0	RTM	COD	3194716 MS16-136: Description of the security update for SQL Server 2016 GDR	2016-11-08	2016-10-31
13.0.1711.0	2015.130.1711.0	RTM	COD	3179258 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200)	2016-08-17	2016-07-30
13.0.1708.0	2015.130.1708.0	RTM	COD	3164398 Critical update for SQL Server 2016 MSVCRT prerequisites	2016-06-04	2016-06-02
13.0.1601.5	2015.130.1601.5	RTM	RTM	Microsoft SQL Server 2016 RTM	2016-06-01	2016-04-29
13.0.1400.361	2015.130.1400.361	RC	RC	Microsoft SQL Server 2016 Community Technology Release Candidate 3 (RC3)	2016-04-15	2016-04-09
13.0.1300.275	2015.130.1300.275	RC	RC	Microsoft SQL Server 2016 Community Technology Release Candidate 2 (RC2)	2016-04-01	2016-03-26
13.0.1200.242	2015.130.1200.242	RC	RC	Microsoft SQL Server 2016 Community Technology Release Candidate 1 (RC1)	2016-03-18	2016-03-10
13.0.1100.288	2015.130.1100.288	RC	RC	Microsoft SQL Server 2016 Community Technology Release Candidate 0 (RC0)	2016-03-07	2016-02-29
13.0.1000.281	2015.130.1000.281	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 3.3 (CTP3.3)	2016-02-03	2016-01-28
13.0.900.73	2015.130.900.73	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 3.2 (CTP3.2)	2015-12-17	2015-12-10
13.0.801.12	2015.130.801.12	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 3.1 (CTP3.1 refresh)	2015-12-05	2015-12-01
13.0.801.111	2015.130.801.111	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 3.1 (CTP3.1)	2015-11-30	2015-11-21
13.0.700.242	2015.130.700.242	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 3.0 (CTP3.0)	2015-10-29	2015-10-26
13.0.600.65	2015.130.600.65	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2.4 (CTP2.4)	2015-09-30	2015-09-20
13.0.500.53	2015.130.500.53	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2.3 (CTP2.3)	2015-08-28	2015-08-24
13.0.407.1	2015.130.407.1	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2.2 (CTP2.2)	2015-07-29	2015-07-22
13.0.400.91	2015.130.400.91	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2.2 (CTP2.2) (withdrawn)	2015-07-22	2015-07-16
13.0.300.44	2015.130.300.444	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2.1 (CTP2.1)	2015-06-14	2015-06-12
13.0.200.172	2015.130.200.172	CTP	CTP	Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2)	2015-05-26	2015-05-21

Microsoft SQL Server 2014 Builds

Так выглядит результат выполнения запроса SELECT @@VERSION для актуальной версии SQL Server 2014 Developer Edition:

Microsoft SQL Server 2014 (SP2-CU3) (KB3204388) - 12.0.5538.0 (X64)
    Dec 15 2016 17:52:48
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows …

Build	File version	Branch	Type	KB / Description	Release Date
12.0.5538.0	2014.120.5538.0	SP2	CU	3204388 Cumulative update 3 for SQL Server 2014 SP2	2016-12-28
12.0.5532.0	2014.120.5532.0	SP2	CU	3194718 MS16-136: Description of the security update for SQL Server 2014 Service Pack 2 CU: November 8, 2016	2016-11-08
12.0.5522.0	2014.120.5522.0	SP2	CU	3188778 Cumulative update 2 for SQL Server 2014 SP2	2016-10-18
12.0.5511.0	2014.120.5511.0	SP2	CU	3178925 Cumulative update 1 for SQL Server 2014 SP2	2016-08-24
12.0.5000.0	2014.120.5000.0	SP2	SP	3171021 SQL Server 2014 Service Pack 2 release information	2016-07-11
12.00.4491.0	2014.120.4491.0	SP1	CU	3204399 Cumulative update package 10 (CU10) for SQL Server 2014 Service Pack 1	2016-12-28
12.0.4487.0	2014.120.4487.0	SP1	CU	3194722 MS16-136: Description of the security update for SQL Server 2014 Service Pack 1 CU: November 8, 2016	2016-11-08
12.0.4474.0	2014.120.4474.0	SP1	CU	3186964 Cumulative update 9 for SQL Server 2014 SP1	2016-10-18
12.0.4468.0	2014.120.4468.0	SP1	CU	3174038 Cumulative update 8 for SQL Server 2014 SP1	2016-08-16
12.0.4463.0	2014.120.4463.0	SP1	COD	3174370 COD Hotfix A memory leak occurs when you use Azure Storage in SQL Server 2014	2016-08-04
12.0.4459.0	2014.120.4459.0	SP1	CU	3167392 Cumulative Update 7 for SQL Server 2014 SP1	2016-06-20
12.0.4457.0	2014.120.4457.0	SP1	CU	3167392 Cumulative Update 6 for SQL Server 2014 Service Pack 1 Refresh	2016-05-31
12.0.4452.0	2014.120.4452.0	SP1	COD	3147825 COD Hotfix Deprecated	2016-04-05
12.0.4449.0	2014.120.4449.0	SP1	CU	3144524 Cumulative update 6 for SQL Server 2014 SP1 (deprecated) Deprecated	2016-04-18
12.0.4439.1	2014.120.4439.1	SP1	CU	3130926 Cumulative Update 5 (CU5) for SQL Server 2014 Service Pack 1	2016-02-22
12.0.4437.0	2014.120.4437.0	SP1	COD	3130999 On-demand hotfix update package for SQL Server 2014 Service Pack 1 Cumulative Update 4	2016-02-05
12.0.4436.0	2014.120.4436.0	SP1	CU	3106660 Cumulative update package 4 (CU4) for SQL Server 2014 Service Pack 1	2015-12-21
12.0.4433.0	2014.120.4433.0	SP1	COD	3119148 FIX: Error 3203 occurs and a SQL Server 2014 backup job can’t restart after a network failure	2015-12-09
12.0.4432.0	2014.120.4432.0	SP1	COD	3097972 FIX: Error when your stored procedure calls another stored procedure on a linked server in SQL Server 2014	2015-11-19
12.0.4427.24	2014.120.4427.24	SP1	CU	3094221 Cumulative update package 3 (CU3) for SQL Server 2014 Service Pack 1	2015-10-21
12.0.4422.0	2014.120.4422.0	SP1	CU	3075950 Cumulative update package 2 (CU2) for SQL Server 2014 Service Pack 1	2015-08-17
12.0.4419.0	2014.120.4419.0	SP1	COD	3078973 An on-demand hotfix update package is available for SQL Server 2014 SP1	2015-07-24
12.0.4416.0	2014.120.4416.0	SP1	CU	3067839 Cumulative update package 1 (CU1) for SQL Server 2014 Service Pack 1	2015-06-22
12.0.4232.0	2014.120.4232.0	SP1	CU	3194720 MS16-136: Description of the security update for SQL Server 2014 Service Pack 1 GDR: November 8, 2016	2016-11-08
12.0.4219.0	2014.120.4219.0	SP1	GDR	3098852 SP1 GDR TLS 1.2 Update	2016-01-29
12.0.4213.0	2014.120.4213.0	SP1	GDR	3070446 MS15-058: Description of the nonsecurity update for SQL Server 2014 Service Pack 1 GDR: July 14, 2015	2015-07-14
12.0.4100.1	2014.120.4100.1	SP1	SP	3058865 SQL Server 2014 Service Pack 1 release information	2015-05-14
12.0.4050.0	2014.120.4050.0	SP1	SP	SQL Server 2014 Service Pack 1 (SP1) (initial)	2015-04-15
12.0.2569.0	2014.120.2569.0	RTM	CU	3158271 Cumulative update package 14 (CU14) for SQL Server 2014	2016-06-20
12.0.2568.0	2014.120.2568.0	RTM	CU	3144517 Cumulative update package 13 (CU13) for SQL Server 2014	2016-04-18
12.0.2564.0	2014.120.2564.0	RTM	CU	3130923 Cumulative update package 12 (CU12) for SQL Server 2014	2016-02-22
12.0.2560.0	2014.120.2550.0	RTM	CU	3106659 Cumulative update package 11 (CU11) for SQL Server 2014	2015-12-21
12.0.2556.4	2014.120.2556.4	RTM	CU	3094220 Cumulative update package 10 (CU10) for SQL Server 2014	2015-10-20
12.0.2553	2014.120.2553.0	RTM	CU	3075949 Cumulative update package 9 (CU9) for SQL Server 2014	2015-08-17
12.0.2548	2014.120.2548.0	RTM	CU	3045323 MS15-058: Description of the security update for SQL Server 2014 QFE: July 14, 2015	2015-07-14
12.0.2546	2014.120.2546.0	RTM	CU	3067836 Cumulative update package 8 (CU8) for SQL Server 2014	2015-06-22
12.0.2506	2014.120.2506.0	RTM	COD	3063054 Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures	2015-05-19
12.0.2505	2014.120.2505.0	RTM	COD	3052167 FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014	2015-05-19
12.0.2504	2014.120.2504.0	RTM	COD	2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014	2015-05-05
12.0.2504	2014.120.2504.0	RTM	COD	3058512 FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014	2015-05-05
12.0.2495	2014.120.2495.0	RTM	CU	3046038 Cumulative update package 7 (CU7) for SQL Server 2014	2015-04-23
12.0.2488	2014.120.2488.0	RTM	COD	3048751 FIX: Deadlock cannot be resolved automatically when you run a SELECT query that can result in a parallel batch-mode scan	2015-04-01
12.0.2485	2014.120.2485.0	RTM	COD	3043788 An on-demand hotfix update package is available for SQL Server 2014	2015-03-16
12.0.2480	2014.120.2480.0	RTM	CU	3031047 Cumulative update package 6 (CU6) for SQL Server 2014	2015-02-16
12.0.2474	2014.120.2474.0	RTM	COD	3034679 FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING	2015-05-15
12.0.2472	2014.120.2472.0	RTM	COD	3032087 FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014	2015-01-28
12.0.2464	2014.120.2464.0	RTM	COD	3024815 Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014	2015-01-05
12.0.2456	2014.120.2456.0	RTM	CU	3011055 Cumulative update package 5 (CU5) for SQL Server 2014	2014-12-18
12.0.2436	2014.120.2436.0	RTM	COD	3014867 FIX: «Remote hardening failure» exception cannot be caught and a potential data loss when you use SQL Server 2014	2014-11-27
12.0.2430	2014.120.2430.0	RTM	CU	2999197 Cumulative update package 4 (CU4) for SQL Server 2014	2014-10-21
12.0.2423	2014.120.2423.0	RTM	COD	3007050 FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014	2014-10-22
12.0.2405	2014.120.2405.0	RTM	COD	2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014	2014-09-25
12.0.2402	2014.120.2402.0	RTM	CU	2984923 Cumulative update package 3 (CU3) for SQL Server 2014	2014-08-18
12.0.2381	2014.120.2381.0	RTM	QFE	2977316 MS14-044: Description of the security update for SQL Server 2014 (QFE)	2014-08-12
12.0.2370	2014.120.2370.0	RTM	CU	2967546 Cumulative update package 2 (CU2) for SQL Server 2014	2014-06-27
12.0.2342	2014.120.2342.0	RTM	CU	2931693 Cumulative update package 1 (CU1) for SQL Server 2014	2014-04-21
12.0.2271.0	2014.120.2271.0	RTM	GDR	TLS 1.2 support for SQL Server 2014 RTM	2015-12-11
12.0.2269	2014.120.2269.0	RTM	GDR	3045324 MS15-058: Description of the security update for SQL Server 2014 GDR: July 14, 2015	2015-07-14
12.0.2254	2014.120.2254.0	RTM	GDR	2977315 MS14-044: Description of the security update for SQL Server 2014 (GDR)	2014-08-12
12.0.2000	2014.120.2000.8	RTM	RTM	SQL Server 2014 RTM	2014-04-01
12.0.1524	2014.120.1524.0	CTP	CTP	Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)	2013-10-15
11.0.9120	2013.110.9120.0	CTP	CTP	Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1)	2013-06-25

Microsoft SQL Server 2012 Builds

Build	File version	Branch	Type	KB / Description	Release Date
11.0.6579.0	2011.110.6579.0	SP3	CU	3205051 Cumulative Update Package 7 for SQL Server 2012 SP3	2017-01-18
11.0.6567.0	2011.110.6567.0	SP3	COD	3194724 MS16-136: Description of the security update for SQL Server 2012 Service Pack 3 CU: November 8, 2016	2016-11-17
11.0.6544.0	2011.110.6544.0	SP3	CU	3180915 Cumulative update 5 for SQL Server 2012 Service Pack 3	2016-09-20
11.0.6540.0	2011.110.6540.0	SP3	CU	3165264 Cumulative Update 4 for SQL Server 2012 SP3	2016-07-18
11.0.6537.0	2011.110.6537.0	SP3	CU	3152635 Cumulative update package 3 for SQL Server 2012 SP3	2016-05-16
11.0.6523.0	2011.110.6523.0	SP3	CU	3137746 Cumulative update package 2 for SQL Server 2012 SP3	2016-03-21
11.0.6518.0	2011.110.6518.0	SP3	CU	3123299 Cumulative update package 1 for SQL Server 2012 SP3	2016-01-19
11.0.6248.0	2011.110.6248.0	SP3	GDR	3194721 MS16-136: Description of the security update for SQL Server 2012 Service Pack 3 GDR: November 8, 2016	2016-11-08
11.0.6216.27	2011.110.6216.27	SP3	GDR	3135244 TLS 1.2 support for SQL Server 2012 SP3 GDR	2016-01-27
11.3.6020.0	2011.110.6020.0	SP3	SP	3072779 Microsoft SQL Server 2012 Service Pack 3 (SP3)	2015-11-21
11.0.5678.0	2011.110.5678.0	SP2	CU	3205054 Cumulative Update 16 for SQL Server 2012 SP2	2017-01-18
11.0.5676.0	2011.110.5676.0	SP2	CU	3205416 Cumulative update package 15 (CU15) for SQL Server 2012 Service Pack 2	2016-11-17
11.0.5676.0	2011.110.5676.0	SP2	COD	3194725 MS16-136: Description of the security update for SQL Server 2012 Service Pack 2 CU: November 8, 2016	2016-11-17
11.0.5657.0	2011.110.5657.0	SP2	CU	3180914 Cumulative Update 14 for SQL Server 2012 SP2	2016-09-20
11.0.5655.0	2011.110.5655.0	SP2	CU	3165266 Cumulative Update 13 for SQL Server 2012 SP2	2016-07-18
11.0.5649.0	2011.110.5649.0	SP2	CU	3152637 Cumulative update package 12 for SQL Server 2012 SP2	2016-05-16
11.0.5646.2	2011.110.5646.2	SP2	CU	3137745 Cumulative update package 11 for SQL Server 2012 SP2	2016-03-21
11.0.5644.2	2011.110.5644.2	SP2	CU	3120313 Cumulative update package 10 for SQL Server 2012 SP2	2016-01-19
11.0.5641.0	2011.110.5641.0	SP2	CU	3098512 Cumulative update package 9 for SQL Server 2012 SP2	2015-11-16
11.0.5636	2011.110.5636.3	SP2	COD	3097636 FIX: Performance decrease when application with connection pooling frequently connects or disconnects in SQL Server	2015-09-22
11.0.5634	2011.110.5634.0	SP2	CU	3082561 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 2	2015-09-21
11.0.5629	2011.110.5629.0	SP2	COD	3087872 FIX: Access violations when you use the FileTable feature in SQL Server 2012	2015-08-31
11.0.5623	2011.110.5623.0	SP2	CU	3072100 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 2	2015-07-20
11.0.5613	2011.110.5613.0	SP2	COD	3045319 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 QFE: July 14, 2015	2015-07-14
11.0.5592	2011.110.5592.0	SP2	CU	3052468 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 2	2015-05-19
11.0.5582	2011.110.5582.0	SP2	CU	3037255 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 2	2015-03-16
11.0.5571	2011.110.5571.0	SP2	COD	3034679 FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING	2015-05-15
11.0.5569	2011.110.5569.0	SP2	CU	3007556 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 2	2015-01-20
11.0.5556	2011.110.5556.0	SP2	CU	3002049 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 2	2014-11-17
11.0.5548	2011.110.5548.0	SP2	CU	2983175 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 2	2014-09-15
11.0.5532	2011.110.5532.0	SP2	CU	2976982 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 2	2014-07-24
11.0.5522	2011.110.5522.0	SP2	COD	2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP2)	2014-06-20
11.0.5388	2012.110.5388.0	SP2	GDR	3194719 MS16-136: Description of the security update for SQL Server 2012 Service Pack 2 GDR: November 8, 2016	2016-11-08
11.0.5352	2012.110.5352.0	SP2	GDR	3135244 TLS 1.2 support for SQL Server 2012 SP2 GDR	2016-01-27
11.0.5343	2011.110.5343.0	SP2	GDR	3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015	2015-07-14
11.0.5058	2011.110.5058.0	SP2	SP	SQL Server 2012 Service Pack 2 (SP2)	2014-06-10
11.0.3513	2011.110.3513.0	SP1	QFE	3045317 MS15-058: Description of the security update for SQL Server 2012 SP1 QFE: July 14, 2015	2015-07-14
11.0.3492	2011.110.3492.0	SP1	CU	3052476 Cumulative update package 16 (CU16) for SQL Server 2012 Service Pack 1	2015-05-18
11.0.3487	2011.110.3487.0	SP1	CU	3038001 Cumulative update package 15 (CU15) for SQL Server 2012 Service Pack 1	2015-03-16
11.0.3486	2011.110.3486.0	SP1	QFE	3023636 Cumulative update package 14 (CU14) for SQL Server 2012 Service Pack 1	2015-01-19
11.0.3460	2011.110.3460.0	SP1	COD	2977325 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (QFE)	2014-08-12
11.0.3482	2011.110.3482.0	SP1	CU	3002044 Cumulative update package 13 (CU13) for SQL Server 2012 Service Pack 1	2014-11-17
11.0.3470	2011.110.3470.0	SP1	CU	2991533 Cumulative update package 12 (CU12) for SQL Server 2012 Service Pack 1	2014-09-15
11.0.3449	2011.110.3449.0	SP1	CU	2975396 Cumulative update package 11 (CU11) for SQL Server 2012 Service Pack 1	2014-07-21
11.0.3437	2011.110.3437.0	SP1	COD	2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP1)	2014-06-10
11.0.3431	2011.110.3431.0	SP1	CU	2954099 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 1	2014-05-19
11.0.3412	2011.110.3412.0	SP1	CU	2931078 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 1	2014-03-18
11.0.3401	2011.110.3401.0	SP1	CU	2917531 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 1	2014-01-20
11.0.3393	2011.110.3393.0	SP1	CU	2894115 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1	2013-11-18
11.0.3381	2011.110.3381.0	SP1	CU	2874879 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 1	2013-09-16
11.0.3373	2011.110.3373.0	SP1	CU	2861107 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 1	2013-07-16
11.0.3368	2011.110.3368.0	SP1	CU	2833645 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 1	2013-05-31
11.0.3350	2011.110.3350.0	SP1	COD	2832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1	2013-04-17
11.0.3349	2011.110.3349.0	SP1	CU	2812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1	2013-03-18
11.0.3339	2011.110.3339.0	SP1	CU	2790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1	2013-01-25
11.0.3335	2011.110.3335.0	SP1	COD	2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1	2013-01-14
11.0.3321	2011.110.3321.0	SP1	CU	2765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1	2012-11-20
11.0.3156	2011.110.3156.0	SP1	COD	3045318 MS15-058: Description of the security update for SQL Server 2012 SP1 GDR: July 14, 2015	2015-07-14
11.0.3153	2011.110.3153.0	SP1	GDR	2977326 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (GDR)	2014-08-12
11.0.3128	2011.110.3128.0	SP1	COD	2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1	2013-01-03
11.0.3000	2011.110.3000.0	SP1	SP	SQL Server 2012 Service Pack 1 (SP1)	2012-11-06
11.0.2845	2011.110.2845.0	SP1	CTP	SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4)	2012-09-20
11.0.2809	2011.110.2809.24	SP1	CTP	SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3)	2012-07-05
11.0.2424	2011.110.2424.0	RTM	CU	2908007 Cumulative update package 11 (CU11) for SQL Server 2012	2013-12-17
11.0.2420	2011.110.2420.0	RTM	CU	2891666 Cumulative update package 10 (CU10) for SQL Server 2012	2013-10-21
11.0.2419	2011.110.2419.0	RTM	CU	2867319 Cumulative update package 9 (CU9) for SQL Server 2012	2013-08-21
11.0.2410	2011.110.2410.0	RTM	CU	2844205 Cumulative update package 8 (CU8) for SQL Server 2012	2013-06-18
11.0.2405	2011.110.2405.0	RTM	CU	2823247 Cumulative update package 7 (CU7) for SQL Server 2012	2013-04-15
11.0.2401	2011.110.2401.0	RTM	CU	2728897 Cumulative update package 6 (CU6) for SQL Server 2012	2013-02-18
11.0.2395	2011.110.2395.0	RTM	CU	2777772 Cumulative update package 5 (CU5) for SQL Server 2012	2012-12-18
11.0.9000	2011.110.9000.5	RTM	CTP	Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3)	2012-11-27
11.0.2383	2011.110.2383.0	RTM	CU	2758687 Cumulative update package 4 (CU4) for SQL Server 2012	2012-10-18
11.0.2376	2011.110.2376.0	RTM	COD	Microsoft Security Bulletin MS12-070	2012-10-09
11.0.2332	2011.110.2332.0	RTM	CU	2723749 Cumulative update package 3 (CU3) for SQL Server 2012	2012-08-29
11.0.2325	2011.110.2325.0	RTM	CU	2703275 Cumulative update package 2 (CU2) for SQL Server 2012	2012-06-18
11.0.2316	2011.110.2316.0	RTM	CU	2679368 Cumulative update package 1 (CU1) for SQL Server 2012	2012-04-12
11.0.2218	2011.110.2218.0	RTM	COD	Microsoft Security Bulletin MS12-070	2012-10-09
11.0.2214	2011.110.2214.0	RTM	COD	2685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence	2012-04-06
11.0.2100	2011.110.2100.60	RTM	RTM	SQL Server 2012 RTM	2012-03-06
11.0.1913	2011.110.1913.37	RC	RC	Microsoft SQL Server 2012 Release Candidate 1 (RC1)	2011-12-16
11.0.1750	2011.110.1750.32	RC	RC	Microsoft SQL Server 2012 Release Candidate 0 (RC0)	2011-11-17
11.0.1440	2010.110.1440.19	CTP	CTP	Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 3 (CTP3)	2011-07-11
11.0.1103	2010.110.1103.9	CTP	CTP	Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 1 (CTP1)	2010-11-08

Microsoft SQL Server 2008 R2 Builds

Build	File version	KB / Description	Release Date
10.50.6542	2009.100.6542.0	3146034 Intermittent service terminations occur after you install any SQL Server 2008 or SQL Server 2008 R2 versions from KB3135244	2016-03-03
10.50.6537	2009.100.6537.0	3135244 TLS 1.2 support for SQL Server 2008 R2 SP3	2016-01-27
10.50.6529	2009.100.6529.0	3045314 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 QFE: July 14, 2015	2015-07-14
10.50.6525	2009.100.6525.0	3033860 An on-demand hotfix update package is available for SQL Server 2008 R2 Service Pack 3 (SP3)	2015-02-09
10.50.6220	2009.100.6220.0	3045316 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 GDR: July 14, 2015	2015-07-14
10.50.6000.34	2009.100.6000.34	SQL Server 2008 R2 Service Pack 3 (SP3)	2014-09-26
10.50.4343	2009.100.4343.0	3135244 TLS 1.2 support for SQL Server 2008 R2 SP2 (IA-64 only)	2016-01-27
10.50.4339	2009.100.4339.0	3045312 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 QFE: July 14, 2015	2015-07-14
10.50.4331	2009.100.4331.0	2987585 Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012	2014-08-27
10.50.4321	2009.100.4321.0	2977319 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (QFE)	2014-08-12
10.50.4319	2009.100.4319.0	2967540 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 2	2014-06-30
10.50.4305	2009.100.4305.0	2938478 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 2	2014-04-21
10.50.4302	2009.100.4302.0	2926028 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 2	2014-02-18
10.50.4297	2009.100.4297.0	2908087 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 2	2013-12-16
10.50.4295	2009.100.4295.0	2887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2	2013-10-29
10.50.4290	2009.100.4290.0	2871401 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 2	2013-08-30
10.50.4286	2009.100.4286.0	2844090 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 2	2013-06-17
10.50.4285	2009.100.4285.0	2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (updated)	2013-06-13
10.50.4279	2009.100.4279.0	2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (replaced)	2013-04-15
10.50.4276	2009.100.4276.0	2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2	2013-02-18
10.50.4270	2009.100.4270.0	2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2	2012-12-17
10.50.4266	2009.100.4266.0	2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2	2012-10-15
10.50.4263	2009.100.4263.0	2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2	2012-08-29
10.50.4260	2009.100.4260.0	2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2	2012-08-01
10.50.4042	2009.100.4042.0	3045313 MS15-058: MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 GDR: July 14, 2015	2015-07-14
10.50.4033	2009.100.4033.0	2977320 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (GDR)	2014-08-12
10.50.4000	2009.100.4000.0	SQL Server 2008 R2 Service Pack 2 (SP2)	2012-06-26
10.50.3720	2009.100.3720.0	SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP)	2012-05-13
10.50.2881	2009.100.2881.0	2868244 An on-demand hotfix update package for SQL Server 2008 R2 Service Pack 1	2013-08-12
10.50.2876	2009.100.2876.0	2855792 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 1	2013-06-17
10.50.2875	2009.100.2875.0	2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (updated)	2013-06-13
10.50.2874	2009.100.2874.0	2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (replaced)	2013-04-15
10.50.2861	2009.100.2861.0	Microsoft Security Bulletin MS12-070	2012-10-09
10.50.2869	2009.100.2869.0	2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1	2013-02-18
10.50.2868	2009.100.2868.0	2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1	2012-12-17
10.50.2866	2009.100.2866.0	2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1	2012-11-06
10.50.2861	2009.100.2861.0	2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012	2012-10-09
10.50.2822	2009.100.2822.0	2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1	2012-08-29
10.50.2817	2009.100.2817.0	2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1	2012-06-18
10.50.2811	2009.100.2811.0	2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1	2012-04-16
10.50.2807	2009.100.2807.0	2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2	2012-03-12
10.50.2806	2009.100.2806.0	2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1	2012-02-22
10.50.2799	2009.100.2799.0	2633357 FIX: «Non-yielding Scheduler» error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2	2012-02-22
10.50.2796	2009.100.2796.0	2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1	2011-12-20
10.50.2789	2009.100.2789.0	2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1	2011-10-17
10.50.2776	2009.100.2776.0	2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2	2011-10-18
10.50.2772	2009.100.2772.0	2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1	2011-08-15
10.50.2769	2009.100.2769.0	2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1	2011-07-18
10.50.2550	2009.100.2550.0	Microsoft Security Bulletin MS12-070	2012-10-09
10.50.2500	2009.100.2500.0	SQL Server 2008 R2 Service Pack 1 (SP1)	2011-07-11
10.50.1817	2009.100.1817.0	2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2	2012-06-18
10.50.1815	2009.100.1815.0	2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2	2012-04-17
10.50.1810	2009.100.1810.0	2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2	2012-02-21
10.50.1809	2009.100.1809.0	2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2	2012-01-09
10.50.1807	2009.100.1807.0	2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2	2011-10-19
10.50.1804	2009.100.1804.0	2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2	2011-08-16
10.50.1800	2009.100.1800.0	2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system	2011-10-18
10.50.1797	2009.100.1797.0	2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2	2011-06-20
10.50.1790	2009.100.1790.0	2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011	2011-06-17
10.50.1777	2009.100.1777.0	2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2	2011-06-16
10.50.1769	2009.100.1769.0	2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used	2011-04-18
10.50.1765	2009.100.1765.0	2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2	2011-02-21
10.50.1753	2009.100.1753.0	2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2	2010-12-23
10.50.1746	2009.100.1746.0	2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2	2010-10-18
10.50.1734	2009.100.1734.0	2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2	2010-08-20
10.50.1720	2009.100.1720.0	2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2	2010-06-25
10.50.1702	2009.100.1702.0	981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2	2010-05-18
10.50.1617	2009.100.1617.0	2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011	2011-06-14
10.50.1600	2009.100.1600.1	SQL Server 2008 R2 RTM	2010-04-21
10.50.1352	2009.100.1352.12	Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP)	2009-11-12
10.50.1092	2009.100.1092.20	Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)	2009-06-30

Microsoft SQL Server 2008 Builds

Build	File version	KB / Description	Release Date
10.0.6547	2007.100.6547.0	3146034 Intermittent service terminations occur after you install any SQL Server 2008 or SQL Server 2008 R2 versions from KB3135244	2016-03-03
10.0.6543	2007.100.6543.0	3135244 TLS 1.2 support for SQL Server 2008 SP4	2016-01-27
10.0.6535	2007.100.6535.0	3045308 MS15-058: Description of the security update for SQL Server 2008 Service Pack 4 QFE: July 14, 2015	2015-07-14
10.0.6526	2007.100.6526.0	3034373 An on-demand hotfix update package is available for SQL Server 2008 Service Pack 4 (SP4)	2015-02-09
10.0.6241	2007.100.6241.0	3045311 MS15-058: Description of the security update for SQL Server 2008 Service Pack 4 GDR: July 14, 2015	2015-07-14
10.0.6000.29	2007.100.6000.29	2979596 SQL Server 2008 Service Pack 4 release information	2014-09-30
10.0.5894	2007.100.5894.0	3135244 TLS 1.2 support for SQL Server 2008 SP3 (IA-64 only)	2016-01-27
10.0.5890	2007.100.5890.0	3045303 MS15-058: Description of the security update for SQL Server 2008 Service Pack 3 QFE: July 14, 2015	2015-07-14
10.0.5869	2007.100.5869.0	2977322 MS14-044: Description of the security update for SQL Server 2008 SP3 (QFE)	2014-08-12
10.0.5867	2007.100.5867.0	2877204 FIX: Error 8985 when you run the «dbcc shrinkfile» statement by using the logical name of a file in SQL Server 2008 R2 or SQL Server 2008	2014-07-02
10.0.5861	2007.100.5861.0	2958696 Cumulative update package 17 (CU17) for SQL Server 2008 Service Pack 3	2014-05-19
10.0.5852	2007.100.5852.0	2936421 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 3	2014-03-17
10.0.5850	2007.100.5850.0	2923520 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 3	2014-01-20
10.0.5848	2007.100.5848.0	2893410 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 3	2013-11-18
10.0.5846	2007.100.5846.0	2880350 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 3	2013-09-16
10.0.5844	2007.100.5844.0	2863205 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 3	2013-07-16
10.0.5841	2007.100.5841.0	2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (updated)	2013-06-13
10.0.5840	2007.100.5840.0	2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (replaced)	2013-05-20
10.0.5835	2007.100.5835.0	2814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3	2013-03-18
10.0.5829	2007.100.5829.0	2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3	2013-01-23
10.0.5828	2007.100.5828.0	2771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3	2012-11-19
10.0.5826	2007.100.5826.0	2716435 Microsoft Security Bulletin MS12-070	2012-10-09
10.0.5794	2007.100.5794.0	2738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3	2012-09-21
10.0.5788	2007.100.5788.0	2715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3	2012-07-16
10.0.5785	2007.100.5785.0	2696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3	2012-05-19
10.0.5775	2007.100.5775.0	2673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3	2012-03-20
10.0.5770	2007.100.5770.0	2648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3	2012-01-16
10.0.5768	2007.100.5768.0	2633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3	2011-11-22
10.0.5766	2007.100.5766.0	2617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3	2011-10-18
10.0.5538	2007.100.5538.0	3045305 MS15-058: Description of the security update for SQL Server 2008 Service Pack 3 GDR: July 14, 2015	2015-07-14
10.0.5520	2007.100.5520.0	2977321 MS14-044: Description of the security update for SQL Server 2008 SP3 (GDR)	2014-08-12
10.0.5512	2007.100.5512.0	Microsoft Security Bulletin MS12-070	2012-10-09
10.0.5500	2007.100.5500.0	SQL Server 2008 Service Pack 3 (SP3)	2011-10-06
10.0.5416	2007.100.5416.0	SQL Server 2008 Service Pack 3 CTP	2011-08-22
10.0.4371	2007.100.4371.0	Microsoft Security Bulletin MS12-070	2012-10-09
10.0.4333	2007.100.4333.0	2715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2	2012-07-16
10.0.4332	2007.100.4332.0	2696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2	2012-05-20
10.0.4330	2007.100.4330.0	2673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2	2012-03-19
10.0.4326	2007.100.4326.0	2648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2	2012-01-30
10.0.4323	2007.100.4323.0	2617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2	2011-11-21
10.0.4321	2007.100.4321.0	2582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2	2011-09-20
10.0.4316	2007.100.4316.0	2555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2	2011-07-18
10.0.4285	2007.100.4285.0	2527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2	2011-05-16
10.0.4279	2007.100.4279.0	2498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2	2011-03-11
10.0.4272	2007.100.4272.0	2467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2	2011-02-10
10.0.4266	2007.100.4266.0	2289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2	2010-11-15
10.0.4067	2007.100.4067.0	Microsoft Security Bulletin MS12-070	2012-10-09
10.0.4064	2007.100.4064.0	2494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011	2011-06-14
10.0.4000	2007.100.4000.0	SQL Server 2008 Service Pack 2 (SP2)	2010-09-29
10.0.3798	2007.100.3798.0	SQL Server 2008 Service Pack 2 CTP	2010-07-07
10.0.2850	2007.100.2850.0	2582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1	2011-09-19
10.0.2847	2007.100.2847.0	2555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1	2011-07-18
10.0.2821	2007.100.2821.0	2527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1	2011-05-16
10.0.2816	2007.100.2816.0	2497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1	2011-03-22
10.0.2808	2007.100.2808.0	2467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1	2011-02-10
10.0.2804	2007.100.2804.0	2413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1	2010-11-15
10.0.2799	2007.100.2799.0	2279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1	2010-09-21
10.0.2789	2007.100.2789.0	2083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1	2010-07-21
10.0.2787	2007.100.2787.0	2231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8	2010-07-30
10.0.2775	2007.100.2775.0	981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1	2010-05-17
10.0.2766	2007.100.2766.0	979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1	2010-03-26
10.0.2757	2007.100.2757.0	977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1	2010-01-18
10.0.2746	2007.100.2746.0	975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1	2009-11-16
10.0.2740	2007.100.2740.0	976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster: «18401, Login failed for user SQLTESTAgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.SQLState 42000»	2009-11-24
10.0.2734	2007.100.2734.0	973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1	2009-09-22
10.0.2723	2007.100.2723.0	971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1	2009-07-21
10.0.2714	2007.100.2714.0	970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1	2009-05-18
10.0.2712	2007.100.2712.0	970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table	2009-07-21
10.0.2710	2007.100.2710.0	969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1	2009-04-16
10.0.2573	2007.100.2573.0	2494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011	2011-06-14
10.0.2531	2007.100.2531.0	SQL Server 2008 Service Pack 1 (SP1)	2009-04-07
10.0.2520	2007.100.2520.0	SQL Server 2008 Service Pack 1 — CTP	2009-02-23
10.0.1835	2007.100.1835.0	979064 Cumulative update package 10 (CU10) for SQL Server 2008	2010-03-15
10.0.1828	2007.100.1828.0	977444 Cumulative update package 9 (CU9) for SQL Server 2008	2010-01-18
10.0.1823	2007.100.1823.0	975976 Cumulative update package 8 (CU8) for SQL Server 2008	2009-11-16
10.0.1818	2007.100.1818.0	973601 Cumulative update package 7 (CU7) for SQL Server 2008	2009-09-21
10.0.1812	2007.100.1812.0	971490 Cumulative update package 6 (CU6) for SQL Server 2008	2009-07-21
10.0.1806	2007.100.1806.0	969531 Cumulative update package 5 (CU5) for SQL Server 2008	2009-05-18
10.0.1798	2007.100.1798.0	963036 Cumulative update package 4 (CU4) for SQL Server 2008	2009-03-17
10.0.1787	2007.100.1787.0	960484 Cumulative update package 3 (CU3) for SQL Server 2008	2009-01-19
10.0.1779	2007.100.1779.0	958186 Cumulative update package 2 (CU2) for SQL Server 2008	2008-11-19
10.0.1771	2007.100.1771.0	958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008	2008-10-29
10.0.1763	2007.100.1763.0	956717 Cumulative update package 1 (CU1) for SQL Server 2008	2008-10-28
10.0.1750	2007.100.1750.0	956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008	2008-08-25
10.0.1600	2007.100.1600.22	SQL Server 2008 RTM	2008-08-07
10.0.1442	2007.100.1442.32	Microsoft SQL Server 2008 RC0	2008-06-05
10.0.1300	2007.100.1300.13	Microsoft SQL Server 2008 CTP, February 2008	2008-02-19
10.0.1075	2007.100.1075.23	Microsoft SQL Server 2008 CTP, November 2007	2007-11-18
10.0.1049	2007.100.1049.14	SQL Server 2008 CTP, July 2007	2007-07-31
10.0.1019	2007.100.1019.17	SQL Server 2008 CTP, June 2007	2007-05-21

Microsoft SQL Server 2005 Builds

Build	File version	KB / Description	Release Date
9.00.5324	2005.90.5324.0	2716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE	2012-10-09
9.00.5296	2005.90.5296.0	2615425 FIX: «Msg 7359» error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated	2011-10-24
9.00.5295	2005.90.5295.0	2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2	2012-05-21
9.00.5294	2005.90.5294.0	2572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005	2011-08-10
9.00.5292	2005.90.5292.0	2494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011	2011-06-14
9.00.5266	2005.90.5266.0	2507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4	2011-03-22
9.00.5259	2005.90.5259.0	2489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4	2011-02-22
9.00.5254	2005.90.5254.0	2464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4	2010-12-24
9.00.5069	2005.90.5069.0	Microsoft Security Bulletin MS12-070	2012-10-09
9.00.5057	2005.90.5057.0	2494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011	2011-06-14
9.00.5000	2005.90.5000.0	SQL Server 2005 Service Pack 4 (SP4)	2010-12-17
9.00.4912	2005.90.4912.0	SQL Server 2005 Service Pack 4 (SP4) — Customer Technology Preview (CTP)	2010-11-03
9.00.4342	2005.90.4342.0	2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2	2012-05-21
9.00.4340	2005.90.4340.0	2494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011	2011-06-14
9.00.4325	2005.90.4325.0	2507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3	2011-03-22
9.00.4317	2005.90.4317.0	2489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3	2011-02-21
9.00.4315	2005.90.4315.0	2438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3	2010-12-23
9.00.4311	2005.90.4311.0	2345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3	2010-10-18
9.00.4309	2005.90.4309.0	2258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3	2010-08-16
9.00.4305	2005.90.4305.0	983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3	2010-06-23
9.00.4294	2005.90.4294.0	980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3	2010-04-19
9.00.4285	2005.90.4285.0	978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3	2010-02-16
9.00.4273	2005.90.4273.0	976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3	2009-12-21
9.00.4268	2005.90.4268.0	977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: «Cannot create the subscription because the subscription already exists in the subscription database»	2009-12-21
9.00.4266	2005.90.4266.0	974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3	2009-10-19
9.00.4262	2005.90.4262.0	970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009	2009-10-13
9.00.4230	2005.90.4230.0	972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3	2009-08-17
9.00.4226	2005.90.4226.0	970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3	2009-06-16
9.00.4224	2005.90.4224.0	971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: «Internal Query Processor Error: The query processor could not produce a query plan»	2009-06-16
9.00.4220	2005.90.4220.0	967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3	2009-04-20
9.00.4216	2005.90.4216.0	967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005	2009-04-20
9.00.4211	2005.90.4211.0	961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3	2009-02-17
9.00.4207	2005.90.4207.0	959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3	2008-12-20
9.00.4060	2005.90.4060.0	2494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011	2011-06-14
9.00.4053	2005.90.4053.0	970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009	2009-10-13
9.00.4035	2005.90.4035.0	SQL Server 2005 Service Pack 3 (SP3)	2008-12-15
9.00.4028	2005.90.4028.0	SQL Server 2005 Service Pack 3 (SP3) — CTP	2008-10-27
9.00.3356	2005.90.3356.0	976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2	2009-12-21
9.00.3355	2005.90.3355.0	974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2	2009-10-19
9.00.3353	2005.90.3353.0	970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009	2009-10-13
9.00.3330	2005.90.3330.0	972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2	2009-08-18
9.00.3328	2005.90.3328.0	970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2	2009-06-16
9.00.3325	2005.90.3325.0	967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2	2009-04-20
9.00.3320	2005.90.3320.0	969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: «Unable to deallocate a kept page»	2009-04-01
9.00.3318	2005.90.3318.0	967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider	2009-04-20
9.00.3315	2005.90.3315.0	962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2	2009-02-17
9.00.3310	2005.90.3310.0	960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009	2009-02-10
9.00.3301	2005.90.3301.0	958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2	2008-12-16
9.00.3294	2005.90.3294.0	956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2	2008-10-20
9.00.3282	2005.90.3282.0	953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2	2008-06-16
9.00.3260	2005.90.3260.0	954950 FIX: Error message when you run a distributed query in SQL Server 2005	2008-07-14
9.00.3259	2005.90.3259.0	954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session	2008-08-14
9.00.3259	2005.90.3259.0	954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005	2008-07-14
9.00.3257	2005.90.3257.0	951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2	2008-06-18
9.00.3246	2005.90.3246.0	952233 FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance	2008-05-23
9.00.3244	2005.90.3244.0	952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005	2008-06-03
9.00.3240	2005.90.3240.0	951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005	2008-05-21
9.00.3239	2005.90.3239.0	949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2	2008-04-17
9.00.3232	2005.90.3232.0	949959 FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: «The merge process is retrying a failed operation made to article ‘ArticleName’ — Reason: ‘Invalid input parameter values. Check the status values for detail.'»	2008-03-19
9.00.3231	2005.90.3231.0	949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: «Non-yielding Scheduler»	2008-03-18
9.00.3231	2005.90.3231.0	949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: «This operation conflicts with another pending operation on this transaction»	2008-03-14
9.00.3230	2005.90.3230.0	949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: «Unable to deallocate a kept page»	2008-03-07
9.00.3228	2005.90.3228.0	946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2	2008-02-19
9.00.3224	2005.90.3224.0	947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005	2008-02-04
9.00.3221	2005.90.3221.0	942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005	2008-01-31
9.00.3221	2005.90.3221.0	945443 FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query	2008-01-11
9.00.3221	2005.90.3221.0	945916 FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: «Msg 9002,» «Msg 3314,» and «Msg 9001»	2008-01-10
9.00.3221	2005.90.3221.0	945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005	2008-01-09
9.00.3215	2005.90.3215.0	943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2	2007-12-18
9.00.3208	2005.90.3208.0	944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005	2007-11-21
9.00.3206	2005.90.3206.0	944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005	2007-12-11
9.00.3200	2005.90.3200.0	941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2	2007-10-17
9.00.3194	2005.90.3194.0	940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005	2007-09-24
9.00.3186	2005.90.3186.0	940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005	2007-08-29
9.00.3182	2005.90.3182.0	940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005	2007-08-03
9.00.3179	2005.90.3179.0	938243 FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: «The execution of a full-text query failed. The content index is corrupt.»	2007-07-30
9.00.3178	2005.90.3178.0	938086 FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005	2007-08-22
9.00.3177	2005.90.3177.0	939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: «New request is not allowed to start because it should come with valid transaction descriptor»	2007-08-22
9.00.3175	2005.90.3175.0	936534 FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: «Must declare the scalar variable «@Variable»»	2007-08-20
9.00.3175	2005.90.3175.0	938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the «-SkipErrors» parameter in SQL Server 2005	2007-08-01
9.00.3171	2005.90.3171.0	937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections	2007-07-16
9.00.1541	2005.90.1541.0	917888 FIX: Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: «Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources»	2006-11-22
9.00.1541	2005.90.1541.0	917971 FIX: You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groups	2006-11-22
9.00.1539	2005.90.1539.0	917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement	2006-08-11
9.00.1538	2005.90.1538.0	917824 FIX: The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schema	2006-07-26
9.00.1536	2005.90.1536.0	917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005	2006-07-26
9.00.1534	2005.90.1534.0	916706 FIX: When you run the «dbcc dbreindex» command or the «alter index» command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005	2007-05-15
9.00.1533	2005.90.1533.0	916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005	2006-07-26
9.00.1532	2005.90.1532.0	916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005	2007-01-09
9.00.1531	2005.90.1531.0	915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005	2006-07-26
9.00.1528	2005.90.1528.0	915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005	2007-01-15
9.00.1528	2005.90.1528.0	915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005	2007-01-04
9.00.1528	2005.90.1528.0	915307 FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005	2007-01-11
9.00.1528	2005.90.1528.0	915306 FIX: The merge agent fails and a «permission denied» error message is logged when you synchronize a SQL Server 2005-based merge publication	2007-01-08
9.00.1528	2005.90.1528.0	915112 FIX: Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: «The request failed to run because the batch is aborted»	2006-07-26
9.00.1519	2005.90.1519.0	913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005	2007-01-20
9.00.1518	2005.90.1518.0	913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005	2006-09-22
9.00.1518	2005.90.1518.0	912472 FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005	2006-07-26
9.00.1518	2005.90.1518.0	913371 FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005	2006-07-26
9.00.1514	2005.90.1514.0	912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005	2006-07-26
9.00.1503	2005.90.1503.0	911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005	2006-07-26
9.00.1502	2005.90.1502.0	915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005	2006-07-26
9.00.1500	2005.90.1500.0	910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: «A severe error occurred on the current command»	2006-06-01
9.00.1406	2005.90.1406.0	932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399	2007-07-11
9.00.1399	2005.90.1399.0	SQL Server 2005 RTM	2005-11-07

Microsoft SQL Server 2000 Builds

Build	File version	KB / Description	Release Date
8.00.2305	2000.80.2305.0	983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012	2012-08-14
8.00.2301	2000.80.2301.0	983809 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 QFE: April 10, 2012	2012-04-10
8.00.2283	2000.80.2283.0	971524 FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004	2009-06-15
8.00.2282	2000.80.2282.0	960083 MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009	2009-02-10
8.00.2279	2000.80.2279.0	959678 FIX: When you run the SPSBackup.exe utility to back up a SQL Server 2000 database that is configured as a back-end database for a Windows SharePoint Services server, the backup operation fails	2009-04-08
8.00.2273	2000.80.2273.0	948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000 July 8, 2008	2008-08-05
8.00.2271	2000.80.2271.0	946584 FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current database	2008-03-12
8.00.2265	2000.80.2265.0	944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 «merge replication» publisher	2007-12-19
8.00.2253	2000.80.2253.0	939317 FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has multiple processors	2007-10-09
8.00.2249	2000.80.2249.0	936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000	2007-05-25
8.00.2248	2000.80.2248.0	935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000	2007-06-14
8.00.2246	2000.80.2246.0	935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000	2007-06-18
8.00.2245	2000.80.2245.0	933573 FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the «Bulk Insert» Transact-SQL command to import data in SQL Server 2000	2007-04-24
8.00.2244	2000.80.2244.0	934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer	2007-05-10
8.00.2242	2000.80.2242.0	929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor	2007-03-28
8.00.2238	2000.80.2238.0	931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4	2007-02-21
8.00.2236	2000.80.2236.0	930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement	2007-02-02
8.00.2234	2000.80.2234.0	929440 FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: «644» or «2511»	2007-02-22
8.00.2232	2000.80.2232.0	928568 FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file	2007-01-15
8.00.2231	2000.80.2231.0	928079 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000	2007-06-19
8.00.2229	2000.80.2229.0	927186 FIX: Error message when you create a merge replication for tables that have computed columns in SQL Server 2000 Service Pack 4: «The process could not log conflict information»	2007-07-24
8.00.2226	2000.80.2226.0	925684 FIX: You may experience one or more symptoms when you run a «CREATE INDEX» statement on an instance of SQL Server 2000	2006-11-20
8.00.2226	2000.80.2226.0	925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000	2006-11-13
8.00.2223	2000.80.2223.0	925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000	2007-07-20
8.00.2223	2000.80.2223.0	925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: «The process could not enumerate changes at the ‘Subscriber'»	2006-10-31
8.00.2218	2000.80.2218.0	925297 FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000	2007-06-19
8.00.2217	2000.80.2217.0	924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000	2007-10-25
8.00.2215	2000.80.2215.0	923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher	2007-01-12
8.00.2215	2000.80.2215.0	924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000	2006-10-05
8.00.2215	2000.80.2215.0	923563 FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: «Implicit conversion from datatype ‘text’ to ‘nvarchar’ is not allowed»	2006-10-30
8.00.2215	2000.80.2215.0	923327 FIX: You may receive an access violation error message when you import data by using the «Bulk Insert» command in SQL Server 2000	2006-12-28
8.00.2209	2000.80.2209.0	923797 The Knowledge Base (KB) Article You Requested Is Currently Not Available	???
8.00.2207	2000.80.2207.0	923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs	2006-08-28
8.00.2201	2000.80.2201.0	920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000	2006-08-21
8.00.2199	2000.80.2199.0	919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication	2006-07-26
8.00.2197	2000.80.2197.0	919133 FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000	2006-08-02
8.00.2197	2000.80.2197.0	919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a «Table Spool» operator in SQL Server 2000	2006-08-08
8.00.2197	2000.80.2197.0	919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: «Failed to read trace data»	2006-10-18
8.00.2196	2000.80.2196.0	919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000	2006-08-14
8.00.2194	2000.80.2194.0	917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding	2007-02-21
8.00.2194	2000.80.2194.0	917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000	2006-09-22
8.00.2192	2000.80.2192.0	917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4	2006-08-04
8.00.2191	2000.80.2191.0	916698 FIX: Error message when you run SQL Server 2000: «Failed assertion = ‘lockFound == TRUE'»	2006-07-26
8.00.2191	2000.80.2191.0	916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer	2006-10-03
8.00.2189	2000.80.2189.0	916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000	2006-07-26
8.00.2189	2000.80.2189.0	913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4	2006-07-19
8.00.2187	2000.80.2187.0	915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000	2007-06-18
8.00.2187	2000.80.2187.0	916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187	2006-10-16
8.00.2187	2000.80.2187.0	914384 FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000	2006-07-26
8.00.2187	2000.80.2187.0	915065 FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: «An error in updating your system has occurred»	2006-12-11
8.00.2180	2000.80.2180.0	913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000	2007-02-19
8.00.2180	2000.80.2180.0	913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor	2006-07-26
8.00.2175	2000.80.2175.0	911678 FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000	2006-07-26
8.00.2172	2000.80.2172.0	910707 FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000	2006-07-26
8.00.2171	2000.80.2171.0	909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected	2006-07-26
8.00.2168	2000.80.2168.0	907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1	2006-11-21
8.00.2166	2000.80.2166.0	909734 FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4	2006-07-26
8.00.2162	2000.80.2162.0	904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162	2006-09-15
8.00.2159	2000.80.2159.0	907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000	2006-07-26
8.00.2156	2000.80.2156.0	906790 FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit	2006-07-25
8.00.2151	2000.80.2151.0	903742 FIX: You receive an «Error: 8526, Severity: 16, State: 2» error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4	2006-07-25
8.00.2151	2000.80.2151.0	904244 FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4	2007-06-13
8.00.2148	2000.80.2148.0	899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000	2006-07-25
8.00.2148	2000.80.2148.0	899431 FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4	2006-07-25
8.00.2148	2000.80.2148.0	900390 FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents	2006-06-01
8.00.2148	2000.80.2148.0	900404 FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000	2006-06-01
8.00.2148	2000.80.2148.0	901212 FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 SP4	2006-07-25
8.00.2148	2000.80.2148.0	902150 FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer	2006-06-01
8.00.2148	2000.80.2148.0	902955 FIX: You receive a «Getting registry information» message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4	2006-07-25
8.00.2147	2000.80.2147.0	899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors	2006-06-01
8.00.2145	2000.80.2145.0	826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly	2005-10-25
8.00.2145	2000.80.2145.0	836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins	2006-06-07
8.00.2066	2000.80.2066.0	Microsoft Security Bulletin MS12-060	2012-08-14
8.00.2065	2000.80.2065.0	983808 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 GDR: April 10, 2012	2012-04-10
8.00.2055	2000.80.2055.0	959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution	2009-02-10
8.00.2040	2000.80.2040.0	899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4	2006-08-15
8.00.2039	2000.80.2039.0	SQL Server 2000 Service Pack 4 (SP4)	2005-05-06
8.00.2026	2000.80.2026.0	SQL Server 2000 Service Pack 4 (SP4) Beta	???
8.00.1547	2000.80.1547.0	899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors	2006-06-01
8.00.1077	2000.80.1077.0	983814 MS12-070: Description of the security update for SQL Server 2000 Reporting Services Service Pack 2	2012-10-09
8.00.1037	2000.80.1037.0	930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement	2007-02-02
8.00.1036	2000.80.1036.0	929410 FIX: Error message when you run a full-text query in SQL Server 2000: «Error: 17883, Severity: 1, State: 0»	2007-01-11
8.00.1035	2000.80.1035.0	917593 FIX: The «Audit Logout» event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000	2006-09-22
8.00.1034	2000.80.1034.0	915328 FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000	2006-08-09
8.00.1029	2000.80.1029.0	902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: «Internal SQL Server error»	2006-06-01
8.00.1027	2000.80.1027.0	900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000	2006-07-25
8.00.1025	2000.80.1025.0	899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3	2006-06-01
8.00.1025	2000.80.1025.0	899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000	2006-07-25
8.00.1024	2000.80.1024.0	898709 FIX: Error message when you use SQL Server 2000: «Time out occurred while waiting for buffer latch type 3»	2006-07-25
8.00.1021	2000.80.1021.0	887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000	2006-07-25
8.00.1020	2000.80.1020.0	896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3	2006-07-25
8.00.1019	2000.80.1019.0	897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000	2006-06-01
8.00.1017	2000.80.1017.0	896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000	2006-06-01
8.00.1014	2000.80.1014.0	895123 FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000	2006-06-01
8.00.1014	2000.80.1014.0	895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000	2006-07-25
8.00.1013	2000.80.1013.0	891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000	2006-06-01
8.00.1009	2000.80.1009.0	894257 FIX: You receive an «Incorrect syntax near ‘)'» error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000	2006-06-01
8.00.1007	2000.80.1007.0	893312 FIX: You may receive a «SQL Server could not spawn process_loginread thread» error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000	2006-06-01
8.00.1003	2000.80.1003.0	892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000	2006-06-01
8.00.1001	2000.80.1001.0	892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation	2006-06-01
8.00.1000	2000.80.1000.0	891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000	2006-06-01
8.00.997	2000.80.997.0	891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log	2006-07-18
8.00.996	2000.80.996.0	891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation	2006-06-01
8.00.996	2000.80.996.0	891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations	2006-06-01
8.00.994	2000.80.994.0	890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3	2006-06-01
8.00.994	2000.80.994.0	890768 FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000	2006-06-01
8.00.994	2000.80.994.0	890767 FIX: You receive a «Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1» error message when the sum of the length of the published column names in a merge publication exceeds 4,000 characters in SQL Server 2000	2006-06-01
8.00.993	2000.80.993.0	890925 FIX: The @@ERROR system function may return an incorrect value when you execute a Transact-SQL statement that uses a parallel execution plan in SQL Server 2000 32-bit or in SQL Server 2000 64-bit	2006-06-01
8.00.993	2000.80.993.0	888444 FIX: You receive a 17883 error in SQL Server 2000 Service Pack 3 or in SQL Server 2000 Service Pack 3a when a worker thread becomes stuck in a registry call	2006-06-01
8.00.993	2000.80.993.0	890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: «Could not perform the requested operation because the minimum query memory is not available»	2006-05-15
8.00.991	2000.80.991.0	889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected	2006-06-01
8.00.990	2000.80.990.0	890200 FIX: SQL Server 2000 stops listening for new TCP/IP Socket connections unexpectedly after error message 17882 is written to the SQL Server 2000 error log	2006-06-01
8.00.988	2000.80.988.0	889166 FIX: You receive a «Msg 3628» error message when you run an inner join query in SQL Server 2000	2006-06-01
8.00.985	2000.80.985.0	889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000	2006-06-01
8.00.980	2000.80.980.0	887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3	2006-06-01
8.00.977	2000.80.977.0	888007 You receive a «The product does not have a prerequisite update installed» error message when you try to install a SQL Server 2000 post-Service Pack 3 hotfix	2005-08-31
8.00.973	2000.80.973.0	884554 FIX: A SPID stops responding with a NETWORKIO (0x800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet	2006-06-01
8.00.972	2000.80.972.0	885290 FIX: An assertion error occurs when you insert data in the same row in a table by using multiple connections to an instance of SQL Server	2006-06-01
8.00.970	2000.80.970.0	872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000	2006-06-01
8.00.967	2000.80.967.0	878501 FIX: You may receive an error message when you run a SET IDENTITY_INSERT ON statement on a table and then try to insert a row into the table in SQL Server 2000	2006-06-01
8.00.962	2000.80.962.0	883415 FIX: A user-defined function returns results that are not correct for a query	2006-06-01
8.00.961	2000.80.961.0	873446 FIX: An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMP	2006-06-01
8.00.959	2000.80.959.0	878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement	2006-06-01
8.00.957	2000.80.957.0	870994 FIX: An access violation exception may occur when you run a query that uses index names in the WITH INDEX option to specify an index hint	2006-06-01
8.00.955	2000.80.955.0	867798 FIX: The @date_received parameter of the xp_readmail extended stored procedure incorrectly returns the date and the time that an e-mail message is submitted by the sender in SQL Server 2000	2007-01-08
8.00.954	2000.80.954.0	843282 FIX: The Osql.exe utility does not run a Transact-SQL script completely if you start the program from a remote session by using a background service and then log off the console session	2007-01-05
8.00.952	2000.80.952.0	867878 FIX: The Log Reader Agent may cause 17883 error messages	2006-06-01
8.00.952	2000.80.952.0	867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribers	2006-06-01
8.00.952	2000.80.952.0	867880 FIX: Merge Agent may fail with an «Invalid character value for cast specification» error message	2006-06-01
8.00.949	2000.80.949.0	843266 FIX: Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3)	2006-06-02
8.00.948	2000.80.948.0	843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server	2006-06-01
8.00.944	2000.80.944.0	839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2	2006-06-05
8.00.937	2000.80.937.0	841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures	2006-06-01
8.00.936	2000.80.936.0	841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances	2006-06-01
8.00.935	2000.80.935.0	841401 FIX: You may notice incorrect values for the «Active Transactions» counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer	2006-06-01
8.00.934	2000.80.934.0	841404 FIX: You may receive a «The query processor could not produce a query plan» error message in SQL Server when you run a query that includes multiple subqueries that use self-joins	2006-06-01
8.00.933	2000.80.933.0	840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3	2006-06-02
8.00.929	2000.80.929.0	839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly	2006-06-01
8.00.928	2000.80.928.0	839589 FIX: The thread priority is raised for some threads in a parallel query	2006-06-01
8.00.927	2000.80.927.0	839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters	2006-06-01
8.00.926	2000.80.926.0	839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000	2006-06-01
8.00.923	2000.80.923.0	838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later	2006-06-01
8.00.922	2000.80.922.0	837970 FIX: You may receive an «Invalid object name…» error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000	2005-10-25
8.00.919	2000.80.919.0	837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000	2005-10-25
8.00.916	2000.80.916.0	317989 FIX: Sqlakw32.dll May Corrupt SQL Statements	2005-09-27
8.00.915	2000.80.915.0	837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows	2005-10-25
8.00.913	2000.80.913.0	836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins	2006-06-07
8.00.911	2000.80.911.0	837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000	2005-10-25
8.00.910	2000.80.910.0	834798 FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start	2005-10-25
8.00.908	2000.80.908.0	834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED	2005-10-25
8.00.904	2000.80.904.0	834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication	2005-04-22
8.00.892	2000.80.892.0	833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devices	2005-10-25
8.00.891	2000.80.891.0	836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer	2005-04-01
8.00.879	2000.80.879.0	832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000	2005-10-25
8.00.878	2000.80.878.0	831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server	2005-10-25
8.00.876	2000.80.876.0	830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be Truncated	2005-10-25
8.00.876	2000.80.876.0	831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000	2005-10-25
8.00.876	2000.80.876.0	831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000	2005-10-25
8.00.873	2000.80.873.0	830887 FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfix	2005-10-25
8.00.871	2000.80.871.0	830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file	2005-10-25
8.00.871	2000.80.871.0	830860 FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache	2005-10-25
8.00.870	2000.80.870.0	830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values	2005-10-25
8.00.869	2000.80.869.0	830588 FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler	2005-10-25
8.00.866	2000.80.866.0	830366 FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031	2006-01-16
8.00.865	2000.80.865.0	830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed column	2005-10-25
8.00.865	2000.80.865.0	828945 FIX: You cannot insert explicit values in an IDENTITY column of a SQL Server table by using the SQLBulkOperations function or the SQLSetPos ODBC function in SQL Server 2000	2005-10-25
8.00.863	2000.80.863.0	829205 FIX: Query performance may be slow and may be inconsistent when you run a query while another query that contains an IN operator with many values is compiled	2005-10-25
8.00.863	2000.80.863.0	829444 FIX: A floating point exception occurs during the optimization of a query	2005-10-25
8.00.859	2000.80.859.0	821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859	2005-03-31
8.00.858	2000.80.858.0	828637 FIX: Users Can Control the Compensating Change Process in Merge Replication	2005-10-25
8.00.857	2000.80.857.0	828017 The Knowledge Base (KB) Article You Requested Is Currently Not Available	???
8.00.857	2000.80.857.0	827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level	2005-11-23
8.00.857	2000.80.857.0	828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager	2005-10-25
8.00.856	2000.80.856.0	828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter Criteria	2005-10-25
8.00.854	2000.80.854.0	828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many Objects	2005-10-25
8.00.852	2000.80.852.0	830466 FIX: You may receive an «Internal SQL Server error» error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000	2005-04-01
8.00.852	2000.80.852.0	827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity	2005-10-25
8.00.851	2000.80.851.0	826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS Command	2005-10-25
8.00.850	2000.80.850.0	826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset Cursor	2005-10-25
8.00.850	2000.80.850.0	826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries	2005-10-25
8.00.850	2000.80.850.0	826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly	2005-10-25
8.00.848	2000.80.848.0	826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special User	2005-10-25
8.00.847	2000.80.847.0	826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems	2005-10-25
8.00.845	2000.80.845.0	826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server Collation	2005-10-05
8.00.845	2000.80.845.0	825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to True	2005-10-25
8.00.844	2000.80.844.0	826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clients	2006-10-17
8.00.842	2000.80.842.0	825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table	2005-10-25
8.00.841	2000.80.841.0	825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause	2005-10-25
8.00.840	2000.80.840.0	319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors	2005-09-27
8.00.840	2000.80.840.0	319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors	2005-09-27
8.00.839	2000.80.839.0	823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR Clauses	2005-10-25
8.00.839	2000.80.839.0	824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecute	2005-10-25
8.00.837	2000.80.837.0	820788 FIX: Delayed domain authentication may cause SQL Server to stop responding	2005-10-25
8.00.837	2000.80.837.0	821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock	2005-10-25
8.00.837	2000.80.837.0	821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3	2005-10-25
8.00.837	2000.80.837.0	821740 FIX: MS DTC Transaction Commit Operation Blocks Itself	2005-10-25
8.00.837	2000.80.837.0	823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly	2005-10-25
8.00.819	2000.80.819.0	826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login	2005-10-25
8.00.818	2000.80.818.0	821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3	2006-01-09
8.00.818	2000.80.818.0	821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit	2005-03-16
8.00.818	2000.80.818.0	818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions	2005-02-10
8.00.818	2000.80.818.0	826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login	2005-10-25
8.00.818	2000.80.818.0	821280 MS03-031: Security Patch for SQL Server 2000 64-bit	2006-03-14
8.00.816	2000.80.816.0	818766 FIX: Intense SQL Server activity results in spinloop wait	2005-10-25
8.00.814	2000.80.814.0	819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers	2005-10-25
8.00.811	2000.80.811.0	819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000	2006-04-03
8.00.811	2000.80.811.0	819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers	2005-10-25
8.00.811	2000.80.811.0	818897 FIX: Invalid TDS Sent to SQL Server Results in Access Violation	2005-10-25
8.00.807	2000.80.807.0	818899 FIX: Error Message 3628 May Occur When You Run a Complex Query	2005-10-25
8.00.804	2000.80.804.0	818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex Query	2005-10-25
8.00.801	2000.80.801.0	818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package	2006-01-26
8.00.800	2000.80.800.0	818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows Service	2005-09-27
8.00.800	2000.80.800.0	818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical Indexes	2005-09-27
8.00.800	2000.80.800.0	818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow	2005-09-27
8.00.798	2000.80.798.0	817464 FIX: Using Sp_executesql in Merge Agent Operations	2005-09-27
8.00.794	2000.80.794.0	817464 FIX: Using Sp_executesql in Merge Agent Operations	2005-09-27
8.00.794	2000.80.794.0	813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column	2005-09-27
8.00.794	2000.80.794.0	816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query	2005-09-27
8.00.794	2000.80.794.0	817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins	2005-02-11
8.00.791	2000.80.791.0	815249 FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server	2005-09-27
8.00.790	2000.80.790.0	817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table	2005-09-27
8.00.789	2000.80.789.0	816840 FIX: Error 17883 May Display Message Text That Is Not Correct	2005-09-27
8.00.788	2000.80.788.0	816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000	2005-09-27
8.00.781	2000.80.781.0	815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All Files	2005-09-27
8.00.780	2000.80.780.0	816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN Collation	2005-09-27
8.00.780	2000.80.780.0	816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement	2005-09-27
8.00.780	2000.80.780.0	810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a	2006-10-10
8.00.779	2000.80.779.0	814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3	2005-09-27
8.00.776	2000.80.776.0	Unidentified	???
8.00.775	2000.80.775.0	815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR	2005-09-27
8.00.769	2000.80.769.0	814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error	2005-09-27
8.00.769	2000.80.769.0	814893 FIX: Error Message: «Insufficient key column information for updating» Occurs in SQL Server 2000 SP3	2005-09-27
8.00.765	2000.80.765.0	810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined	2005-09-27
8.00.765	2000.80.765.0	810688 FIX: Merge Agent Can Resend Changes for Filtered Publications	2005-09-27
8.00.765	2000.80.765.0	811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence	2005-09-27
8.00.765	2000.80.765.0	813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service	2005-09-27
8.00.763	2000.80.763.0	814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3	2005-09-27
8.00.762	2000.80.762.0	814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3	2005-09-27
8.00.760	2000.80.760.0	SQL Server 2000 Service Pack 3 (SP3 / SP3a)	2003-08-27
8.00.743	2000.80.743.0	818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2	2005-10-18
8.00.743	2000.80.743.0	818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2	2005-10-25
8.00.741	2000.80.741.0	818096 FIX: Many Extent Lock Time-outs May Occur During Extent Allocation	2005-02-10
8.00.736	2000.80.736.0	816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object	2005-09-27
8.00.735	2000.80.735.0	814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error	2005-09-27
8.00.733	2000.80.733.0	813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query Performance	2005-09-27
8.00.730	2000.80.730.0	813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service	2005-09-27
8.00.728	2000.80.728.0	814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention Period	2005-09-27
8.00.725	2000.80.725.0	812995 FIX: A Query with an Aggregate Function May Fail with a 3628 Error	2005-09-27
8.00.725	2000.80.725.0	813494 FIX: Distribution Agent Fails with «Violation of Primary Key Constraint» Error Message	2005-09-27
8.00.723	2000.80.723.0	812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile Time	2005-09-27
8.00.721	2000.80.721.0	812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names	2005-09-27
8.00.721	2000.80.721.0	812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock Escalation	2005-09-27
8.00.718	2000.80.718.0	811703 FIX: Unexpected results from partial aggregations based on conversions	2005-09-27
8.00.715	2000.80.715.0	810688 FIX: Merge Agent Can Resend Changes for Filtered Publications	2005-09-27
8.00.715	2000.80.715.0	811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence	2005-09-27
8.00.714	2000.80.714.0	811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp file	2005-10-18
8.00.713	2000.80.713.0	811205 FIX: An error message occurs when you perform a database or a file SHRINK operation	2005-09-27
8.00.710	2000.80.710.0	811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK Operation	2005-09-27
8.00.705	2000.80.705.0	810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistent	2005-09-27
8.00.703	2000.80.703.0	810526 FIX: Cursors That Have a Long Lifetime May Cause Memory Fragmentation	2005-09-27
8.00.702	2000.80.702.0	328551 FIX: Concurrency enhancements for the tempdb database	2006-07-19
8.00.701	2000.80.701.0	810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 Error	2005-09-27
8.00.701	2000.80.701.0	810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined	2005-09-27
8.00.700	2000.80.700.0	810072 FIX: Merge Replication Reconciler Stack Overflow	2005-09-27
8.00.696	2000.80.696.0	810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a Connection	2005-09-27
8.00.696	2000.80.696.0	810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations	2005-09-27
8.00.695	2000.80.695.0	331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock Escalation	2005-09-27
8.00.695	2000.80.695.0	331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already Exists	2005-02-10
8.00.695	2000.80.695.0	331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received Order	2005-02-10
8.00.693	2000.80.693.0	330212 FIX: Parallel logical operation returns results that are not consistent	2005-09-27
8.00.690	2000.80.690.0	311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an Assertion	2005-10-12
8.00.689	2000.80.689.0	329499 FIX: Replication Removed from Database After Restore WITH RECOVERY	2005-10-11
8.00.688	2000.80.688.0	329487 FIX: Transaction Log Restore Fails with Message 3456	2005-10-11
8.00.686	2000.80.686.0	316333 SQL Server 2000 Security Update for Service Pack 2	2006-11-24
8.00.682	2000.80.682.0	319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED	2005-10-18
8.00.679	2000.80.679.0	316333 SQL Server 2000 Security Update for Service Pack 2	2006-11-24
8.00.678	2000.80.678.0	328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004	2005-09-27
8.00.667	2000.80.667.0	2000 SP2+8/14 fix	???
8.00.665	2000.80.665.0	2000 SP2+8/8 fix	???
8.00.661	2000.80.661.0	326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occur	2005-09-27
8.00.655	2000.80.655.0	2000 SP2+7/24 fix	???
8.00.652	2000.80.652.0	810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations	2005-09-27
8.00.650	2000.80.650.0	322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked Buffers	2003-11-05
8.00.644	2000.80.644.0	324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and Subqueries	2005-09-27
8.00.636	2000.80.636.0	Microsoft Security Bulletin MS02-039	2002-06-24
8.00.608	2000.80.608.0	319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers	2004-06-21
8.00.604	2000.80.604.0	2000 SP2+3/29 fix	???
8.00.599	2000.80.599.0	319869 FIX: Improved SQL Manager Robustness for Odd Length Buffer	2005-09-27
8.00.594	2000.80.594.0	319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors	2005-09-27
8.00.584	2000.80.584.0	318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins	2008-02-04
8.00.578	2000.80.578.0	317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source	2005-09-27
8.00.578	2000.80.578.0	318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AV	2005-09-27
8.00.568	2000.80.568.0	317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network Library	2002-10-30
8.00.561	2000.80.561.0	2000 SP2+1/29 fix	???
8.00.558	2000.80.558.0	314003 FIX: Query That Uses DESC Index May Result in Access Violation	2005-09-26
8.00.558	2000.80.558.0	315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA	2005-09-27
8.00.552	2000.80.552.0	313002 The Knowledge Base (KB) Article You Requested Is Currently Not Available	???
8.00.552	2000.80.552.0	313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate	2005-09-26
8.00.534	2000.80.534.0	2000 SP2.01	???
8.00.532	2000.80.532.0	SQL Server 2000 Service Pack 2 (SP2)	2003-02-04
8.00.475	2000.80.475.0	2000 SP1+1/29 fix	???
8.00.474	2000.80.474.0	315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA	2005-09-27
8.00.473	2000.80.473.0	314003 FIX: Query That Uses DESC Index May Result in Access Violation	2005-09-26
8.00.471	2000.80.471.0	313302 FIX: Shared Table Lock Is Not Released After Lock Escalation	2005-09-26
8.00.469	2000.80.469.0	313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate	2005-09-26
8.00.452	2000.80.452.0	308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding	2005-09-26
8.00.444	2000.80.444.0	307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory	2005-09-26
8.00.444	2000.80.444.0	307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop Responding	2005-10-07
8.00.443	2000.80.443.0	307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000	2005-09-26
8.00.428	2000.80.428.0	304850 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers	2004-08-05
8.00.384	2000.80.384.0	SQL Server 2000 Service Pack 1 (SP1)	2001-06-11
8.00.296	2000.80.296.0	299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have	2004-08-09
8.00.287	2000.80.287.0	297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH	2005-10-07
8.00.251	2000.80.251.0	300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order	2003-10-17
8.00.250	2000.80.250.0	291683 The Knowledge Base (KB) Article You Requested Is Currently Not Available	???
8.00.249	2000.80.249.0	288122 FIX: Lock Monitor Uses Excessive CPU	2003-09-12
8.00.239	2000.80.239.0	285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access Violation	2003-10-09
8.00.233	2000.80.233.0	282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time	2003-10-09
8.00.231	2000.80.231.0	282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down	2003-10-09
8.00.226	2000.80.226.0	278239 FIX: Extreme Memory Usage When Adding Many Security Roles	2006-11-21
8.00.225	2000.80.225.0	281663 «Access Denied» Error Message When You Try to Use a Network Drive to Modify Windows 2000 Permissions	2006-10-30
8.00.223	2000.80.223.0	280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures	2004-06-29
8.00.222	2000.80.222.0	281769 FIX: Exception Access Violation Encountered During Query Normalization	2005-10-07
8.00.218	2000.80.218.0	279183 FIX: Scripting Object with Several Extended Properties May Cause Exception	2003-10-09
8.00.217	2000.80.217.0	279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown	2003-10-09
8.00.211	2000.80.211.0	276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan	2003-11-05
8.00.210	2000.80.210.0	275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slowly	2003-10-09
8.00.205	2000.80.205.0	274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025	2005-10-07
8.00.204	2000.80.204.0	274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins	2003-10-09
8.00.194	2000.80.194.0	SQL Server 2000 RTM (no SP)	???
8.00.190	2000.80.190.0	SQL Server 2000 Gold	???
8.00.100	2000.80.100.0	SQL Server 2000 Beta 2	???
8.00.078	2000.80.078.0	SQL Server 2000 EAP5	???
8.00.047	2000.80.047.0	SQL Server 2000 EAP4	???

Microsoft SQL Server 7.0 Builds

Build	KB / Description	Release Date
7.00.1152	948113 MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008	2008-07-08
7.00.1149	867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0	2006-06-01
7.00.1143	830233 New Connection Events Are Not Recorded in SQL Server Traces	2005-10-25
7.00.1143	829015 FIX: An attention signal that is sent from a SQL Server client application because of a query time-out may cause the SQL Server service to quit unexpectedly	2005-10-25
7.00.1097	822756 A Complex UPDATE Statement That Uses an Index Spool Operation May Cause an Assertion	2005-10-25
7.00.1094	821279 MS03-031: Security patch for SQL Server 7.0 Service Pack 4	2006-05-11
7.00.1094	815495 MS03-031: Cumulative security patch for SQL Server	2006-05-10
7.00.1092	820788 FIX: Delayed domain authentication may cause SQL Server to stop responding	2005-10-25
7.00.1087	814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation	2005-09-27
7.00.1079	329499 FIX: Replication Removed from Database After Restore WITH RECOVERY	2005-10-11
7.00.1078	327068 INF: SQL Server 7.0 Security Update for Service Pack 4	2005-09-27
7.00.1077	316333 SQL Server 2000 Security Update for Service Pack 2	2006-11-24
7.00.1063	SQL Server 7.0 Service Pack 4 (SP4)	2002-04-26
7.00.1033	324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactions	2005-10-12
7.00.1026	319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED	2005-10-18
7.00.1004	304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers	2004-08-05
7.00.996	299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have	2004-08-09
7.00.978	285870 FIX: Update With Self Join May Update Incorrect Number Of Rows	2003-10-28
7.00.977	284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3	2002-04-25
7.00.970	283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled	2002-10-15
7.00.970	282243 FIX: Incorrect Results with Join of Column Converted to Binary	2003-10-29
7.00.961	SQL Server 7.0 Service Pack 3 (SP3)	2000-12-15
7.00.921	283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled	2002-10-15
7.00.919	282243 FIX: Incorrect Results with Join of Column Converted to Binary	2003-10-29
7.00.918	280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures	2004-06-29
7.00.917	279180 FIX: Bcp.exe with Long Query String Can Result in Assertion Failure	2005-09-26
7.00.910	275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221	2003-10-31
7.00.905	274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624	2004-07-15
7.00.889	243741 FIX: Replication Initialize Method Causes Handle Leak on Failure	2005-10-05
7.00.879	281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349	2006-03-14
7.00.857	260346 FIX: Transactional Publications with a Filter on Numeric Columns Fail to Replicate Data	2006-03-14
7.00.843	266766 FIX: Temporary Stored Procedures in SA Owned Databases May Bypass Permission Checks When You Run Stored Procedures	2006-03-14
7.00.842	SQL Server 7.0 Service Pack 2 (SP2)	2000-03-20
7.00.839	SQL Server 7.0 Service Pack 2 (SP2) Unidentified
7.00.835	SQL Server 7.0 Service Pack 2 (SP2) Beta
7.00.776	258087 FIX: Non-Admin User That Executes Batch While Server Shuts Down May Encounter Retail Assertion	2006-03-14
7.00.770	252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table	2006-03-14
7.00.745	253738 FIX: SQL Server Components that Access the Registry in a Cluster Environment May Cause a Memory Leak	2005-10-07
7.00.722	239458 FIX: Replication: Problems Mapping Characters to DB2 OLEDB Subscribers	2005-10-05
7.00.699	SQL Server 7.0 Service Pack 1 (SP1)	1999-07-01
7.00.689	SQL Server 7.0 Service Pack 1 (SP1) Beta
7.00.677	SQL Server 7.0 MSDE from Office 2000 disc
7.00.662	232707 FIX: Query with Complex View Hierarchy May Be Slow to Compile	2005-10-05
7.00.658	244763 FIX: Access Violation Under High Cursor Stress	2006-03-14
7.00.657	229875 FIX: Unable to Perform Automated Installation of SQL 7.0 Using File Images	2005-10-05
7.00.643	220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special Characters	2005-10-05
7.00.623	SQL Server 7.0 RTM (Gold, no SP)	1998-11-27
7.00.583	SQL Server 7.0 RC1
7.00.517	SQL Server 7.0 Beta 3

Microsoft SQL Server 6.5 Builds

Build	KB / Description	Release Date
6.50.480	238621 FIX: Integrated Security Sprocs Have Race Condition Between Threads That Can Result in an Access Violation	2005-10-07
6.50.479	273914 Microsoft SQL Server 6.5 Post Service Pack 5a Update	2000-09-12
6.50.469	249343 FIX: SQL Performance Counters May Cause Handle Leak in WinLogon Process
6.50.465	250493 FIX: Memory Leak with xp_sendmail Using Attachments
6.50.464	275483 FIX: Insert Error (Msg 213) with NO_BROWSETABLE and INSERT EXEC	1999-11-08
6.50.462	238620 FIX: Terminating Clients with TSQL KILL May Cause ODS AV
6.50.451	236447 FIX: ODS Errors During Attention Signal May Cause SQL Server to Stop Responding
6.50.444	240172 FIX: Multiple Attachments not Sent Correctly Using xp_sendmail
6.50.441	234679 FIX: SNMP Extended Stored Procedures May Leak Memory
6.50.422	187278 FIX: Large Query Text from Socket Client May Cause Open Data Services Access Violation
6.50.416	197176 Microsoft SQL Server 6.5 Service Pack 5a (SP5a)	1998-12-24
6.50.415	Microsoft SQL Server 6.5 Service Pack 5 (SP5)
6.50.339	Y2K hotfix
6.50.297	«Site Server 3.0 Commerce Edition» hotfix
6.50.281	178295 Microsoft SQL Server 6.5 Service Pack 4 (SP4)
6.50.259	6.5 as included with «Small Business Server» only
6.50.258	Microsoft SQL Server 6.5 Service Pack 3a (SP3a)
6.50.252	Microsoft SQL Server 6.5 Service Pack 3 (SP3)
6.50.240	160727 Microsoft SQL Server 6.5 Service Pack 2 (SP2)
6.50.213	153096 Microsoft SQL Server 6.5 Service Pack 1 (SP1)
6.50.201	Microsoft SQL Server 6.5 RTM	1996-06-30

Microsoft SQL Server 6.0 Builds

	Build	KB / Description	Release Date
6.00.151	Microsoft SQL Server 6.0 Service Pack 3 (SP3)
6.00.139	Microsoft SQL Server 6.0 Service Pack 2 (SP2)
6.00.124	Microsoft SQL Server 6.0 Service Pack 1 (SP1)
6.00.121	Microsoft SQL Server 6.0 RTM

Источник

Размещу это тут. В интернете полно копипаста данного мануала, но все-таки раз у нас есть раздел «мануалы», то у нас он тоже должен быть.)

Распаковываете сервер в любое удобное место.
Например: C:server…….

Далее нам необходимо настроить основные конфигурационные файлы сервера:

1) Открываем AuthDetcconfig.txt
Изменяем DevServerIP=»IP» на ваш WAN IP, это ваш внешний IP адрес.
Изменяем logdip=»IP» на ваш LAN IP, это ваш внутренний IP адрес.

2) Открываем CacheDl2cache.ini
Изменяем address=» IP» на ваш LAN IP, это ваш внутренний IP адрес.
Изменяем MailServer=» IP» на ваш LAN IP, это ваш внутренний IP адрес.

3) Открываем L2logDl2logd.ini
Изменяем address=» IP» на ваш LAN IP, это ваш внутренний IP адрес .

4) Открываем L2NPC l2npc.ini
Изменяем в 4-х местах address=» IP» на ваш LAN IP , это ваш внутренний IP адрес .

5) Открываем L2Serverl2server.ini
Изменяем в 5-ти местах address=» IP» на ваш LAN IP, это ваш внутренний IP адрес.
Изменяем MailServer=» IP» на ваш LAN IP, это ваш внутренний IP адрес.
reconnectauth=1 оставляем без изменения.

6) Открываем PetitionD PetitionD.exe.config
Изменяем key=»NoticeServiceAllowIpList» value=» IP» на ваш LAN IP, это ваш внутренний IP адрес.
Изменяем key=»AuthIp» value=»IP» на ваш LAN IP, это ваш внутренний IP адрес.

Petition – устанавливается как служба, для установки в каталоге PetitionD, есть файл install.bat, отредактируйте под свои установки.

INSTALL_UTIL_HOME = указывается путь к службе Microsoft.NET Framework.
SERVICE_HOME = путь к petition .
USER_NAME = имя пользователя Windows , возможно MSSQL …
PASSWORD = пароль доступа Windows, возможно MSSQL…

После данных настроек мы запускаем данный файл. Petiton я не запускал, т.к. не было необходимости.

На этом мы подготовили основные конфигурационные серверные файлы, теперь перейдем к настройки
SQL части сервера:

1) Открываем DBScript2_lin2comm.sql
найдите в 3-х местах:
set @conn_str = ‘127.0.0.’ + @world_id + »’;»user»;»pass’ — возможно вы не найдёте такую строчку, попробуйте поискать set @conn_str
измените 127.0.0. на ваш LAN IP (без последней цифры)
измените user на ваш SQL аккаунт
измените pass на ваш SQL пароль

далее найдите:
‘ SQLOLEDB’, ‘ 127.0.0.1′;’ user’;’ pass’ — возможно вы не найдёте такую строчку, попробуйте поискать ‘SQLOLEDB’
измените 127.0.0.1 на ваш LAN IP
измените user на ваш SQL аккаунт
измените pass на ваш SQL пароль

2) Открываем DBScript7_lin2world.sql
найдите в 3-х местах:
set @conn_str = ‘127.0.0.’ + @world_id + »’;»user»;»pass’ — возможно вы не найдёте такую строчку, попробуйте поискать set @conn_str
измените 127.0.0. на ваш LAN IP (без последней цифры)
измените user на ваш SQL аккаунт
измените pass на ваш SQL пароль

далее найдите:
‘SQLOLEDB’, ‘127.0.0.1’;’user’;’pass’ — возможно вы не найдёте такую строчку, попробуйте поискать ‘SQLOLEDB’
измените 127.0.0.1 на ваш LAN IP
измените user на ваш SQL аккаунт
измените pass на ваш SQL пароль

Установка базы данных MSSQL:

MS SQL Server 2005 Enterprise Edition, устанавливаем диск с данным ПО.
Нажимаем на Server components, tools, Books Online, and samples(под красными буквами Install), потом 4 раза Next.
Должно попросить серийник, WXGDG-DJ8DJ-CC77F-8FDJV-DFBYG, у меня не спрашивало серийный номер. Жмём Next…
Ставим, галочки перед SQL Server Database Services и Client Components Management Tools, жмём 2 раза Next
Выбираем Use the built-in System account,во вкладке выбираем Local system, жмём Next
Крайне рекомендую нажать на Mixed Mode и ввести пароль для sa. Для базы я именно этот логин и пароль использовал, жмём 3 раза Next, потом Install
жмём Next, жмём Finish.

Установка баз в MSSQL

Зайдите в Start -> All PROGRAMMS Microsoft SQL Server 2005 и запустите SQL Server Management Studio
Нажмите Connect, с лева выберите свой комьютер, потом на Databases. В центральном окне нажмите правой кнопкой мыши и выберите New Database…
Напротив Database name введите lin2clancomm, нажмите ОК
так проделайте и для lin2comm, lin2log, lin2db, lin2report, lin2user, lin2world.
Должно получиться 7 баз. Закройте это окно.

Зайдите в DBScript. Нажмите два раза на 1_lin2clancomm.sql, выскочит окошко, нажмите Connect. В левом верхнем углу будет вкладка, там должно быть написано master, выберите lin2clancomm. Чуть правее будет Execute, и возле неё будет кнопка Parce. Нажмите сначала Parce, чуть подождите и нажмите Execute. После завершения операции сохраняем всё.
Аналогично проделайте для всех баз. Будьте внимательны, когда будете загружать *.sql, когда загрузите по умолчанию во вкладке будет master, выбирайте во вкладке ту базу которая соответствует своему файлу, которые указанны ниже:

1_lin2clancomm.sql ……. lin2clancomm
2_lin2comm.sql ……. lin2comm
3_lin2db_.sql………….lin2db
4_lin2log.sql …………..lin2log
5_lin2report.sql………lin2report
6_lin2user.sql………….lin2user
7_lin2world.sql……….lin2world
После установки закрываем это окно .

Зайдите в Start -> All PROGRAMMS Microsoft SQL Server 2005 и запустите SQL Server Management Studio
Нажмите Connect, с лева выберите свой компьютер, потом на Databases.
Ищем там базу данных lin2db. Жмём на неё 2 раза. Находим там иконку подписанную как Tables и 2 раза нажимаем. Появиться список. Ищем в списке Server жмём на нём правой кнопкой, ищем слова Open Table и нажимаем. Добавляем следующую информацию в появившееся окошко (настраиваем под себя):

id = 0
name = такое же имя как напротив worldname в l2server.ini
ip = ваш внешний IP адрес, для коннекта к вашему серверу извне.
inner_ip = ваш внутренний IP адрес
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777

Закрываем это окно.

Установка файлового DSN, для базы данных сервера:

!!!!! ВАЖНО !!!!!!
Создавать DSN нужно в папке Program Files(86), а не в Program Files.

Пуск->Настройка-> Панель управления-> Administrative Tools -> Data Sources (ODBC)
Ищем закладку Файловый DSN, нажимаем на неё и там нажимаем на кнопку Добавить…
Из списка выбираем SQL Server обычно в самом низу и жмём Далее
Задаём имя lin2world и жмём Далее пока не появиться окошко выбора сервера.
Поле Описание оставляем пустым, в нижнем поле выбираем (local)
Жмём Далее до тех пор пока не будет написано Сменить базу по умолчанию на. Ставим галку и выбираем lin2world
Такую операцию проделать для всех 6 баз, только естественно одноименных DNS
lin2comm
lin2db
lin2log
lin2report
lin2db
lin2db

Запуск Сервера

Запускать только в этом порядке:

1) L2LogD.exe
File DB = lin2log
login name = Ваш SQL аккаунт
password = Ваш SQL пароль

2) CacheD.exe
File DB = lin2world
login name = Ваш SQL аккаунт
password = Ваш SQL пароль

При запуске CacheD.exe возможно попросит ввести серийный номер, для этого распаковываем архив keygens.7z в любое для вас место, далее запускаем файл CacheDSNGen.exe, для этого нам необходимо ввести:
* Mac Adress = сетевой карты
Machine Name = название вашего компьютера
Далее нажимаем Generate и получаем Serial Number.

*Для получения Mac Adress, необходимо проделать следующие, Пуск —— Выполнить ——- и набрать команду cmd, появится командная строка, в данной строке набираем
ipconfig –all и видем список сетевого оборудования, и ищем строку MAC Adress(Физический адрес) – например: 00-17-31-4F-D8-B2 это и есть наш Mac Adress, который необходим для генератора серийного номера. Также проделать для L2AuthD.exe и L2Server.exe.

3) L2AuthD.exe
File DSN = lin2db
login name = Ваш SQL аккаунт
password = Ваш SQL пароль

4) PetitionD.exe – можно пропустить данный пункт если не хотите устанавливать.
Server = (local)
login name = Ваш SQL аккаунт
password = Ваш SQL пароль
Database = petition

5) l2comm.exe

6) L2Server.exe

7) L2NPC.exe

L2ASP система регистрации аккаунта:

L2ASP.zip нужно распаковать в C:Inetpubwwwroot

Далее редактируем файл конфигурации conn.asp
ms_sql_server_host_addr = «ваш ip»
sql_server_username = «Ваш логин для MSSQL»
sql_server_password = «Ваш пароль для MSSQL»

По умолчанию в Windows 2003 server стоит максимальная защита, и поэтому нужно сделать следующее:
Пуск->Настройка->Панель управления->Администрирование-> Диспечер служб IIS
Слева будет имя вашего компьютера, нажмите на него, потом на Веб-узлы, потом правой кнопкой на Веб-узел по умолчанию
нажмите на свойства, ищите вкладку Документы, потом нужно нажать на Добавить и введите index.asp, потом делаем так чтобы index.asp был в самом верху

Слева будет имя вашего компьютера, нажмите на него, потом на Расширения веб-службы, выделить Active Server Pages и нажать Разрешить
Чтобы попасть на ваш сайт пропишите

Вы не можете просматривать ссылку пожалуйста воспользуйтесь следующими ссылками Вход или Регистрация

вашего компьютера.

Создание Gm аккаунта

Откройте таблицу builder_account в базе lin2world и добавте следуюущее:
account_name = имя вашего аккаунта (должен уже существовать)
default_builder = 1,2,3,4…9 (уровень доступа)
account_id = ID аккаунта (можете найти в таблице user_account в базе lin2db)
Откройте таблицу user_data в базе lin2world
и поменяйте права GM’a:
builder = default_builder (1,2,3,4…9)

Источник

Требования к аппаратному обеспечению

Требования к программному обеспечению

Установка MS SQL Server 2005

README

Background

Server Specification

Hosts

Cluster Administrator

Domain Accounts

Setup

Fail

Analyze Errors

FIX

Create the missing directory

Copy the files

Try Starting SQL Server (Again)

Inspect file locations

Update file locations

mssqlserverresource

master

model

msdb

tempdb

Try Again

Local Security Settings

Try Once Mode …

<img decoding="async" onError="javascript: wp_broken_images = window.wp_broken_images || function(){}; wp_broken_images(this);" alt="RRS feed" src="https://i1.social.s-msft.com/globalresources/Images/trans.gif?cver=0001" />

Вопрос

Ответы

Все ответы

Требования к аппаратному обеспечению

Требования к программному обеспечению

Установка MS SQL Server 2005

Описание

Версии

Полезные ссылки и статьи

Часто используемые термины и сокращения

Какие самые последние обновления доступны для SQL Server?

Установочные файлы Microsoft SQL Server с прямыми ссылками на загрузку

Версии SQL Server и уровни совместимости

Общая информация по Service Pack

Microsoft SQL Server VNext Builds

Microsoft SQL Server 2016 Builds

Microsoft SQL Server 2014 Builds

Microsoft SQL Server 2012 Builds

Microsoft SQL Server 2008 R2 Builds

Microsoft SQL Server 2008 Builds

Microsoft SQL Server 2005 Builds

Microsoft SQL Server 2000 Builds

Microsoft SQL Server 7.0 Builds

Microsoft SQL Server 6.5 Builds

Microsoft SQL Server 6.0 Builds