Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Red face Unanswered: problem with trigger and identity insert

    here is the scenario which i am facing in my company
    MSAccess application is doing insert on a table(say A) and then performing update on same record based on @@identity
    problem is a trigger is also defined on that table(A) its an after trigger for inserts and updates
    which fires and inserts this record into a different table(say B) in different database and this table(B) also has identity column ....

    Problem is

    when access application first inserts the record into table ""A"
    trigger fires and inserts record into table"B" and value of @@identity gets changed....so access application is updating records based on wrong @@identity value....this issue poped up from nowhere...it was working fine in past idk what to do ..
    Environment
    MSAccess 2007
    SQLServer 2008

  2. #2
    Join Date
    Aug 2009
    Posts
    73

    i came across this link too idk whats gng on with microsoft


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •