Tuesday, September 22, 2009

Verify what MS-SQL version is running

Ultimately found at http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185, here's how to identify what MS-SQL server version and service pack are running.

For example, executing the following in Query Analyzer:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

| 8.00.2282 | SP4 | Standard Edition |

This reflects SQL 2000 SP4.

1 comment: