How to determine the edition installed

[simon_shek]

Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[Ray Miao]

select @@version


------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[Sunny]

Right Click on the server and choose properties. In SQL 7.0 server, the General tab - Product will read SQL Server Enterprise.

I am not aware of how to determine the edition in SQL 6.5 server.


------------
Ray Miao at 3/1/2002 9:27:11 AM

select @@version


------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[Sunny]

For Sql 7.0 and 2000
you can also determine by typing the following inthe command prompt:

odbcping /Sservername /Uusername /Ppassword

If enterprise edition it will say Enterprise edition on Windows NT among other details. However, i am not sure about SQL 6.5.

------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[Ray Miao]

For sql6.5, check HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServerSetu pProductSuite to see if has value enterprise.




------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[simon_shek]

Hi all,

" select @@version " just show the version no of mssql. I wnat to know the edition of mssql installed. What is the different no. among enterprise edition, desktop edition and standard edition.

Thanks for your help

Regards,
Simon


------------
Sunny at 3/1/2002 12:00:39 PM

Right Click on the server and choose properties. In SQL 7.0 server, the General tab - Product will read SQL Server Enterprise.

I am not aware of how to determine the edition in SQL 6.5 server.


------------
Ray Miao at 3/1/2002 9:27:11 AM

select @@version


------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon

[simon_shek]

Dear all,

Thanks for your help! The version / edition can be seen by select @@version.
Thanks Ray Miao Sunny again!

Cheers,
Simon


------------
Sunny at 3/1/2002 12:05:38 PM

For Sql 7.0 and 2000
you can also determine by typing the following inthe command prompt:

odbcping /Sservername /Uusername /Ppassword

If enterprise edition it will say Enterprise edition on Windows NT among other details. However, i am not sure about SQL 6.5.

------------
simon_shek at 2/28/2002 11:54:35 PM


Dear all,

Please tell me how to determne the editiion of mssql installed. I can only know the version but cannot know the edition.

Regards,
Simon