Open up SQL Enterprise Manager from Start-Programs. Browse under MS SQL Servers, SQL Server Group, (local) (Windows NT). Right click on the Local windows NT and select properties. In properties you will see product version (ex. 8.00.760 [SP3]).
Here is a listing of the SQL versions by version #.
For SQL Server 2000:
2000 version Version and Service Pack
8.00.2039 SQL Server 2000 with Service Pack 4
8.00.760 SQL Server 2000 with Service Pack 3a
8.00.760 SQL Server 2000 with Service Pack 3.
8.00.532 SQL Server 2000 with Service Pack 2
8.00.384 SQL Server 2000 with Service Pack 1
8.00.194 SQL Server 2000 with no service pack
7 version Version and Service Pack
7.00.1063 SQL Server 7 with Service Pack 4
7.00.961 SQL Server 7 with Service Pack 3
7.00.842 SQL Server 7 with Service Pack 2
7.00.699 SQL Server 7 with Service Pack 1
7.00.623 SQL Server 7 with no service pack applied
6.5 version Version and Service Pack
6.50.479 SQL Server 6.5 with Service Pack 5a (updated)
6.50.416 SQL Server 6.5 with Service Pack 5a.
6.50.415 SQL Server 6.5 with Service Pack 5
6.50.281 SQL Server 6.5 with Service Pack 4
6.50.258 SQL Server 6.5 with Service Pack 3
6.50.240 SQL Server 6.5 with Service Pack 2
6.50.213 SQL Server 6.5 with Service Pack 1
6.50.201 SQL Server 6.5 with no service pack
Please rate any helpful posts
The above way might not be valid for MSDE since it doesn't have the Enterprise Manager. You should also be able to right click on the SQL Service Manager icon by the clock and chose About. This will display the version as well.
I can see the product name "SQL Server Desktop Engine" from the Enterprise Manager's SQL server properties. Is this meaning MSDE? then how display for the SQL server.
If I click "About" from the SQL icon tray, display as "Microsoft SQL Server Service Manager Version 8.00.760". How do I know if this is MSDE or SQL server?
Here is the link for determining if your install is MSDE or SQL.
Please rate any helpful posts
Also note that the GUSI tool already does this legwork for you - you can find the tool in the reporting section of the ToolsDepot or you can get the latest version on its home page here:
(for Connection) http://www.ciscounitytools.com/App_CUC_GUSI.htm
I ran the tool and get the following output. how do I know if this is MSDE or SQL server?
SQL Version = Microsoft SQL Server 2000 - 8.00.760: unknown SP
Windows version = 5.0 Build 2195: Service Pack 4
ah - I see, I'm being a bone head... GUSI kicks out the version stuff for you without having to dig in the registry but that's not what you want.
Digging around, there is no easy way to tell in the registry and rooting around in the logs is a recipie for pain. However I can query the system DB for "edition" information and spit it out with GUSI with only a minor change I think - I'll try it out and see about including it with an updated version I was going to post this afternoon.
OK - I added a check into GUSI which will put out the edition information - I updated both the Unity and Connection versions:
Connection - http://www.ciscounitytools.com/App_CUC_GUSI.htm
I tried it on several installs with both standard and desktop editions of SQL and it seems to work correctly. Let me know if you run into any trouble...