Copy your whole query, go to query analyzer -> view execution plan. This
will show you costs of each and every operation.

TK
  -----Original Message-----
  From: Eric Creese [mailto:[EMAIL PROTECTED]
  Sent: Thursday, February 26, 2004 11:49 AM
  To: CF-Talk
  Subject: OT - Datbase Transaction question

  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]

Reply via email to