Sounds like your watchdog process is the problem then.

I notice that your orders table doesn't have a clustered index. Adding one may help out, especially with the reads, if it's...

Why do you want to store the code and the code ID in the billing detail table? It's poor table design. (Unless this is some form of data warehouse and...

You'll have to keep a watch on sp_lock, see if you get table locks. However in general, if you have a lot of inserts and updates to a table, then...

but u know there is an @@error global function in sql

@@Error just returns the error statement of the previous command in a TSQL batch. If the previous command executed without...

Are they very big tables?

With auto update stats, the stats get updated after a certain percentage of the table changed. With larger tables, it takes more changes to trigger the...

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...