OT - Datbase Transaction question

[Eric Creese]

I have a stored procedure which runs a series of updates, actually 28 seperate update statements. If no failures I then do a single commit. if error roll back all updates. Kind of an all or nothig deal. Where will the biggest performance hit take place?

SQLServer 2000

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---