Home Forums SQL Server 2008 SQL Server 2008 Administration Create DML trigger for single table in SQL 2008 and send email alert to group RE: Create DML trigger for single table in SQL 2008 and send email alert to group

  • April 15, 2013 at 10:44 am

    #1606545

    you are pretty consistently ignoring the possibility that values might be null.

    You've got to bulletproof your code to consider datatypes (converting int to varchar, for example), where the data might not exist at all in the INSERTED or DELETED tables, or where any of your column values are NULL.

    what happens when you replace your line with this?

    SET @body = 'New record '

    + ''''

    + ISNULL(@ConfigSetID_Ins,'[Missing ConfigSet]')

    + ISNULL(@Name ,'[Missing Name]')

    + ISNULL(@Version,'[Missing Version]')

    + ISNULL(@Timestamp,'[Missing Timestamp]')

    + ''''

    + ' has been added to '+'ConfigSet table in xxxxxx'

    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!