SQL 2000 License determination script

[mutley1]

Hi guys,

I've looked through all the posts but cant find anything. does anyone have a T-SQL script that would pull back the license information for the SQL server, or do I have to log onto each box and check in control panel?

Thanks in advance,

M.

 

[SQLBill]

Depends on what you are looking for, SERVERPROPERTY might be what you need.

Refer to the BOL, use the Index tab and enter SERVERPROPERTY.

SELECT SERVERPROPERTY(LicenseType)

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875