Same server, two different databases, I am able to call and see the stored procedure on one database and not the other while creating dataset on the report builder. does anyone know what might be the reason.
Check what rights you have for each of the databases.
Alvin Ramard Memphis PASS Chapter[/url]
All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
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]