How many CALs does my server has

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 2005 Forums

SQL Server Administration (2005)

How many CALs does my server has

Author

Topic

mamede
Starting Member

1 Post

Posted - 2008-02-28 : 05:43:53

How can I see how many CALs do I have on my SQL Server?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-28 : 05:51:01

[code]Select ServerProperty('NumLicenses')[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-28 : 06:28:32

Also check to see if CAL or per processor is used

SELECT	SERVERPROPERTY('MachineName'),
	SERVERPROPERTY('LicenseType'),
	SERVERPROPERTY('NumLicenses')

E 12°55'05.25"
N 56°04'39.16"

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-02-28 : 09:19:48

Servers do not have CALs, clients have CALs.

I think you will find that SERVERPROPERTY('NumLicenses') will return NULL, and SERVERPROPERTY('LicenseType') will return DISABLED on a SQL 2005 server. The SQL Server 2005 install does not even ask for license info.

CODO ERGO SUM

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-01 : 22:27:49

True. You have to document cals by yourself.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources