Home / Software / Tips and Tricks / How do I know which version of SQL Server is running?

How do I know which version of SQL Server is running?

Updated:  09/27/2010 09:09 AM
Author:  Shiju Mathews

Status:    Resolved.


For SQL Server 7.0, 2000, and 2005, running the following will extract ONLY the version information.



And the following query will work on SQL Server 2000 and up: