Home Forums SQL Server 2008 SQL Server 2008 - General login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2 RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

  • August 31, 2011 at 3:06 pm

    #1375730

    I just did a quick check.

    There is a session running EntityFramework, and the original_login_name is populated (not NULL); login_name is blank.

    I noticed that there are 3 threads for that session: 3 records returned. Why would that be?

    I am able to get most other information for that session, such as SQL running, query plan etc.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]