Here is a quick, easy way that I do it:

/* =================================================================================================================== */

/* Load SQL Error Logs to a temp table for research

Whole script at:

http://www.sqlservercentral.com/scripts/Error+Logging/70611/

*/

CREATE...

Here is what I use to find blocking:

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

In the past month, had two occasions to use it. Worked perfectly. Someone was running a report in the...

Just did this last week for our developer. Is a table-valued function that returns a table with the values split out. Hope this helps.

(probably not very scalable, but...

Then I would say third-party software is the answer.

If it helps, here is the URL to a script I wrote to do a "Instance Security Audit Documentation" script. It will print in normal report format, or you can...

If your goal is to protect the data from prying eyes, you could use column-level encryption instead of TDE (although CLE has its own set of advantages/disadvantages).

Unless they have the...

No idea if this will help, but if you are deleting tens of thousands of rows, you don't have a commit, so it might have some trouble with deleting that...

To Lowell's point, if you are wanting a "who dunnit", then would it be possible to put all updates, deletes, inserts and selects into SPROCs, and log who runs what...

Here is the companion Data Dictionary script that utilizes the CLMNDOC extended property, along with others, to create a decent picture of the database. It's not perfect, nor slick,...

Here is a script I wrote to create a script to set the column definitions for every column in every table. When filled in, just run the finished product...

Keep in mind that CDC is only in Enterprise Edition (SQL 2008), and it doesn't track who made the change, just the changes that were made.

If each user logs in...

Lynn:

I look forward to seeing that. I do light to medium design work, mostly administration. My databases that I write are only used by small departments. I...

If it helps, here are a couple of functions I created to do just that. First input is the full line of information to look at, and the second...

If it helps, here is the URL to a script I wrote to do a "Instance Security Audit Documentation" script. It will print in normal report format, or you...

Note that the script assumes that the structure of the table in the two databases hasn't changed.