run the procedure manually. Check howmuch time it takes (It may timeout)
Check remote query timeout setting
sp_configure 'remote query timeout'
default is 600 , ie 10 mins
change it to appropriate value
dont forget to tune the SP
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]