Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
All,
I have an IDS 9.40FC6 database which receives queries from Sql Server
2000's OpenQuery functionality. OpenQuery will only pass one select
statement, so the "set isolation to dirty read" cannot be passed
followed by another select statement.
Does anyone have any ideas of how I can set the isolation level to dirty
read in any other way? All sessions that connect as a specific user id
to a given database need to have the isolation level set to dirty read.
Any ideas would be greatly appreciated.
Thanks.
Pam Ekstrand
Database Administrator
OneNeck IT Services
480-315-3087
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.