check if there is an existing SQL server installation

is there a way to check an SQL Server installation, i want to get the version and what edition the installed sql server is. thanks

Hi,

Try this.Hope this works for you.

select @.@.Version

(or)

exec xp_msver

both will get you about the details of installed product.

Regards,

Prashanthi

|||can you do this.. without actually connecting in the sql server?|||you can do by navigating through the Help-> About|||

You can check the Errorlog to know whats the version and edition of sql server if you dont want to connect to sql server......hope this helps

|||

Hi,

You can know about the details of your SQL Server Installation detais, like version, etc.. in registry editor. To locate the verion information navigate to the following path in your registry editor:

1. Click Start button select "Run" command and type "regedit"

2. Search the following key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\CurrentVersion"

Or

You can also know your version by using "sqlcmd" utility.

1. In the command prompt, type "sqlcmd".

2. Type the following command exactly:

:exit(SELECT @.@.VERSION)

or

:exit(EXEC xp_msver)

I Hope it'll work. Please let me know If I m wrong.

Regards,

Kiran.Y

|||

Inaddition to what Kiran has said, you can execute the below query in sqlcmd to get the desired results...

select serverproperty('servername'),serverproperty('productversion'),serverproperty('edition'),serverproperty('productlevel')