Knowledge Sharing - List of SQL Server Versions
As it's hard to find one consolidated one, I have compiled to share with all; as well as for my own future easy net search in future =)
Query Command: SELECT @@VERSION (A) SQL Server 2000 RTM - 8.00.194 SP1 - 8.00.384 SP2 - 8.00.534 SP3a - 8.00.760 (SP3a) SP4 - 8.00.2039 (B) SQL Server 2005 RTM - 9.00.1399.06 SP1 - 9.00.2047.00 SP2 - 9.00.3310.00 SP3 - 9.00.4035.00 (C) SQL Server 2008 RTM - 10.0.1600.22 SP1 - 10.00.2531.00 Source: SQL Server Version Builds - Big Database List Sample MAGT log entries showing SQL Server 2005 SP3 is used for BESMgmt DB: [35019] (01/06 00:00:00.723):{0xA38} [ENV] [DB] Database Schema Version: 5.0.0 <5.0.2009.03.19> [30000] (01/06 00:00:00.738):{0xA38} [ENV] [DB] Connection String = Server= SQLSvr01.rim.net;Database=BESMgmt;Trusted_Connecti on=Yes [30000] (01/06 00:00:00.738):{0xA38} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 09.00.4035; Provider Name = sqlncli.dll; Provider Friendly Name = Microsoft SQL Native Client; OLE DB Version = 02.80; Provider Version = 9.00.1399.06; Failover Partner = SQLSvr02 xxx12304;System Requirements for BES Domino 4.1 SP7xxx12305; • MSDE 2000 SP3 • Microsoft® SQL Server® 2000 SP4 • Microsoft SQL Server 2005 SP3 • Microsoft SQL Server 2005 Express SP3 • Microsoft SQL Server 2005 SP3 (64-bit) For all versions of the Microsoft SQL Server that are earlier than Microsoft SQL Server 2005 SP3, visit http://technet.microsoft.com to read KB960082 and Microsoft Security Bulletin MS09-004. xxx12304;System Requirements for BES Domino 5.0 SP1xxx12305; • MSDE 2000 SP3 • Microsoft® SQL Server® 2005 SP3 (32-bit or 64-bit) • Microsoft SQL Server 2005 Express Edition SP3 • Microsoft SQL Server 2008 (32-bit or 64-bit) • Microsoft SQL Server 2008 SP1 (32-bit or 64-bit) • Microsoft SQL Server 2008 Express Edition (32-bit or 64-bit) • Microsoft SQL Server 2008 Express Edition SP1 (32-bit or 64-bit) For all versions of the Microsoft SQL Server earlier than Microsoft SQL Server 2005 SP3, Microsoft Security Bulletin MS09-004 (for more information, visit http:// technet.microsoft.com to read article KB960082). Database mirroring: To support database mirroring for the BlackBerry Configuration Database or BlackBerry MDS Integration Service database, the following conditions: • the database server must be Microsoft SQL Server 2005 SP3 Enterprise Edition (32- bit or 64-bit), Microsoft SQL Server 2008 Enterprise Edition (32-bit or 64-bit), or Microsoft SQL Server 2008 SP1 Enterprise Edition (32-bit or 64-bit) • the database server that hosts the mirror database must use the same version and build as the principal database • a separate database server for the mirror database • static port with the same port number for both database servers • Microsoft SQL Server Browser running on both database servers Database transactional replication: To support database transactional replication for the BlackBerry Configuration Database or BlackBerry MDS Integration Service database, the following conditions: • the database server must be Microsoft SQL Server 2005 SP3 or later • the database server that hosts the replicated database must use the same version and build as the primary database |
You did all that work and no Exchange or GW love?
|
Please feel free to add on your love, knottyrope =P
|
All times are GMT -5. The time now is 05:02 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.