Quote Originally Posted by Minty View Post
You don't need direct access to the server, just an ability to connect to it?
You can run SSMS from your local pc as long as you can connect to the SQL server.

There's no point running the query on an Admins login, if they can't run it nobody could
I was able to run them. Not sure what was going on but I couldn't get the WTrst.edit to work but instead I was able to run them normally by setting the querydef.ODBCTimeout = 1.

Thanks for all the help!