at 28 update statements. Do you have indexes on the primary keys?
Steve Nelson
Eric Creese wrote:
> 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]
