Home Forums SQL Server 2005 Administering Audit script RE: Audit script

  • May 11, 2009 at 9:04 am

    #992191

    using COLUMNS_UPDATED, you can't, i guess you'd have to write your trigger to do each column individually, if that's what you wanted to do:

    IF (UPDATE(DESCRIP) )

    BEGIN

    [same code example]

    END

    IF (UPDATE(COLUMN2) )

    BEGIN

    [same code example, just change the column names]

    END

    IF (UPDATE(COLUMN3) )

    BEGIN

    [same code example, just change the column names]

    END

    IF (UPDATE(COLUMN4) )

    BEGIN

    [same code example, just change the column names]

    END

    i would think it is easier to simply capture all the changes,and compare on demand for specific queiitons.

    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!