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 Development (2000)
 how can i find if sql server is ...

Author  Topic 

chiky
Starting Member

3 Posts

Posted - 2007-10-16 : 11:12:37
Hi,

how can i find if sql server 2000 is per processor or server + client(CAL)!

thanks
chiky

Kristen
Test

22859 Posts

Posted - 2007-10-16 : 11:18:11
I don't think you can, from the installed software on the server. I think you have to check the box it came in ... but I could be wrong on that.

Kristen
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-16 : 11:24:42
SELECT SERVERPROPERTY('LicenseType')

quote:
PER_SEAT = Per Seat mode
PER_PROCESSOR = Per-processor mode
DISABLED = Licensing is disabled.


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-10-16 : 11:49:07
Ah ... now you mention it : it is shown in the Server Properties isn't it, so makes sense that there is a SERVERPROPERTY for it.

If I was young and had a memory like an Elephant Peso how much more I could achieve ...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-20 : 00:49:47
Or look at sql server licensing in control panel.
Go to Top of Page
   

- Advertisement -