Environment:
SQL Server version identification
SQL Server version identification
Resolution:
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Connect to a SQL instance in Management Studio, and select New Query
Copy and paste the following query into the query editing window
--- Execute Against the Master Database
SELECT CASE WHEN CHARINDEX('64', CAST(SERVERPROPERTY('Edition') AS
VARCHAR(100))) > 0
THEN 64
ELSE 32
END;
Verify that the MASTER database is selected and Click Execute SELECT CASE WHEN CHARINDEX('64', CAST(SERVERPROPERTY('Edition') AS
VARCHAR(100))) > 0
THEN 64
ELSE 32
END;
The Results window will display 32 or 64, indicating either a 32 or 64 bit system, respectively.
Alternatively you can execute the following query to return the complete SQL version and build.
select @@version
Example output:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Released for: Schneider Electric Hong Kong
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales enquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.
