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 |
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
 Posted - 2001-04-19 : 12:21:29
|
| Does any one know how to tell what license SQL 2000 is running? If it is setup for 5 users or 10 users or a processor license. Is there a way to look at that information thru Enterprise Manager or some how else and figure out which one it is?helena |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-05-02 : 03:40:13
|
| OK so now you can all tell that I'm chasing up licencing...even so desperate as to look through these old threads.Anyone fill me in on Select SERVERPROPERTY('lincensetype')just returns NULL to me....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-02 : 08:43:23
|
| Probably because it was spelled incorrectly (lincensetype):ServerProperty('LicenseType') |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-05-02 : 12:00:51
|
| Ok, it seems my production clustered server is setup for 2 licenses in Per Seat Mode. After doing some reading, it seems the only way to change this is to reinstall.What are the implications of this license setup. Could this be causing "Timeout connecting to SQL Server" issues? I think it is.Is it also possible that how you have licensing setup has no bearing on the performance and number of connections SQL server will allow?Michael |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-05-02 : 19:42:51
|
quote:
Probably because it was spelled incorrectly
doh--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
SQL Server 2000 Licensing