title: How can I get the actual CURRENT_USER for a dbo in SQL 2005?
body: <p>I've got a stored procedure which runs this to create a new ticket number:</p>
  
  <pre><code> INSERT INTO [Test_DB42].[dbo].[TicketNumber]
    ([On], [By])
  </code></pre>
  
  <p>VALUES
      (CURRENT_TIMESTAMP, CURRENT_USER)</p>
  
  <p>When I run with a user with db_datareader and execute permissions, I get the Active Directory samAccountName value which is what I want - this user gets access via an AD group which has a Login.  </p>
  
  <p>When I run with a user with sysadmin role it just says 'dbo'.  This use has an explicit Login for their AD account.</p>
  
  <p>Is there anyway to change this, or to return the AD samAccountName or SQL Login name?</p>