I had a stored procedure that used a simple cursor to do a query against a linked SQL 2005 database. It worked for years and failed out of the blue a month ago and the only way to fix it was to modify the cursor declaration to make it INSENSITIVE.
Any ideas why this would be? No data is modified on the linked DB, just the local DB. Seems weird this worked for years up until mid-august. All SPs with cursors that were not local had to be modified to be INSENSITIVE.
View Complete Post