Post reply

Query against registered server

  • March 14, 2014 at 3:34 am

    #305088

    Is it possible to write a stored procedure that will be used registered server?

    For example I have registered server named 'Test Servers' and I want to use it in stored procedure

    use [Test Servers]

  • March 14, 2014 at 4:31 am

    #1697077

    "Registered Server" is a feature within SSMS only. If you want to write a query using other servers (instances) you could set up a linked server.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • March 14, 2014 at 6:27 am

    #1697112

    Is any other option besides linked server?? I manage many servers and I need better solution than linked server.

  • March 14, 2014 at 6:35 am

    #1697116

    The only way I know of is to open a multiple-server query from within SSMS (with registerd servers). But it's not a programmable way to do it.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply