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.
Diary of technical happenstance, simple Internet accessible scratchpad, and brain dump to save myself later
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:
returns
This reflects SQL 2000 SP4.
For example, executing the following in Query Analyzer:
returns
This reflects SQL 2000 SP4.
Subscribe to:
Post Comments (Atom)
Testing
ReplyDelete