BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 02-20-2010, 03:41 PM   #1
noname
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
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
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
Default

You did all that work and no Exchange or GW love?
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 02-20-2010, 06:01 PM   #3
noname
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
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


VINTAGE COMPUTER LABS ANALOG DEVICES A/D CONVERTER HAS-1002 picture

VINTAGE COMPUTER LABS ANALOG DEVICES A/D CONVERTER HAS-1002

$80.00



MEASUREMENT COMPUTING/COMPUTER BOARDS ANALOG INPUTS BOARD CIO-DAS16JR/16 16BIT R picture

MEASUREMENT COMPUTING/COMPUTER BOARDS ANALOG INPUTS BOARD CIO-DAS16JR/16 16BIT R

$751.06



CWT COMPUTER WELD TECHNOLOGY DART DIGITAL ANALOG REMOTE TRANSDUCER A3A0207 I8 picture

CWT COMPUTER WELD TECHNOLOGY DART DIGITAL ANALOG REMOTE TRANSDUCER A3A0207 I8

$99.94



computer board picture

computer board

$2350.00



Analog Keyboard And Mouse Functions Joystick Shield Boards Computer Applications picture

Analog Keyboard And Mouse Functions Joystick Shield Boards Computer Applications

$13.16



Rolls R PWR Supply RS232 Computer Marker I/O Digital Analog Card Reader picture

Rolls R PWR Supply RS232 Computer Marker I/O Digital Analog Card Reader

$309.39







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