Home Forums SQL Server 2008 T-SQL (SS2K8) Performing a ALTER TABLE then modifying data in same transaction scope? RE: Performing a ALTER TABLE then modifying data in same transaction scope?

  • Have you checked to make sure there are no triggers being fired by the updates, or anything like that?

    I'd have to see the table definition (create script) before I could suggest anything more detailed.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon