SQL Server Edition - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server Edition

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-01 : 07:36:16

Pete writes "SQL 2000 already installed on a NT server Server.

How can I tell what Edition I am running?

* Personal Edition
* Standard Edition
* Enterprise Edition

Thanks for your help.

Pete"

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-07-01 : 07:48:36

select @@version

gives me:

Microsoft SQL Server 2000 - 8.00.679 (Intel X86)
Aug 26 2002 15:09:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack2)

HTH

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources