Mr. Magoo,

You seem to have PERFECT eyesight to me!!! You're guess was absolutely correct. I am embarrassed that it was this easy.

Thank you, Sir!!

I had not tried your second option and had not even heard of the third. Google fixed that.

It's going to be some time before I can pursue this. ...

No, I still have the problem.

Thanks

Thank you for your reply.

The target database was the only user database on the server. The system databases were not excluded from the trace. However, I...

Thank you. I appreciate your time and effort. I am close to a solution now in SQL and will attempt to recreate it in WMI as suggested.

I appreciate your time and effort!!! This is what I needed. I was closer that I thought, but I just couldn't get there.

Again, Thank You.

oops....

never mind. I didn't notice the additional pages of comments. my db was set to compatibility level 8.0.

Sorry for the repeated (and already answered) question.

The CROSS APPLY line below returns this error

Msg 102, Level 15, State 1, Line 43

Incorrect syntax near '.'.

This is true for the original code from the article and the formatted...

Thank you for your reply. Yes, everyone who attempts to view the Activity Monitor on that server receives the same error.

Is replacing the dll just a matter...

I am a late IT bloomer.  My degree is in accounting.  Audits are necessary, auditing auditors is not.  While I will never rise to the level of knowledge regarding IT...

This is more of a question for my own understanding, but is sjones a local admin on the server where this test was run?  If so, wouldn't the temp table...