after you load, did you run

use yourdb

go

dbcc updateusage(0) with count_rows

go

sp_updatestats

go

Even if you have autostats on, this is needed once in a while, espacialy after full loads or heavy delete/insert...

just my 2ct.

- Also in desaster cases, first make a copy of what you (still) have !

- What made you (all drp-actors) decide...

... The indexes and calculation procedures have not changed much  ....

Did you change clustering indexes ?

   they influence the actual storage order of rows at the datalevel

   and...

don't forget to download the awe-fix !

sql2k sp4 awe fix

- With sqlserver, you can revoke builtin\administators from the logins of your server. Be carefull with that, because it will need your services to use a windows-account ! Make sure...

The issue occurs when I plug one of the servers to another vlan. I'll check on the impact of the gateways.

thank you all for your replies.

MSDTC is working fine when in the same domain.

Now I'm focussing on the VLANs to check if there are port issues. (I'm not a network...

- So, suppose you can intercept these runaways, what's going to be your criteria to kill a thread ?

- As always, performance is of _no_ concern, utill the server's light...

my 2 ct

you could also have your programmers use the commandtimeout property for a ado-command !

Don't let them use commandtimeout = 0 !  (endless) but have it limmited to an...

how about renaming the "old" log-file and then performing the sp_detach_db ?

Maybe this can help :

http://www.sqlservercentral.com/scripts/contributions/622.asp

Begin tran

select col1 from mytable (tablock)

-- et voila, it's locked

this thread can do anything with the table, others cannot !

commit tran -- ...

If it's only you who'll be doing the sql-stuff, and you want quick formatting, there is always this "office"-thing.

Query sqlserver using e.g. excel and you'll have all the fancy formatting-stuff...

syntax-wize you miss a couple of end-(case) statements ??

long shot but ...

you could advise to set up e.g. ca unicenter , netiq DiagnosticManager, Veritas indepth, ... to capture all the needed data and have your "outside-monitoring-staff" only work...