I have a bunch of queries that I'd like to run on a MS-SQL server. It's a remote server, and I'd like to run these queries in batch, and save the results to my local hard drive. The current way (which is the only way I know) I'm running queries is through an MS Visual Studio connection, which doesn't seem to do what I want it to do. (At least, there's no easy way to hand it a bunch of queries, and tell it to run each one and save the results.)
So, can anybody help?