• My first question ... why are you using OPENROWSET to query a database on the local server? Even if you're hitting a remote server, the function is really designed for ad hoc queries. Otherwise it is better to use linked servers.

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]