dynamic decalre cursor...does not exist.

同事寫了一段SQL在SQL2000執行正常，但在SQL2008R2無法執行
SQL中是動態組一段declare cursor的語法
模擬了一下SQL大概如下

declare @sql nvarchar(4000),@c1 nvarchar(10),@c2 int
set @sql = N'declare cur cursor for select ''col1'' as col1 ,1 as col2'
exec sp_executesql @sql
open cur
fetch next from cur into @c1,@c2
while @@FETCH_STATUS = 0
begin
 print @c1
 fetch next from cur into @c1,@c2
end
close cur
deallocate cur

在SQL2000執行正常，會print出 'col1'

但在SQL2008R2上，回傳了以下的錯誤
Msg 16916, Level 16, State 1, Line 3
A cursor with the name 'cur' does not exist.
Msg 16916, Level 16, State 1, Line 5
A cursor with the name 'cur' does not exist.
Msg 16916, Level 16, State 1, Line 11
A cursor with the name 'cur' does not exist.
Msg 16916, Level 16, State 1, Line 12
A cursor with the name 'cur' does not exist. 

後來發現，在SQL2008R2另外幾個DB也可正常執行，就只有某個DB不行

查看了該DB的屬性，最後在option 的設定下有關Cursor的設定，有參數值Default Cursor = LOCAL，改成了GLOBAL後，就可利用dynamical sql宣告CURSOR了