Andy,

As the problem only relates to 2 SP's I'm thinking that the best route is to abandon SP's and build the SQL in the ASP code, thus the problem goes...

Andy,

I presume that you are the only one that looks after the db's then? I have a problem with developers or management transferring SP's from a Stage server to...

Thanks for the answer, at

I should have given you a bit more info.

What I want to do is join to another table in another database in my SP, but this...