SoHelpMeCodd (9/22/2015)
The following will fail for databases within which your account is not a db_datareader. ...
That's normal. You cannot query a database if you do not have sufficient rights.
Use an account that has the required rights.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]