When I looked up MSDN just to confirm, I couldn't find anything definite. But my experience was limited to SQL Server 2005. I was pretty sure that you need to specify the NOLOCK for each JOIN in the query.
0 Comments
Leave a Reply. |