I think it's the same one released under two different code paths. QFE is a quick fix, usually for one customer. The equivalent is a GDR, general release.

First security fix...

If we want to consider the sky is falling, then the #1 skill for a junior DBA is to know you're in over your head and call me or MS...

Brad Magahee, SQL Server MVP, the guy in the ads up top.

He wrote an article for Simple-Talk (has done a couple editorials here as well) that we linked to.

There should be a management tools section, which is where SSMS would be.

Is that not visible?

Certain data is in sysprocesses, and the user "mike" could only be in certain columns, not any column.

So your question doesn't make sense.

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.