Is there a way to change the default behavior of selects in SQL Server CE, with nolock in selects, without having to explicitly ask for a lock in the query? I don't want nolock per default, and I don't want to explicitly set with(rowlock).
Asked
Active
Viewed 429 times
0
-
Have you tried SET TRANSACTION ISOLATION LEVEL? – ErikEJ Feb 14 '12 at 08:09
-
The isolation level used in the transaction is Read Committed (implicit and explicit) and the behavior works in SQL Server it's just that SQLCE has nolock as default.... http://msdn.microsoft.com/en-us/library/ms171885(v=sql.90).aspx – Daniel Feb 14 '12 at 08:49