check if there is an existing SQL server installation

reggiepangilinanX

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

Prashanthi (GGK Tech)

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

reggiepangilinanX

can you do this.. without actually connecting in the sql server

Prashanthi (GGK Tech)

you can do by navigating through the Help-> About

Deepak Rangarajan

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

Kiran.Y (GGK Tech)

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

Deepak Rangarajan

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')