title: Sql Server 2005 connection log
body: <p>I have multiple databases on one SQL Server 2005 server. I would like to know a way using which I can see all the connections made to a particular database today and the activities performed.</p>
  
  <p>Thanks in advance</p>
  
  <p>Joe</p>