Archive

Posts Tagged ‘SQL2005’

SQL SERVER: How to identify the SQL Server Version No?

February 9, 2008 shahharsh Leave a comment

To know the version of the SQL Server on your machine type follwoing statement in the SQL Server Management Studio

SELECT @@VERSION

Following is the result:

Microsoft SQL Server 2005 – 9.00.3054.00 (Intel X86)   Mar 23 2007 16:28:52   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Categories: SQL2005 Tags: