Is there any way to make the SQL Preview when selecting a table READ-ONLY? Currently it gets some level of lock on the database during the preview. Many times I get timeouts or other odd results because of this locking.
Thanks,
Don.
Did you define the ODBC entry as READ UNCOMMITTED?
No. I didn't see anywhere in Edit Connection Profile that I could select any type of READ-ONLY setting. Would I manually type something under Additional Parameters?
If I run the following script against the connected database, Navigator Preview will use read uncommitted until I close and reestablish the connection, which then puts in back to read committed. I don't see why the PREVIEW would ever use read committed.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;