Thankyou for the feedback, I will look into these items... 🙂

forgot to copy across the XML config file.. derrrrrr! closed! 🙂

Thanks for the info, I will read up on SSIS

Regards

shanewiso

Apologies for not providing more information as to the execution plan...

I was able to resolve this issue by making use of temp tables..

The saleitem table which contains alot of data...

OK, success!!!

In order to make my service compatiable between SQL Server 2008 and 2005 and to stop the errors with Batch Parser and Connection version 10 of SMO is the...

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/f54b87e3-b12e-43f9-a776-ef1bccea5420

This link explains alot.. im in the process of trying to upgrade to SMO version 10 to overcome my issue on 2008.

Dont know if this is correct as I have installed SQL 2005 client tools on my work pc and when doing a search for the Microsoft.Sql.Server.BatchParser.dll. It does not exist....

thanks, yes that was it. Security of the user connection, I changed the account to dbo and it worked. Silly me...

thanks 🙂