Steve

Tried replying to your mail on polo shirt, using email that you indicated, got user does not exist error. Is there another address I can use?

Not as much as most, probably.

The desktop machine has a 160GB and a 20GB. There's a badly damaged 200GB in there which I need to throw away.

The laptop has...

Pretty much, though you'll have to check and make sure you get the same results.

Can you post parts of the stack dump? The input buffer for spid 85, the short stach dump

Few questions...

You said the dump is triggered by a select. Are any of...

No. It has to not exist. 

SELECT INTO creates the table and inserts the results of the select into it.

To insert results into an existing table, you'd use INSERT INTO <table>...

Subselects in the select clause are extremely inefficient. Move them out into joins and it'll be a lot better.

Possible, but not with that syntax. Did you check books online?

The syntax you're looking for is

SELECT * INTO New_Addresses FROM Addresses

What's in the SQL errorlog just before it shuts down?

I'm sure the bard is rolling in his grave right about now.

Hmm. Very wierd

Try rebuilding the clustered index - DBCC DBREINDEX ('Actions') - and then do an update usage. See if that has any effect.

If not, then I'm really stumped.

From...

Hmmm. Wierd....

Can you run the following and post the output please

DBCC SHOWCONTIG('<table name>')

Is it possible to change the reserved size?

Not directly. Afaik, it's a measure of how many pages/extents are allocated to the table. Not something you can change manually.

Is there a...

With a set-based insert, the entire insert will succeed, or will fail. It's not possible to insert the rows that are OK and ditch the others.

If this is a common...

Have you tried rebuilding the indexes on that table since the delete? (specifically the clustered index)

Congrats on the 400k, and thanks very much.