I'm using SQL 2008 Standard and would like to periodically monitor a database for changes that meet specified criteria, is there a way to do this in SQL 2008 Standard? All I can find either uses Notification Services (depreciated in 2005) or Data Drive subscriptions which require enterprise edition. Thanks! Stephen

monitor database? you probably need a trigger job for that. And you probably be better of posting this question in SQL Server forum, rather than in reporting services.Once a gunners always a gunners

Hi sgrigg, Thanks for your post and i_hs rely. I suggest you to take use of the event notification object in SQL Server to cooperate with Server broker to archive your requirement, whenever the server detect the specified event happens, just take use of Database mail to send a mail to a specific User. More information relate to Event Notifications, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms182602(v=sql.100).aspx Thanks, Bill LuBill Lu TechNet Community Support

It went in Reporting Services due to the confusion over what Event Notification is (OP probably confused it with Notification Services, which is/was RS)