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:23 am

    #1375509

    Jack Corbett (8/31/2011)

    Marios Philippopoulos (8/31/2011)

    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.

    Okay, Entity Framework is MS's latest and greatest data access tool or ORM tool. I haven't worked much with Entity Framework applications so I haven't seen it. If I have a chance I'll do a quick EF app and see what happens.

    Great, I hadn't realized it was something so widely known and used.

    I will certainly keep an eye out for it.

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