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, August 15, 2014 5:56 AM
Points: 75, Visits: 343
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: Monday, November 11, 2013 3:13 PM
Points: 477, Visits: 3,671
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, August 15, 2014 5:56 AM
Points: 75, Visits: 343
damn google :)

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

Add to briefcase

Permissions Expand / Collapse