March 20, 2013 at 4:20 pm
Hi
I have a database table that contains all the server details. I have a query and wanted to run against all servers available in the table.
Sample Query:
SELECT DISTINCT Col1, Col2 FROM dbo.Test
Requirement
1. Connect to one server
2. Run the Query against all the user DB and save the results into a table.
Please suggest a best way to from SQL server.
Thanks
Shuaib
March 20, 2013 at 4:52 pm
Have a look at this, perhaps it will help.
http://msdn.microsoft.com/en-us/library/ms188427(v=sql.105).aspx
March 23, 2013 at 2:27 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy