Like Jason said, a login trigger can be implemented to track login events to a log table. You can also use event notifications to do something similar, if you...

I agree. Very well done.

I guess I'm not entirely clear as to exactly what events and data you want to capture. Are you looking for what rows were affected by the DML?

You can find it in the service_broker_guid of sys.databases.

Did you modify the stored procedure to filter on your database name?

IFISNULL((@message.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'VARCHAR(100)')), 'NULL') = 'AdventureWorks'

Also, did you modify the Event Notification definition with the Service Broker GUID of your...

Linchi Shea did some great analysis on this very question.

The performance impact of SQL 2008 R2 Audit and SQL Trace

He also did a 3-part series on the perils of using...

The example below will create a basic DML audit. The only downside of tracking DML using Event Notifications is that the AUDIT_SCHEMA_OBJECT_ACCESS_EVENT group can only be used at the...

The AUDIT_SCHEMA_OBJECT_ACCESS_EVENT group can be used to audit DML statements. Including failed events (i.e. permission denied).

You can also use event notifications and Service Broker to audit DDL and DML events in Standard Edition. They run asynchronously, so you don't have the potential direct impact...

I've edited my original response. With regards to filtering where st.dbid or qp.dbid is not null, there's still the same problem of the TVF being evaluated first.

But this actually...

A high percentage of PAGEIOLATCH_SH waits can sometimes be caused by insufficient memory to handle the workload or by poorly designed queries/indexes. Look at page life expectancy and target/total...

I see the begin transaction, but you seem to be missing the commit/rollback statements. Put the begin/commit transaction statements inside the TRY block. Your CATCH block should test...

The problem is that one of those queries involves that offline database. I would imagine that, on the servers where this query worked, none of the top 10 longest...

Do you have any explicit login mappings on this linked server?

Have you tried an explicit mapping for LI_LOGIN to LI_LOGIN?

I'm able to recreate the problem you're experiencing by adding a...

I don't think there's any way to create a menu like for the standard reports. From the BOL it sounded to me like you just use the directories.