Ralf Eisenreich

SQLBlog.DE | ..things to remember

March 24th, 2009

SQL Server: Version, Service Pack, Edition

SQL Server, Uncategorized, by Ralf.

SQL Server: Version, Service Pack, Edition

Just run following command within Management Studio:
SELECT @@VERSION, SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

As result you receive something like:

Microsoft SQL Server 2005 - ... Windows NT 5.2 (Build 3790: SP 2)
  9.00.4035.00
  SP3
  Standard Edition (64-bit)

Tags: sql, SQL Server

Responses to “SQL Server: Version, Service Pack, Edition”

Comments (1) Trackbacks (0) Leave a comment Trackback url

You got a really excellent site, Gladiolus I located it by means of yahoo.

fahrrad mit hilfsmotor at November 18, 2011 9:37 pm Reply

No trackbacks yet.

Leave a Reply Cancel reply