Results 1 to 3 of 3

Thread: What is spid?

  1. Jun 14th, 2010, 08:03 AM #1
    aspfun
    aspfun is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2010
    Posts
    478

    What is spid?

    I ran sp_who2 in sql server, what is SPID?
    From Microsoft, I found that it is session ID.(I copied it at bottom).
    I used ASP.NET in app, what is the relationship between SPID and connection string? Is it processing ID?
    -------------
    session ID (SPID in SQL Server 2000 and earlier) is a session identification number belonging to the SQL Server instance. session ID is smallint.
    Reply With Quote Reply With Quote
  2. Jun 14th, 2010, 08:09 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: What is spid?

    the spid uniquely idendifies a given connection to the database. the relationship is that you connect, you get a spid. the connectionstring doesn't affect the spid and the spid does not affect the connectionstring. it is any connection to the server. If you make multiple connections to the server at the same time, you get multiple spids assigned. Also spid is what you pass to the sproc to kill a process (something that should only be done under extreme circumstances) on the server.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Jun 14th, 2010, 08:29 AM #3
    gep13
    gep13 is offline
    PowerPoster gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: What is spid?

    aspfun, was this just a general question, or are you having a specific issue that you are trying to fault find?

    Gary
    Remember to mark your thread as resolved. Remember to rate posts that help. Hitchhiker's Guide to Getting Help at VB Forums.

    ASP.NET Tutorials (updated Feb 1st 2009) ASP.NET FAQs (updated July 17th 2011)

    Free Stuff: WebsiteSpark|DreamSpark|BizSpark|eBooks
    Learning Resources: MSDN|LearnVisualStudio|TrainingSpot|ScottGu's Blog|ASP.Net Starter Kits|Regex|RegExLib
    Useful Tools: XPath Builder|UltraMon|RegExBuddy|CopySourceAsHtml|TracExplorer|SQLyog|Chart Controls for .Net|SharePoint Designer|CodeRush Express
    Coding Links: XPath|ConnectionStrings|VB and MySQL|MySQL Connector.Net|My.Settings
    ADO.Net: MSDN Reference|Introduction|Using Access|Always use Parameters|Save and Retrieve Data - jm|An Explanation - jm
    Code Bank Submissions: Code Snippets|Profile Provider|Serialization: C# VB|Restricted Menu|Compressed HttpWebRequest|Enumerate and Add Internet Explorer Favourites: VB C#|C# Tabbed Web Browser|Enhanced Tabbed Web Browser: VB C#

    My Blog - View my MCP Certifications
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width