SQL Reviewer

Wednesday, 10th March 2010.

Determine SQL Server Version

Posted on Monday, 20th April 2009 by kwatog

In case you need to know what version of SQL Server you are currently using, you can use the queries below.

Starting at SQL Server 2000, you can use the following query.

SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)

The above query is applicable for SQL Server 2000, SQL Server 2005 and SQL Server 2008. For SQL Server [...]

Posted on Thursday, 9th April 2009 by kwatog

A handy SQL query you can use to monitor server processes. With the lack of advanced SQL editor and DBA Tools, this query will be very helpful.