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,226
Post Thanks: 371
Thanked 378 Times in 348 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 12 running sweet for my DTEK60
Offline  
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  
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

IS61LV25616AL-12TI ~ IS61LV25616 ASYNCHRONOUS CMOS STATIC RAM IC
$7.99
IS61LV25616AL-12TI ~ IS61LV25616 ASYNCHRONOUS CMOS STATIC RAM IC picture kr-d-wc deluxe kit kinetic water ram
$801.85
 kr-d-wc deluxe kit kinetic water ram pictureFerguson TE20 Banana Loader Ram Seal Repair Kit
$41.9
Ferguson TE20 Banana Loader Ram Seal Repair Kit pictureRam Clutches 488 Mechanical Release Bearing
$52.32
Ram Clutches 488 Mechanical Release Bearing pictureSimplex RFS20 Pancake Hydraulic Cylinder Ram 20 Ton
$195.99
Simplex  RFS20 Pancake Hydraulic Cylinder Ram 20 Ton picture






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