Not the answer you're looking for? The error details are :   Msg 16955, Level 16, State 2, Line 1 Could not create an acceptable cursor.

Thanks a lot Entela entela, Mar 29, 2007 #2 MohammedU New Member Check the following article...it is for sql 2000... updating a table on one server from another linked server, where the collation is different. In the ODBC case, we are really going through MSDASQL/ODBC Driver of 2 layers that interact with SQL Engine. Covered by US Patent.

product = sku in this case, just different field names in the different tables. You cannot post or upload images. You cannot post HTML code. Copyright © 2002-2016 Redgate.

Would I still need the hotfix? Microsoft SQL Server test 2396 55 2011-02-15 07:35:59.663 Exception Error: 16945, Severity: 16, State: 2 Microsoft SQL Server test 2396 55 2011-02-15 07:35:59.663 User Error Message The cursor was not declared.