Actually, there is an audit trigger that updates a row_eff_date field whenever something is updated and it wasn't reflecting that 3000 rows had been updated.

But on a different note, I...

Thanks for the posts guys, I'll give this stuff a try.

thanks

e

Hi all, thanks for all the insight, much appreciated.

Quest what the problem was.  it was actually the order by clause at the end of the statement.  the optimiser actually physically...

I'll give that a try and see what happens.  Is it because the optimizer in SQL 2000 processes the Like operator different than it did in SQL 7.0?

Yeah, thats what I thought.  Thanks.

Thanks everyone, this is great info. 🙂

Thank you for your insight, much appreciated.

e...

Thank you for your insight, much appreciated.

e...

Thanks guys.  Much appreciated. 🙂

thanks a million!

Thanks for the insight, I will try this out. 🙂

That makes perfect sense thanks

...

Hi, thanks, yeah i didn't have any of those options set so it didn't roll back.  played around with it a bit and figured it out, thanks though.

Hey I haven't...