"Creating a bigger test database will also work, but involves a lot more work, will cause your tests to run longer, and might require you to clean up your collection...

Utsab Chattopadhyay (8/22/2008)

---

We are trying to make a standard here which we may share among the organazation as a standard monitoring events. It should cover all the typical issues from...

There will always be someone somewhere with access to the data that could tamper with it to hide inappropriate/illegal activity. Remember, a locked door only keeps out the law-abiding...

Recording ALL DML operations would be like drinking from a fire hydrant. Throttle it down to only what you really need to monitor and then spend the money and...

Before answering that I need to know what you are trying to get out of monitoring. For example, are you trying to find slow running queries? Are you...

Another thing that may or may not be a factor in your decision is the amount of transactions that the servers will have to handle. With mirroring a transaction...

What is this "training" thing you speak of? I must have had a bad streak of companies. I'm almost entirely self-taught through books, work experience, and of course...

Yes, in the Profiler.

-- Check Show all columns

-- Check Security Audit > Audit Schema Object Access Event

-- Make sure TextData is checked.

-- Edit the Column Filters >...

As others have pointed out, reporting is a big reason. Where I'm currently at (I'm a contractor) they have several cases where one SQL Server instance handles transactions and...