BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-20-2010, 02: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, 03:32 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,754
Post Thanks: 274
Thanked 296 Times in 280 Posts
Default

You did all that work and no Exchange or GW love?
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Offline  
Old 02-20-2010, 05: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  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





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