Thats great. Many thanks Gail and Tommy

Thanks Greg.  Good idea re. creating an extra step.

I've managed to get it to work in a package by creating 2 success workflows out of the "file exist" step and then...

thank you

Hi Strommy,

Thanks for the help.  It seems the the SQL Server is running under the local system account which can't seen nw resources.  So hopefully just changing this will resolve...

Many Thanks for the replies chaps.  We have now set the size of tempdb to 2GB and will continue to monitor the situation.

One last question though, when SQL Server is...

Have you tried "sp_dropsubscription" - check out the parameters in bol.

Try master.dbo.xp_smtp_sendmail. 

XPSMTP provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as an Extended Stored Procedure.

It does not require any...

This usually means that you have an update trigger on the table which is not designed to handle multirow updates.

It might be worth noting that recursion is limited to 32 for executing recursive functions in SQL Server.  This isn't a lot if your dealing with a complex

Check to see that  SELECT SERVERPROPERTY('Servername') and @@Servername return the same instance name.  If they don't then drop the server and re add it as above.

Thanks chaps, understood..