August 15, 2007 at 12:34 pm
I need to audit my environment for SQL licenses. Using SERVERPROPERTY doesn't always return the correct information and registry keys containing that information, isn't always present.
I'm looking for a universal way of retrieving the same information that I can get via the "SQL Server 2000 Licensing Setup" from the control panel. I want to do this programmatically, so I don't have to visit each server manually. I'm hoping SQL-SMO can get me this info, anyone familiar with SMO classes and know whether this info is available via SMO?
Thanks.
August 16, 2007 at 4:24 am
Sorry,
I don't think I can help you but I'm curious why you're saying that SERVERPROPERTY doesn't always return the correct information. Do you have examples of that /
Markus
[font="Verdana"]Markus Bohse[/font]
August 16, 2007 at 1:13 pm
I'm unsure of the exact circumstances, but here's the KB article:
http://support.microsoft.com/kb/291332
Sometimes querying for 'NumLicenses' will sometimes come back as null, and 'LicenseType' as DISABLED. Going to the Control Panel applet reveals different information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply