Thanks Phill. Compaq tool was useful, seems like Dell also has a similar tool for sizing. Just out of curiosity, how do they do this sizing ?

Thanks a lot. It works fine.

quote:

---

You might love this, but after I tested it works you might want to try this instead.

DECLARE...

I change the insert to

insert into #TempBatchTable

select Top 1 *

from BatchTable

with (updlock)

where inuseflag = 'N'

now it seems to have a slight performance hit, but it works as...