Post reply

Is it Possible to get a session values in sql server?

  • June 7, 2011 at 10:17 pm

    #237526

    Is it Possible to get a session values in sql server? which is holding in asp.net?

    If its wrong questions please ignore...

  • June 7, 2011 at 10:40 pm

    #1335436

    Im not sure where do you want to use session values from the .net code... you want to pass it to some procedure or to a query?

    [font="Times New Roman"]For better assistance in answering your questions
    Click Here[/url][/font]

  • June 7, 2011 at 11:02 pm

    #1335439

    Developer using seesion in Asp.net for fetching the user_id and client Net address , That value can we take from SQL server?

  • June 7, 2011 at 11:04 pm

    #1335440

    I do not think it is possible the session id generated by ASP.NET can be fetched from sQL server until you store the sessionid in a table and query.

  • June 7, 2011 at 11:07 pm

    #1335441

    Thanks for your Quick response...

  • June 7, 2011 at 11:49 pm

    #1335454

    Session ID as in the session process identifier on SQL Server? The one that you see in sys.dm_exec_requests and similar DMVs?

    If so, you can return a session's SPID - SELECT @@SPID

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply