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.
| Author |
Topic |
|
ljp099
Yak Posting Veteran
79 Posts |
 Posted - 2005-01-11 : 22:00:34
|
| Im trying to find out what type of sql server im working on is. How can I find out if it is an evaluation edition, a standard or enterprise edition and if it has a working license?thanks |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-11 : 22:33:14
|
Hi ljp,In query analyzer type and run the following.SELECT @@VERSION Mine returns:Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
|
 |
|
|
ljp099
Yak Posting Veteran
79 Posts |
Posted - 2005-01-12 : 00:20:08
|
| thanks. so if it is an evaluation version it will say so? i typed in the t-sql statement you advised and this is what i received:Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: ) Doesnt say how many processors licensed or if it is an evaluation version. thanks for the advice |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-12 : 08:46:13
|
| There are a couple of SQL Server versions which report the same thing using @@version, but show more detailed information at the top of their log files on the server - but I forget which versions this applies too :-(Enterprise Manager : [MyServer] : Managemenent : SQL Server Logs : CurrentDoubleClick the "Microsoft SQL Server 2000 - 8.00...." line near the top to see the whole message in a popup windowKristen |
|
|
|
|
|
|
Sql Server nfo