[thelist] versions of sql & VisualStudio
Anthony Baratta
anthony at baratta.com
Thu Aug 9 17:22:44 CDT 2007
For SQL 2005
http://support.microsoft.com/kb/321185
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