Pages

Wednesday, August 21, 2013

SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running | Journey to SQL Authority with Pinal Dave

To determine which version of SQL Server 2000/2005 is running, connect to SQL Server 2000/2005 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') The results are: The product version (for example, 8.00.534). The product level (for example, "RTM" or "SP2"). The edition (for example, "Standard Edition"). For… Continue Reading...

Source: SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running | Journey to SQL Authority with Pinal Dave