Home Forums SQL Server 2008 SQL Server Newbies How have Trigger's example after insert send to mail on outlook?. RE: How have Trigger's example after insert send to mail on outlook?.

  • February 1, 2013 at 2:11 pm

    #1583594

    Craig I think that was true with SQL2000, and the old SQL Mail, but the 2005 and above database mail via msdb.dbo.sp_send_dbmail is already an asynchronous service broker item, so it's safe for use in a trigger, as long as the profile and account have been set up.

    I took the OP to mean "mail" or "SMTP Mail" when he said "Outlook", instead of Outlook Profile that was the setup requirement for the old SQL 2000 stuff

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!