Re: A lot of sp_cursorfetch in profiler.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 11:31:46 +0100

You should open a "firehose" cursor, AKA "default resultset", AKA adOpenForwardOnly (try this
attribute on your recordset). 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Geir Holme" <geir@multicase.no> wrote in message news:OQ2SDd0EFHA.3536@TK2MSFTNGP15.phx.gbl...
> Hi all.
> I am looking at some profiler logging and gets a lot of the lines looking like:
>
> exec sp_cursorfetch 180150024, 2, 0, 1
>
>
> This comes after running a simple prosedure that select some lines.
>
> All i VB6. I guess it has something to do on how we retrieve data (ADO). Does anyone have a few 
> hints on where to look to get rid of all these lines. Or what to try.
>
>
> thanx all.
>
> geir
>

Relevant Pages

  • Re: Examples for these ~ same resultset....
    ... Tibor Karaszi, SQL Server MVP ... "SQLCatz" wrote in message ... > By same resultset ~ what I meant was - ...
    (microsoft.public.sqlserver.server)
  • Re: getting info from temp table
    ... It makes SQL Server not return the "rows affected" message after each DML operation. ... as a closed recordset... ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.inetserver.asp.general)
  • Re: getting info from temp table
    ... It makes SQL Server not return the "rows affected" message after each DML operation. ... as a closed recordset... ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: DMAX equivalent
    ... WHERE CustNo = @CustNo ... Tibor Karaszi, SQL Server MVP ... > I need to return a recordset that is the equivalent to a query that ...
    (microsoft.public.sqlserver.programming)
  • Re: recordset not opening even though query analyzer returns resul
    ... I'm convinced that VB can execute this complex SP. ... > only way i could get an earlier version of it to return in a recordset. ... > table into a cursor and add up th evalues of the ccjs based on values in ... >> execute a query the SQL engine returns a resultset. ...
    (microsoft.public.vb.database.ado)