Way to retrieve SQL server version information
Do you want to get the extract version of the SQL server you have installed in your machine with the service packs? Try this on query window. SELECT @ @VERSION or for SQL Server 2000 and above the following is easier to parse SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), SERVERPROPERTY ( 'edition' ) Cheers.