i think the problem with primary key is a composite key and not used in filtering

hmm .... have you checked SQL server agent's properties on Job System Tab ?? there might be some wierd values there.

If i understood correctly, then

I think you would have to create linked servers from the main server on which you would be querying the report.

good show steve.

Doing a Ctrl C + Ctrl V on somebody's elses work is totally uncalled for. This site is a place where you discuss your own experiences and...