SQL Server - how to set (nolock) hint as a default?
locking, nolock, select, sql, sql-server
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
Problem
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....