Track Updates - SQL Server Forums

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

New to SQL Server Programming

Track Updates

Author

Topic

zeeshandar
Starting Member

3 Posts

Posted - 2012-03-05 : 23:30:11

Hi,

Thanks for your time.
I only have basic info about Sql Server database handling. What I need to do is:

I have a table containing stock quantity. What I need to do is whenever quantity changes in Stock field, database send an email to me.

Please advice.

Thanks!
Zeeshan

---------------------------
Pixel Managers
Connecting clients via text messaging

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-06 : 09:55:59

Why?

Do you really want thousands of emails a day?

Why not just create a history table, create a trigger save the before image, create a view between current and history and run a report whenever you want to see the changes?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources