How-To Software Technical

Identify Microsoft SQL Server version & edition

I wanted to┬ádetermine which version of Microsoft SQL Server 2008 was running on one of my servers. So I opened up SQL Server Management Studio (SSMS), and ran the following command as a new query window: SELECT SERVERPROPERTY (‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The following results are returned: -The product version (for example, 10.0.1600.22) -The […]