Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to create a table trigger Expand / Collapse
Author
Message
Posted Thursday, December 6, 2012 9:00 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:30 PM
Points: 75, Visits: 350
Hi all,

I would need to create a table trigger on when a column is modified or row is added.
and send an email using database mail
Pardon my lack of programming

thx
Post #1393582
Posted Thursday, December 6, 2012 9:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:16 PM
Points: 477, Visits: 3,673
This is the first result from Google:
http://www.datasprings.com/resources/articles-information/creating-email-triggers-in-sql-server-2005

Seems to cover what you need.


______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
Post #1393597
Posted Thursday, December 6, 2012 9:27 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:30 PM
Points: 75, Visits: 350
damn google :)

thx a bunch
Post #1393605
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse