I have at least one limitation on that. I have to run this as an ad-hoc query. Eventually, this will be a script run by C# codebehind from a webpage on an IIS6 server.

I could probably switch the login user in my SqlConnection to a windows authenticated login using the AD user with share rights, but that produces a few security risks I'd rather avoid.

I had read that credentials could provide access to files on other servers, even if the given login did not have access, as stated here http://www.jasonstrate.com/2013/07/security-questions-logins-credentials-and-proxies/[/url]. Do you know anything about credentials and their place in my query? I may have the wrong idea of how they work.