|
Posted by Erland Sommarskog on 10/13/05 10:32
MC (marko_culo#@#yahoo#.#com#) writes:
> Just a thought, its too early :). What would happen if he used NOLOCK
> option? He doesnt really need locks around the place does he?
If the problem is on the table he is reading from yes. But I suspect that
it's on the table he is inserting to.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|