Sharepoint 2010 and various Sql Server versions but which service pack ?


SharePoint 2010 is 64-bit only. It requires Windows Server 2008 SP2 or Windows Server 2008 R2. It will not run on a Server Core installation.It requires one of these versions of x64 SQL Server:

SQL Server 2005 Editions

SQL Server 2005 Enterprise Edition SP3 CU3 (Build 4220) or greater
SQL Server 2005 Standart Edition SP3 CU3 (Build 4220) or greater
SQL Server 2005 Express Edition

(Note: SQL Server 2005 goes out of mainstream support in April 2011)

SQL Server 2008 Editions
SQL Server 2008 Enterprise Edition SP1 CU2 (Build 2714) required , CU5 or later recommended (CU3 & CU4 not recommended)
SQL Server 2008 Standart Edition SP1 CU2 (Build 2714) required , CU5 or later recommended (CU3 & CU4 not recommended)
SQL Server 2008 Express Edition

SQL Server 2008 R2 Enterprise & Standart & Express editions.

How to check version of SQL Server

-- Method 1: Retrieve complete version info, parse results in C#
SELECT @@VERSION AS [SQLVersionInfo];
-- Method 2: Detecting the edition and version of SQL Server from T-SQL
IF SERVERPROPERTY('EngineEdition') = 3
    BEGIN
        PRINT 'Enterprise Edition'
        IF CONVERT(INT, CONVERT(FLOAT,
CONVERT(VARCHAR(3), SERVERPROPERTY('productversion')))) > 9
            BEGIN
                PRINT 'SQL Server 2008 or greater';
                -- Do something like use data compression on an index
            END
        ELSE
            BEGIN
                PRINT 'SQL Server 2005 or lower';
                -- Do something like create an index in online mode
            END
    END
ELSE
    BEGIN
        PRINT 'Standard Edition';
        -- Create an index in offline mode
    END
Advertisements

About bpostaci
Sr. Support Escalation Engineer in Microsoft.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: