How to tell what version of SQL 2005 is intalled (Enterprise or standard)

I need to make sure that the proper version of SQL Server 2005 was installed on the production server.

What do I do to find out?

Thanks in advance!

Connect to the instance using SQLCMD and run:

1> select @.@.version;
2> go

You should get output that looks like:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The 9.00.1399.06 is the version for SQL Server 2005 RTM.

Or from SQLCMD you can run:

1> select CONVERT(char(20), SERVERPROPERTY('productversion'));
2> go

Which will output:

9.00.1399.06

Also, if you connect to the server using SQL Server Management Studio, the version is displayed in Object Explorer on the root server node. Here it's displayed as 9.00.1399.

Cheers,
Dan

|||

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Name: Edition

Type: REG_SZ

Data: Enterprise Edition

This result supports you install SQL Server 2005 on a clean machine. Most often, you should check the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\Setup if you install multiple instances.

|||

In my previous posting,

"This result supports you install SQL Server 2005 on a clean machine."

should be

"This result supposes you install SQL Server 2005 ENT on a clean machine."

In addition, you can also get the version information from the registry key by checking the value of "Version".

sql