sp_cursorfetch

• tran008

  Ten Centuries

  Points: 1002

  More actions

  January 21, 2004 at 2:47 pm

  #65918

  Hi All,

  Any one know what sp_cursorfetch does and what RPC have to do with them? I try to look it up on BOL and can't find any reference to it. 

  thanks

  RPC:Completed exec sp_cursorfetch 180150001, 32, 1, 1 Microsoft(R) Windows (R) 2000 Operation

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 21, 2004 at 3:08 pm

  #491039

  It's documented in BOL under API Server Cursors.

  
  
  --Jonathan

• ckempste

  SSCoach

  Points: 17983

  More actions

  January 21, 2004 at 7:02 pm

  #491057

  Hi there

  You will typically see these when your apps are using server side cursors, have a closer look in profiler and you may also see sp_prepare, sp_prepareexec etc; take care with these, we have had some very strange IIS errors (in which IIS is taken down) based on the mdac version and the use of server side cursors. 

  Do not go ahead and attempt to use these system procs directly unless you have a really good reason why - and I want to hear it!

  Read up on google re server side vs client vs default cursors.

  Cheers

  Ck

   

   

  
  Chris Kempster
  www.chriskempster.com
  Author of "SQL Server Backup, Recovery & Troubleshooting"
  Author of "SQL Server 2k for the Oracle DBA"