Thank you a lot Mike, Lowell.

Will try out the temporary table concept and update.

Richerds, sorry to disappoint, not from mit.

Regards

Thanks.....

Sorry, I am a bit late in replying, Christmas leave...:)

Will try and update.

Regards,

Thanks all for your time and advice. Apology, I am a bit late in getting back. Was out for a few days. Unfortunately the datatey is varchar in both the...

Sorry, I am bit late with update, sa suggested, no issues with the database, the problem was with the box itself. It's completes in a flicker now.

Regards,

Thank you for your continuous help and guidance. Problem was in the poorly written code, too many cursors. The same has been optimized and the job now comletes in a...

Thank you so much.

Regards,

Thanks for your response. The job did finish successfully.

Barry, could you please be a little elaborate about parameter sniffing. I've heard about it but do not have a clear idea.

Regards,

Thanks,

I guess you might be correct. Unfortunately both the database and backup are on the same box, and more to that it is a straigt forward desktop, thus possibility is...

Thanks for the suggestion.........this one sounds pretty good.

Regards

Thanks for responding...... our production (SQL) Sever (with no ORACLE Client installed) is maintained by another party, and sadly they are not in favour of disturb the current installations.....

Might be...

Thank you so much Smith, I doubt if the statistics are updated. We wil try this option and get back.

Thanks for your suggestion Michael,

For the current issue, I have checked both the servers, @@language yields 'us-english' in both.

Any thoughts please ?

Thanks a lot. Will try and update.

Thanks for the response....The best part was the las few lines. The issue is solved anyway. The 'guest' user in the tempdb did disappear, the production dbas re-instated the same...

Thanks Gail,Sergiy

I believe that's the better way to explore.