J
jmls
Guest
I think that the problem is isolation level. user sqlrep-5 (for example) has a number of SHR locks in the locking table, even though the default isolation level of the odbc connection is set to READ UNCOMMITTED we have multiple queries running, and they seem to get into a deadly embrace. if I disconnect one of the users, then the other report completes ok can a query store the isolation level in it somewhere ? We are using excel 2013 with msquery
Continue reading...
Continue reading...