We have a dozen or so DTS jobs that run on our SQL Server. They run
independently and sometimes a particular combination occurs that causes a
deadlock. Our biggest problem is that we don't know why SQL Server is
locking the tables at all. In some cases we're doing a data driven query and
it locks the source tables. Can someone point me to information concerning
how to control or at least predict the locking mechanism? Thanks.

--paul

BOL has a good section on locking but Kalen Delaney also wrote an eBook
about blocking which extremely good.

http://www.shareit.com/product.html?...currencies=USD

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Paul Deas" <paul-dot-deas (AT) no-0spam (DOT) .com> wrote