You can always add the DBA accounts to DenyDataReader/DenydataWriter groups and that would give you access denied errors, but then the DBA could simply remove themselves from that group.

Search BOL for the phrase "Mapping System Tables to System Views". There's a whole chart there.

Just in case, you probably already checked this, but verify that the Agent service account has permissions to the same stuff that you do. It's possible that permissions are...

Ah, I see what you meant now. I just saw the sample code and thought you were telling him to cap it literally to 4 GB.

Still, though, while I...

Take a 16 GB SQL Server and limit it to 4 GB for SQL to use? Even giving 2 GB to the OS (seems a bit high to me),...

Could be because the user was added to the group a few minutes before. If your group membership changes after you log in, your token doesn't automatically update, and...

Some do, some don't. It's the same old thing -- people all say that you need a DBA but no one accepts what a DBA says because they don't...

Another thing you might do is restore a prior backup someplace and find a SQL compare type tool to at least see what was changed in the procs. Red...

Your only real option at that point once the damage is done and you have no trail is to get a log reader and see if that can find the...

Dirty data could include:

text files that put alphanumeric data into a column that would import to a numeric destination.

typos in the years (i.e. 2009 becomes 3009 by mistake)....

Seems like there are a lot of communication and education issues between DBAs and the SAN guys. Here our problem with the SAN guys is that they hear us...

If 7986011679 is an account number, then I think this may be your problem. Your input query is going end up being

SELECT * FROM Dev_Adhoc.dbo.Bank_Data_Source where ACCT_NBR=7986011679

and without apostrophes...

2005 Activity Monitor gave you that data. 2008 Activity Monitor does not. The new Activity Monitor in many ways is much worse than its predecessor.

SQL Server Agent is not available in SQL Server Express.

You didn't mention log backup verification, but that is a concern as well. I actually find that log shipping, in addition to being a healthy in place DR method,...