Yes that seems to be whats happened. Thanks

Thanks - that makes sense, I'll ask the question.

All my test email, which where never received are in sysmail_allitems marked as sent_status sent._

No it show no records, or non from the last few months anyway, none to my test email attempts (tried it locally on another test instance, shows records)?

Is it somehow...

No the only thing ever in that table is process starting and the process shutting down?

Well the answer was

SMTP relay was changed , so I just changed the server in the account configuration.

Am I missing something - why didn't that error show up , rather...

Thanks - I'll investigate as advised and post back.

Just email for the time being.

The roles I assigned to the users in the two dbs seemsed to be the only obvious ones to get the subscription working. Does what...

Thanks - yes should have said I have done that. Was wondering if my login/users were set up correctly. What I have found doesn't seem to say what permissions on...

Thanks for your replies!

Yes, either that or case by case basis maybe nvarchar(x)

Thanks - I would need the configuration manager to get the web address for this wouldn't I.

Would BIDS be the way to go ? If they have installed the reporting...

I'm just playing round with this - will probably adopt a db based solution, but pasting the code in , as is -

I get an error

"Function doesn't return a value...

Wont that just email the data from textboxes on the report - rather than a fuller underlying dataset?

I have had the suggestion that maybe I should create the 2005 server as a linked server? Is this the solution to my problem. Would I still use DTS and/or...