sqlsql-serverselectlockingnolock

SQL Server - how to set (nolock) hint as a default?


is there some way to tell sql server to use the (nolock) hint or every select in a stored procedure?

is pretty tiresome to add it to each an every select....


Solution

  • found this....

    How to force nolock hint for sql server logins

    seems like the best way to achieve this is to issue a

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    any other idea???

    ps

    another related question...

    NOLOCK vs. Transaction Isolation Level