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.