If I'm not mistaken, here are some notes on the built-in auditing capabilities:

FeatureEnterprise Edition Notes

====================================================================

SQL Server Audit ...

I would bet that if you are doing the aggregate part, it is essentially the same. Change the SUM(something) or whatever it is to ISNULL(SUM(something),0) or something similar and...

I got this error just yesterday.

For me, it occured when I used a statement like the following:

SET @value = (SELECT somevalue FROM sometable WHERE somethingistrue) ...

See the below url for an Instance Security Audit script (has for 2005 and above, and another for SQL 2000) that I wrote. Shows the roles and individual object...

Alright. Here is a SQL 2000 version of the Instance Security Audit Documentation script. Just finished it, so if you find any errors or issues, let me know....

No, I don't have a version for SQL 2000 at this point. I'll see what I can do.

Here is a link to an excellent script to find sessions that are blocking others. Has come in handy several times for me.

http://www.sqlservercentral.com/scripts/Head+Blocker/75366/

One time, a user started...

This website has links to all the manuals on the IBM site for the respective versions.

http://www.raulgonzalez.com/db2_manuals.htm

http://www.databasejournal.com

This is a good website, for SQL Server, Oracle, DB2, etc....

Exactly. I agree.

One problem here seems to be differentiating between users/hackers and inside staff and the security measures taken to protect the data from each. Personally, I am of...

I mentioned Profiler because the OP stated that his boss didn't want the SQL Admins to have access to the data. If the SA has access to Profiler, he...

Darn, I think I misread your post. It's Friday. Brain not functioning. Oh well....

The following is a SQLCMD command that would be used in a .bat file to run the given query(-Q) and send the output to the filename given (after the -o)....

I have the same problem with Oracle data. The way I deal with it is to pull the data into staging tables, and the columns are all string data...

Elliot, very interesting. I hadn't thought to use a two-part key. Even though one part is passed over the network to the database, it is only part of...

Also, make sure the disk directories that hold the backups (on the database server where the backups are taken) are secured, and no one else has access to them that...