Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


I have 4 front-end sql server.

All of them have the same db instances. Data are replicated from back-end databases.


In SQL Management Studio I have registered the servers and I have created a group (called front_end). The group can be inquired using the sql editor opening a connection to the servers group.

Is it possible to inquire the group programmatically setting the USE clause?


    use [front-end]..myDatabaseInstance
    select * from myTable
share|improve this question
up vote 2 down vote accepted

If you right click the registered servers group and select "New Query" you get a query window that connects to all the servers, whatever you execute will run on all and return combined results.

If you want to programatically do it, you can use a central management server and query that for a list of servers, and use linked servers to run the query at each location using openquery

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.