generate Query (Sql server) with(nolock)

[naga5566]

Hi All,

IS there a way that when a query is generated in BO report,It generates "with(nolock) " clause of Sql server.
I am using Sqlserver 2k and BO 6.5.

For instance

select Table.col1,Table.col2 from
Table with(nolock)

Thanks
Naga

 

[blom0344]

Naga,

In the custom tab of the connection properties there are a number of connection parameters , like 'StmtOption'.
Check the ODBC reference guide to see if you can add an optimizer for SQL server...

Ties Blom
Information analyst