You might have a hardware problem somewhere. I've seen this error with those. I'd contact the vendor for the storage system and let them know you're getting this error.

database role, backupadmin.

How is a DBA not allowed access to the rest of the server?

Thanks for the update.

The trigger is guarenteed to fire for each insert, once. It does not fire for each row.

you need to use the inserted and deleted tables to access the rows that...

I don't see an attempt at a CTE here. please show some work.

Speaking of high security. I worked in a nuclear plant like that. I was friends with the head of security and since I was often going in and out of...

OK, points awarded back.

The question has also been changed to specify the cursor fitting in memory. Apologies for the delay. We had hay delivered yesterday (160 bales) and it started...

I think it's a tendency that Brad is mentioning. There are plenty of people that start to get arrogant at a point when they have a lot of knowledge.

You can do this with DDL triggers on 2005. Not sure you can do this in 2000 without running a trace continuously.

You can't do this, because the drivers for OLEDB/ODBC will use the logged on credentials.

Most OS's now allow a "switch user", which logs in a 2nd person.

I'd rebuild all indexes, which will update statistics and ensure things are OK, including removing fragmentation. I might double check the fill factors, checking if I need less or more...

Look up processor affinity.

The plans are stored in msdb. If you back that up, you're OK. I think sysmaintplans has the binary if you need to grab that.

Do not run this as a single delete. If you do, it's one commit, and it's one transaction, and it's still logged in the transaction log. You want to delete...

RAID is redundant array of independent disks. If you don't understand RAID, I'm not sure you're the person to provide hardware requirements. You might want to let them know that...