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

That doesn't make sense. The data returned should be less if you select individual columns.

How are you selecting? Are you sure that your SELECT * from MyTable doesn't have some...

One thing to think about is that if something has changed and your DTS package needs input, like responding to an error in Access or something, then the package freezes....

It is a presumption that everyone here knows these basics. New people come to the site every day, and to SQL Server for that matter. We want to serve all...