Post reply

After Trigger

  • February 17, 2008 at 11:29 pm

    #69599

    I read the contents of one particular column of the inserted table, but it is mysteriously not there. I get zero (datatype is money, Null). Immediately after the trigger fires, I SELECT from the table and the column has been inserted correctly. I'm doing similar things with other columns, and all is well there.

    I've tried adding some logging into a log table to verify my observations (INSERT INTO LogTable SELECT MissingCol, GetDate() FROM inserted). I've done extensive work with triggers for years, and I'm pretty sure I'm doing all the normal things correctly.

    There's really no other code to show. I'm thinking this is a SQL bug of some sort but I haven't found it yet on the MS site. Has anyone encountered such an anomaly?

    Thanks

    Paul

    - Paul

    http://paulpaivasql.blogspot.com/

  • February 17, 2008 at 11:53 pm

    #779242

    Haven't heard of this happening before.

    Can you post the trigger code, the table schema and the insert statement that you tried?

    What's the version of your SQL server? What SP?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply