BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-20-2010, 03:41 PM   #1 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Arrow Knowledge Sharing - List of SQL Server Versions

Please Login to Remove!

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
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 02-20-2010, 04:32 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,139
Post Thanks: 353
Thanked 358 Times in 335 Posts
Default

You did all that work and no Exchange or GW love?
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Online  
Old 02-20-2010, 06:01 PM   #3 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

Please feel free to add on your love, knottyrope =P
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  




Copyright © 2004-2016 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.