Jack Corbett (10/21/2014)
Jeff Moden (10/21/2014)
SQLRNNR (10/17/2014)
You can try data driven subscriptions.Here is something to look at for that.
http://msdn.microsoft.com/en-us/library/ms159150(v=sql.90).aspx
+1000
If you have enterprise edition.
Ah... yeah... Don't you just love the split of functionality they provided us with?
The RAISERROR hack would definitely be a way around that. Thanks for the reminder.
--Jeff Moden
Change is inevitable... Change for the better is not.