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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-07-21 : 10:58:32
|
| where can I check within SQL to determine if I am using Per Seat licensing or per processor licensing... Thanks,Jay |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-21 : 12:02:59
|
| SELECT SERVERPROPERTY('LicenseType')GOSELECT SERVERPROPERTY('NumLicenses')GOBrett8-) |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2003-07-21 : 12:22:04
|
| Brett,Is this information stored somewher in the Registry, because I have several sQL server and I have a tool call ECM which can go through server and capture registry fields so it will be easier for me to track... Please let me know where the info would be stored in registy..Thanks,JaySELECT SERVERPROPERTY('LicenseType')GOSELECT SERVERPROPERTY('NumLicenses')GOBrett8-)[/quote] |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-21 : 12:28:04
|
| I mean I guess it must be...but I've never played with the registry if I could help it...How many servers are we talking about...Brett8-) |
|
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2003-07-21 : 12:39:12
|
| Approx 40-50 servers....Thanks,JayI mean I guess it must be...but I've never played with the registry if I could help it...How many servers are we talking about...Brett8-)[/quote] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-21 : 12:42:36
|
| Just run osql at the command line. You could easily script out a batch job to connect to the 40-50 servers and run the selects using osql.Tara |
|
|
|
|
|
|
Licensing Issue