CODEWITHSUNDEEP
sql-server-2008instancessms
HelloWorld1
HelloWorld1

Reputation: 14108

Find the instance name in management studio

How do I do in order to find and locate the current name of the active instance in SQL server 2008's SSMS?

My hostname is SAKURA-PC.
In my client I have two instance named MSSQLSERVER2008 and MSSQLSERVER.

Upvotes: 1

Views: 7861

Answers (1)

David Brabant
David Brabant

Reputation: 43459

select @@ServerName in query analyser gives you server\instance.

Upvotes: 3

Related Questions