Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From: Travis Crow <noreply@invalid.org>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Cursor Question
Date: Fri, 2 Dec 2011 12:03:48 +0000 (UTC)
Organization: Aioe.org NNTP Server
Lines: 11
Message-ID: <jbaer4$ogt$1@speranza.aioe.org>
References: <jbabbk$g59$1@speranza.aioe.org> <Xns9FAF80203B027Yazorman@127.0.0.1>
NNTP-Posting-Host: CSjod2juaAwkjN0Czk2TZw.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Pan/0.133 (House of Butterflies)
X-Notice: Filtered by postfilter v. 0.8.2
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:858

On Fri, 02 Dec 2011 12:35:43 +0100, Erland Sommarskog wrote:

> With a static cursor, the result set of the cursor is saved to a temp
> table and the rows are served from this table. I believe this happens at
> OPEN time, but you could easily test to find out.

Thanks. I have tested this and it appears to be at OPEN time.

-- 
Travis Crow