Local disconnected and outdated data sets, locking, etc.

Phmorris , just for curiosity sake, how many processors and MHz, SAN, memory, disks, controllers, channel speeds, etc.?

See BOL 2000:

SET IDENTITY_INSERT

Allows explicit values to be inserted into the identity column of a table.

Have a look at scptxfr.exe supplied by MS.

Maybe usefull with 'xp_cmdshell'

I'll go with the BCP suggestion of DavidBurrows.

See http://dbforums.com/t757720.html

Maybe relevant to the problem!

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q240/8/53.asp&NoWebContent=1

Maybe relevant to the problem!

Any transactions involved?

What is the TRANSACTION ISOLATION LEVEL setting?

DavidBurrows, to split hairs it may be safer to subtract 3 milliseconds, depending on the provider of the data. Run into such a funny during development, recently. Otherwise I am...

DavidBurrows, which email system do you use mapi, CDONTS, SQL Server, etc. ?

Any suggestions

Suppose you can remove layout spaces, carriage returns, etc. from the code and get it to recompile.

Rather go for McCork suggestion of functional breakouts(sub procs).

Not sure why you want to keep on pressing F5, but the following code will also goes into an endless loop. Hopefully it will not hang Query Analyzer.

While 1>0

...

Have a look at http://www.sqldts.com/

When the trigger fires look at the inserted table.

Update Table

Set Colx=Colx*2

From Inserted

Where table.pk=inserted.pk

May also...