Hi Samar,

How do you remove the credentials from a query? I searched for an answer on the web, but found nothing. In the stored procedure properties, I added the abdc\dianal user and gave it full permissions including "take ownership", but it still failed.

I will look into my settings to see why the prompt comes up, but at least the query works on the production server if I enter the paramaters into the prompt.

Thanks for your help,

Diana