title: SQL Server : Trace Database activity or logins on fully qualified table query
body: <p>I am trying to audit our security for our SQL Servers. I am trying to run a trace on a database to get the users that logon and access the database. However if the query is ran from a different database there are no logon events generated.</p>
  
  <p>Example: I am trying to trace logons for <code>[Database2]</code></p>
  
  <pre><code>Use [Database1];
  Go
  
  SELECT * FROM [Database2].[dbo].[Table]
  </code></pre>
  
  <p>But there are no events logged in the trace under <code>Database2</code>.</p>
  
  <p>Our environment is SQL Server 2008 R2 Standard Edition. Any suggestions would be appreciated.</p>