One problem one of my client recently faced was to find out the SQL version or service pack is installed.

One easy way of doing it is by connecting to SQL Server 2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY (’productversion’) as product_version,
SERVERPROPERTY (’productlevel’) as service_pack,
SERVERPROPERTY (’edition’) as server_edition