Hello,

Thank-you for the response.

The report looks fine via the web interface.

If I delete the subscription, recreate it and run the sproc it succeeds.

And the only differences I can find in the Subscriptions table, between test runs, is the last status

TestPoint LastStatus LastRunTime

----------------- ------------------------------ -----------------------

1: Before 1st Run New Subscription NULL

2: After Email Mail sent to helen.thorley 2008-05-13 14:56:49.380

3. After 2nd Run Root element is missing. 2008-05-13 14:57:29.863

I compared Subscriptions by saving it's contents at each of the test points above.

ARRGH!

Helen