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

    #1375504

    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.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question