Sending UserName info | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sending UserName info

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
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