Could not Create Acceptable cursor

I have sql server 2005 to which a sql 2000 server is added as a linked server.
when I try to update some tables in SQL2000 server from sql2005 server
It generates the following error.

"Could not generate acceptable cursor."

Thanks in advance for the help

See KnowledgeBase article:

http://support.microsoft.com/kb/302477

|||

I ran into the same thing just today.

I was running an update query on a linked server.

I added a primary key on the destination table and that handled the problem.