Yep, you haven't declared it, or haven't declared it properly. If you're just using a straight cursor you need to do something like:

DECLARE myCursor CURSOR

FOR SELECT ... {your query goes...

Hi James,

I completely understand what you're saying, and therefore if you want confirmation in writing that SQL Prompt 2 is free, and that the license agreement bundled with the installer...

It's a fair point Jereme, but what about everything in writing that *we've* also published saying it's free? It says so on our website, it says so on all our...

Hi James,

The issue with the licensing agreement in SQL Prompt 2 is our mistake, which we have been aware of for some time. It should not mention a 14 day...

Further to my earlier comments, I seem to have stirred up a frenzy of decision-making in the office today, and as a result I am now able give you full...

A quick update on the licensing issue. I just spoke to our marketing director Simon Galbraith about what we'll do for people who purchased PromptSQL just before Red Gate acquired...

Interesting thread here, and I think all the comments that have been made are fair. We're very aware of the issues with SQL Prompt 2, and that's a big part...

Hi Christopher,

It sounds to me like you've got the initial beta version of SQL Prompt 2.0 that went out some time ago. The release version is completely free and therefore...