Need to know what type of licensing we have and how many license

[modglin]

I saw a a thread that mentioned:"In the Control Pannel you should see a "SQL Server 2000 Licensing Setup" icon. It's in there. "
I do not see anything about Licensign Setup in the control panel (Windows 2003 Server).
Is there something that I can run in Query Analizer?

 

[SQLBill]

Run this in Query Analyzer:

SELECT ServerProperty('LicenseType'),
       ServerProperty("NumLicenses')

Refer to the BOL for more information on ServerProperty.

-SQLBill

Posting advice: FAQ481-4875

 

[modglin]

The results were Disabled and Null. Apparently I was trying it correctly the first time I tried it, however, I did not have the results to grid and thought that the unknown column that showed up was an error.

 

[SQLBill]

Disabled means that licensing is disabled. Might mean you are using an evaluation copy or that you haven't entered the licenses or the licenses have expired.

I'm not sure as I've never seen that before and BOL doesn't say much about it.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

I get DISABLED and NULL when I query against a server running Developer Edition. So you could be running the developer edition (as well as a trial or eval copy).

If this is a production server you'll need to purchase a production edition of SQL (Standard or Enterprise).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com