Finding currently logged in user with T-SQL

by Joe Hunter 18. February 2010 17:52

select suser_sname()

Get list if users currently logged into SQL Serverset nocount oncreate table #sp_who ( spid ...T-SQL: SUSER_IDFound this function very useful today for uniquely naming tempDB tables based on users login: SELEC...Finding creation date of SQL Server user accountsUse the DATABASE_PRINCIPALS view (http://msdn.microsoft.com/en-us/library/ms187328.aspx) for this: ...