Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106

    Unanswered: spid network library

    Hey guys,

    I'm wondering if it's possible to see which library which a spid is using? For example, is the spid coming from a jdbc connection, or an odbc connection?

    Thanks,
    -Kilka
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You are just about at the mercy of the application for this. You can try to figure it out from the program_name and net_library columns in sysprocesses, but most applications tend to forget to put in an Applicaiton Name in their connection strings. The net_library column really just shows how SQL Server is listening to the client.

  3. #3
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    Ok thanks MCrowley.

    Cheers,
    -Kilka
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

Posting Permissions

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