SEO

#1 (**permalink**) 02-29-2008, 07:47 AM

Hi all,
I am performing a consolidation of all SQL servers in my environment. I
have run the tool to find out what level patching they have and what
edition they are running on, but is there a tool so I can scan the
network and find out what licensing they are setup for (processor vs.
seat)?

Even if I have to enumerate each one, one at a time I would be OK with
that. I just don't want to have to login to each server and go to
Control Panel and click on the Licensing.

Command line is super-duper.

Thanks,
Josh

#2 (**permalink**) 02-29-2008, 07:48 AM

select serverproperty('LicenseType')

You could write a script which uses osql.exe to connect to each server
and return the mode.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL Server license checker