>>Can you show some code? In the query window I just tried:
>>
>>DECLARE @MyVariable CURSOR local and it produces an error.
>
>I have:
>
>

>DECLARE tableIndexes CURSOR LOCAL FOR
>

Ok, thanks. I didn't specify the FOR part.