Chapter 17 - Linked Server Update Error
Howdo Guys,
On page 576 of this book, there is a greyed out text box containing clues for identifying the problem that results in an error message stating that the ARITHABORT setting is incorrect during an update to a linked server.
Without typing out the entire list of options stated, I encountered this problem and tried everything suggested. The only thing that worked was dropping an indexed view in the Northwind database. The linked server update worked then.
When I recreated this view with ARITHABORT set to ON (as suggested by the book), I experienced exactly the same problem again when I tried to run the linked server update statement.
Why is this? Please can someone help/offer me some pointers here?
|
