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
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
2 matches
Mail list logo