[thelist] versions of sql & VisualStudio

Anthony Baratta anthony at baratta.com
Thu Aug 9 17:22:44 CDT 2007

For SQL 2005


How to determine which version of SQL Server 2005 is running
To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:

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

The results are:
•	The product version (for example, "9.00.1399.06").
•	The product level (for example, "RTM").
•	The edition (for example, "Enterprise Edition").

For example, the result looks similar to:
9.00.1399.06	RTM	Enterprise Edition
The following table lists the Sqlservr.exe version number:
Release	Sqlservr.exe

RTM	2005.90.1399
SQL Server 2005 Service Pack 1	2005.90.2047
SQL Server 2005 Service Pack 2	2005.90.3042

-----Original message-----
From: Lightening oktellme at earthlink.net
Date: Thu, 09 Aug 2007 14:04:40 -0700
To: thelist at lists.evolt.org
Subject: [thelist] versions of sql & VisualStudio

> I am trying to get version information about sqlserver2005 and VisualStudio2005 on my computer. 
> I know "about" will give version number; it's not version number I want.
> It's the name - "developer's", "standard", "express". Can someone please tell me how to get it?
> I can't find the my software. 
> thanks
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

More information about the thelist mailing list