bibi92
asked on
script cmd for detecting sqlserver services and read key edition
Hello,
I search a script for detecting sqlserver services and read key edition.
Thanks
Regards
bibi
I search a script for detecting sqlserver services and read key edition.
Thanks
Regards
bibi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And of course you can run it against a SQL box by using SQLCMD utility at a command prompt if that's what you'd like.
ASKER
Thanks bibi
sc query <SERVICE_KEY_NAME> will do the trick.
for example: sc query MSSQLSERVER
It's not clear what do you mean with read key edition.
You can get service key name reading the properties from services.msc console.
HTH