创建游标出错了,求助!
操作:
declare ChangeLogCur cursor for select * from zhang.DBTrans.dbo.TB_YX_ChangeLog order by FD_TableName,FD_RecordID,FD_OptType
说明:
zhang.DBTrans.dbo.TB_YX_ChangeLog 为远程服务器数据库中的数据表
错误信息:
Server: Msg 16953, Level 16, State 1, Line -2124180256
Updatable keyset cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level.
Server: Msg 16916, Level 16, State 1, Line 2
A cursor with the name 'ChangeLogCur' does not exist.
寻求解决办法!