Hello,
is it possible to set up connection to MS SQL as read only? Doing it via SQL seems not to work, for example:

SELECT * from table_xxx (nolock)

still locks the table_xxx.

regards

ys