Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227

    Unanswered: scope_identity and sessions

    I found in bol that I can use scope_identity to get the last identity in a specific session and for a the current scope. Now what I would like to know is what is a session? We usually create one user for our software in the database and create an application users table. This means that all users actually connect as the same database user to the database. Does SQL Server see this as different sessions or just one?
    Johan

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True what you have mentioned above sessions, check with BOL for sessions then.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2003
    Posts
    30
    Even if you log in using same username, you can open multiple sessions, like in Query Analyzer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •