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/


Go to Top of Page
   

- Advertisement -