How to set Isolation level for sql server queries within Excel?
Posted on 2009-02-19
I've got an excel spreadsheet which has some 'external data' - which comes from an SQL Server database - and is set to refresh automatically. This has been working fine for a long time...
Then today - I start getting errors in the spreadsheet saying its been selected as a deadlock victim. I tracked down that the deadlock was between some info the spreadsheets query was reading - and writting that info by another process. God knows why this just started happening?
Anyway - I'm thinking that maybe somehow the spreadsheet has started using a more restrictive isolation level today? How is that stuff defined for a query within excel? Any other reasons why my excel query might suddenly start causing deadlocks?