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 8:01 am

    #1375492

    Jack Corbett (8/31/2011)

    Posted this on Twitter and got an interesting question. Are you seeing this happen with a specific application like Access?

    I get it for something called "Entity Framework", but I don't know much else about it. I would need to ask the devs about that.

    We don't use MS Access on that server.

    I also just saw a linked server query running on the server in question, linking to another server; login name was blank for that session as well.

    Unfortunately that's all I have at the moment.

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