Tuesday 16 June 2009

Version of SQL Server and Service Pack

To Find out the version of Microsoft SQL Server and Service Packs installed

Query
=====
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Sample Output
=============
8.00.2039 SP4 Personal Edition

No comments:

Post a Comment