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')

returns

| 8.00.2282 | SP4 | Standard Edition |

This reflects SQL 2000 SP4.