Add "For Read Only" at the end of the cursor declaration...
DECLARE @C cursor
SET @C = cursor FOR
SELECT * FROM Foo
FOR READ ONLY
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.