confirm license method 1

[ScottCr]

Hi Guys,

I have a SQL 2005 installation that I've inherited.

Could someone please tell me how to confirm the method of licensing used. ie per processor or per user. If per user I also need to know how many cals there are.

It doesn't seem to work the same way as 2000 and so I'm a little stuck.

Thanks,

Scott.

 

[gmmastros]

Open a Query Analyzer window, copy/paste this code, and run it.

Select ServerProperty('LicenseType'), Serverproperty('NumLicenses')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Try running this, also...

Select ServerProperty('Edition'), 
       ServerProperty('Engine Edition'),
       ServerProperty('ProductVersion'),
       ServerProperty('ProductLevel')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ScottCr]

Thanks,

I get this:-

Standard Edition NULL 9.00.2047.00 SP1

Scott.

 

[mrdenny]

SQL 2005 doesn't ask what the licensing mode is during install. It's a trust thing now. You'll need to check your purchasing paperwork.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ScottCr]

Thanks Mrdenny.

We use Microsoft Select licensing, so I can just decide whether I want to use per processor or per cal.

Thanks guys.

http://scottcross.blogspot.com

Windows and NT Admin.