Determine Microsoft SQL Server version (SQL)

Purpose: Since SCCM acts differently depending on the SQL-version, you might be interested to find out, which version is actually installed in your SCCM environment.

Once upon a time Microsoft released a list of supported SCCM configurations. The list also includes all the supported versions and what does it actually mean when you have one of the specific versions installed. Because of this it might be relevant for you to check the SQL version on which you are running your system and take note what it is capable of.

Query MS SQL Server Version
1
select @@version
select @@version

Will output (for example)

1
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0. (X64) Copyright (c) Microsoft Corportation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0. (X64) Copyright (c) Microsoft Corportation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Client Support Numbers for Sites and Hierarchies

http://technet.microsoft.com/en-US/library/gg682077#BKMK_SupConfigClientNumbers

Leave a Reply

Your email address will not be published. Required fields are marked *


two + = seven

Post Navigation