CODEWITHSUNDEEP
sql-server-2008sql-server-2008-r2
Tim Bond
Tim Bond

Reputation: 21

Determining the type of database

I got a new Pc which was having both Sql server2008 and sql server2008 R2, I am not able to recognise that which instance name belongs to Sql server2008 and which to Sql server2008R2. How can i come to know it.

Upvotes: 2

Views: 38

Answers (1)

Asif
Asif

Reputation: 2677

Try this. It will work for you.

Select  @@VERSION as [Server Version],@@ServerName [Instance Name]

Upvotes: 2

Related Questions