Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Field change notification by email?

Author  Topic  wizzz Starting Member 1 Post Posted - 2009-09-19 : 17:18:59 Hello, I have done work with SQL Server and MySQL before, build several DB etc... but I am working on a project where I just have no clue how to proceed, and what I'd need. This project uses SQL Server. I want to be able to notify users of changes of critical data, using a mailing list. let's say I have a mailing list manager running, with mailing lists which users can subscribe to if they need to. I want to be able to send an email to that mailing list whenever some critical data is changed, for example for a 'Sales order' type system, I want to notify parties involved if the 'Ship Date' was changed. Each Order would be associated a mailing list, and on change of the 'Ship Date' I would email the associated mailing list. or maybe I'm just fooling myself and there are easier tools to do this. I read about SQL Server Reporting Services, but I'm not sure what i can do with that. I'd appreciate someone pointing me in the right direction. Best regards