Hi Samar,

I was running the query on my local server and getting the error, so I tried it on my remote server and it worked perfectly.

The remote production server database owner is "sa". I log into the remote server with the SA credentials.

My local test server database owner is "abdc\dianal", and I use Windows Authentication to log in as abdc\dianal.

The owner of the stored procedure on both servers is "dbo". Since the query worked on the remote server, should I change ownership of all the databases on my local server to "sa"? I'm not sure how the ownership was setup as "abdc\dianal" in the first place.

Also, there is another question I have. Every time I execute the procedure on either server, it opens a dialog box that asks for the variable information again, so it must not be reading it from the query. The dialog box lists the parameter name, data type, output parameter (for each line it says "No"), pass null value (checkbox is always unchecked), and value. I enter the values into the dialog box and click OK, then the query continues. Is that supposed to happen?

Diana