Check Instance Info

By Pedro Lopes, 2007/12/19

Total article views: 918 | Views in the last 30 days: 137

Rate this |

Join the discussion |

Briefcase

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.

EDIT: Optimized method of finding scenario.

By Pedro Lopes, 2007/12/19

Total article views: 918 | Views in the last 30 days: 137

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

A Failed Jobs Monitoring System

By TJay Belt | Category: SQL Server 2005

| 7,823 reads

Available bytes for row expansion (adding columns) in a table

By ruchir | Category: SQL Server 2005

(not yet rated) | 339 reads

Row count and space used for all tables in database (update)

By Rafal S. | Category: Miscellaneous

| 1,263 reads

Proc to Rename a file

By Simon Facer | Category: Miscellaneous

| 18 reads

Like this? Try these...

Last day of the month

By Additional Articles | Category: Miscellaneous

| 60 reads

Shrink all databases

By Rafal S. | Category: Backup / Restore

| 1,345 reads

SQL Server T-SQL in 10 Minutes

By Steve Jones | Category: Book Reviews

(not yet rated) | 2,071 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com