Re: Row/Table Locks and SQL Server

2009-11-11 Thread Kris Jones
Does your procedure specify rowlocks, nolocks, etc? Without that you may be at the mercy of the client (or driver in this case) Cheers, Kris > Following the bulk insert of a fairly complex xml document, I run a stored > procedure which parses through the document passing the values into > relati

Row/Table Locks and SQL Server

2009-11-11 Thread Charles Sheehan-Miles
Okay, I'm observing a very strange phenomena. Following the bulk insert of a fairly complex xml document, I run a stored procedure which parses through the document passing the values into relational tables. This part is all done in SQL, inside the stored procedure. Platform: Windows Server 20