SQL Server Performance

Sending UserName info

Discussion in 'SQL Server Reporting Services' started by jastone, Mar 9, 2007.

  1. jastone New Member

    I want to send the stored procedure on the back-end of a report the NT UserName, is there functionality in this version and/or 2005 to do this? I was planning on collecting it and throwing it to the stored procedure as a parameter.

    Reporting Services 2000
    Reporting Services 2005

    Joe Janka
  2. jezemine New Member

    sql server has no way of knowing what NT user is behind the login unless you are using windows auth.

    if you want to pass it, you could use something like System.Environment.UserName in .net


Share This Page