Sorry Adam, not Andrew!

I isolated the problem thread and it displays Ok with Adam's code.

<?query --

FETCH API_CURSOR000000000002BC4F

--?>

jason

I isolated the problem thread and it displays Ok with Andrew's code.

<?query --

FETCH API_CURSOR000000000002BC4F

--?>

Jason

And I complain to my users when they do not give me enuff info!!

SQl Level is 9.0.4273

Jason

Looks like you have done some good work.

However, I tried to run the stored procedure and got....

Msg 6841, Level 16, State 1, Procedure who4, Line 28

FOR XML could not serialize...

I am not quoting a Microdoft site, I am speaking from observation of a single Instance machine with 2 CPUs with a high load of queries for multiple databases that will only...

If you have one instance on a multi CPU server then you will only be using 1 CPU for the SQL instance (each instance has a single process). Whether this...