Hi All,

        I have requirement to write power-shell script to find the sql version from control panel and display version of sql server and if not installed required to show message as "No Sql".Can any one help me how can I d

Simple just use Win32_Product.

PS C:\scripts> gwmi win32_product -Filter 'name like "Microsoft SQL Server 2012%"'|select name,version

name                                      version
----                                      -------
Microsoft SQL Server 2012                 11.1.3000.0

I've got a script that I wrote that does this plus a little more that may be useful to you.

http://gallery.technet.microsoft.com/scriptcenter/Get-SQLInstance-9a3245a0

Hi Jrv,

         Thanks for your blaze reply.I would like to write more then 3 to 4 likes like  Microsoft Sql Server 2000,Microsoft Sql Server 2005,Microsoft Sql Server 2008,Microsoft Sql Server 2008 r2 and Microsoft Sql Server 2012.Hope you re

The script will give you every version of SQLServer installed.