DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: General
       *****************************************************
       #Post#: 41--------------------------------------------------
       SPID  Change  for a Query 
       By: srinivasma_exceldbp Date: April 7, 2014, 11:04 pm
       ---------------------------------------------------------
       This may be surprising to many . Under Certain circumstances
       Query executing on a particular SPID may change to new SPID
       This happens when  all these Conditions are met
       1. When OLE DB or something based on OLE DB used for connections
       and query is performed
       2. Perform a query on a connection which has not fully consumed
       the
       entire result-set of the previous query
       3. Lock or Lock Time out happens
       4. Application is locked
       In the above case ,  the default behavior is to open a new
       connection behind the scenes.
       This new connection will have a different SPID number, and will
       access same set of locked table
       *****************************************************