Prev: For SQL Guru, create a trigger
Next: authentication issues?
From: Princy on 18 May 2010 20:56
Hi Experts

I have serveral SQL Server and many instances under each server. I have
problem in finding what are the editions of each instance. I know the
following techs

1. SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition') (T-SQL and ADO)
2. select @@VERSION (T-SQL and ADO)
3. Using freeware MAP
4. reading registry
5. Looking at the \LOG\errolog file

I have limitation is using this in our env. I am particularly expecting a
way to read from WMI. Can anyone forward me the script to read server name,
instance name, version and edition from WMI? or any other methods

Thanks in advance
--
Regards

Priw
 | 
Pages: 1
Prev: For SQL Guru, create a trigger
Next: authentication issues?