On-Demand E-Mail Delivery

Hi,
Is there a way to deliver reports via email without any subscriptions?
Because, most of the time the reports users will send will only be sent once
and if i create a subscription for each of these i'll end up with hunders of
necessary subscriptions.
Any comments and ideas are welcome. Thanks in advance.
Best regards,
VolkanI solved the problem. In case someone faces a similar situation, i'll write
down my solution for future reference. It's not exactly how i wanted it to be
but at least it works.
01. Create a TimedSubscription and store its subscription ID. (Schedule
value doesn't matter, we'll delete it anyway after email is sent)
02. Call FireEvent method of the ReportingService class with EventData
parameter set to subscription ID.
03. Get subscription list and check if the event is triggered by checking
the LastExecuted property of the subscription object.
04. If the subscription is executed call DeleteSubscription
Maybe there's a better way out there but until i find it i'll stick with
this even tough it has some drawbacks.
Regards.

Old Subscriptions?

Hello, I have a server that lists several Subscriptions (under Replication ->
Subscriptions in Enterprise Manager) that are no longer in use. Two of them
reference a server that was decomissioned over a year ago which no longer
exists.
Why do these old subscriptions still show up in the Subscriptions list? Is
there a way to remove them? If so, how?
I would appreciate any feedback...
Thanks,
John
You can have a look at sp_MSenumsubscriptions to see what is happening when
you click on the subscriptions folder. The key tables in each subscribing
databases are sysmergesubscriptions and MSreplication_subscriptions. If this
database is no longer a subscriber, then run sp_removedbreplication, which
removes the redundant system tables. If you want these tables to remain,
then simply locate the redundant record in the above relevant system table
and delete it.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)