title: SQL Server Profiler - how do I find which database is being connected?
body: <p>I've Googled this with no success.  I'm using SQL Server Profiler for SQL Server 2008 R2, and I've ensured that for the 'Events Selection' of the trace:</p>
  <ul>
  <li>I'm reporting all columns for Security Audit &gt; Audit Login + Audit Logout</li>
  <li>I'm reporting all columns for Sessions &gt; ExistingConnection</li>
  </ul>
  <p>I then start the trace after I've loaded an .aspx page, but just before I carry out an action that calls a certain SQL stored procedure.</p>
  <p>I can then see at the start of my trace that under the 'EventClass' column I have 'ExistingConnection', however the 'TextData' for these events doesn't seem to identify the database I'm connecting to - it's telling me the main database settings (e.g. set ansi_padding on).  I can also see that for certain events I can see the 'NTUserName', which gives me some clues.  What I want to find though is which database am I connecting to.  How can I determine this?</p>