if I run a query like this on database A:
select * from databaseB.dbo.Table1
and if I run a trace with filter on database DatabaseB, and I select the StmtComplete event, then any hits to DatabaseB are not captured by trace.
How can I capture the hits on DatabaseB by keeping the same filter?
Online Trainer For SQL DBA and Developer @RedBushTechnologies
with 16 yrs exp.