Thanks so much guys..

This is really good advice and so far it has helped me!

Thanks guys!

This helps a lot.

The table still contains thousands of records, but I just wanted to know if part of those records could have been deleted. From what you've said, its an all...

Hmmm. I didnt know you could do that type of thing with Query Analyzer. What version of Query Analyzer do you have, becasue I would like to get...

I thought I would just add some input from a funny problem I ran into. I accidently updated several columns as:

UPDATE tblItem

SET ItemStatus = 'NULL'

instead of

UPDATE tblItem

SET ItemStatus...

The stored proc is about 400 lines and it is not too complex. There are several SELECTS and some logic done in there. The sp never changes the...

The Update trigger should get fired off 1000 times if I update 1000 rows at the same time.

In each instance of the trigger, it executes the stored proc for a...

Hi Chris,

We do the updates all at once. For example UPDATE tblItem

SET ItemStatus = 'Complete'

WHERE ItemID IN (

'4322342',

'3453433',

.

.

.

)

The trigger checks to see if the items meet a few criteria...