Results 1 to 1 of 1
- 04-04-2008, 11:09 AM #1
Member
- Join Date
- Mar 2008
- Posts
- 13
- Rep Power
- 0
sending the message from trigger to mailid
here my query is
CREATE TRIGGER NewCustomer1 ON CustomerInfo2
FOR INSERT
AS
DECLARE @custid varchar(5)
SELECT @custID = Customer_id FROM inserted
EXEC master..xp_startmail
EXEC master..xp_sendmail
@recipients =
'honey_rg16@yahoo.co.in', @subject = @custid,
@message = 'A new customer has been added.'
EXEC master..xp_stopmail
what i want is i want send any message to the mailid
for that i wrote the trigger like that
but waht is my problem is the message is not going to concerned mailid
after excuting the trigger i checked that mail
but no message i received
where did i mistake
plz help me in query
Similar Threads
-
Sending text to printer
By Java Tip in forum Java TipReplies: 1Last Post: 05-25-2009, 06:14 AM -
Sending out UDP pockets
By Java Tip in forum java.netReplies: 0Last Post: 04-07-2008, 08:07 PM -
Sending output to a Frame
By Java Tip in forum Java TipReplies: 0Last Post: 02-04-2008, 09:28 AM -
Timer which should never end and should trigger daily
By garinapavan in forum New To JavaReplies: 0Last Post: 08-10-2007, 05:23 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks