background: multiple databases on the same server, with the same stored procedures.
Problem: DPA is reporting incorrect SQL text in regards to the procedure being executed. The DPA information is in the context of clientDB1, but the SQL text is showing "Procedure: clientDB2.dbo.procedureName". I've run traces to verify that there is no cross-database execution occuring. Is this expected behavior? Can anyone explain what's going on?
thanks.
Dan