I have a customer using our program with SQL server and is
occasionally getting a "Transaction (process ID xxxxx) was deadlocked
on lock resources with another process and has been chosen as the
deadlock victim." From what they are telling me, there shouldn't be
any deadlock happening as they say this happens when they invoicing in
a different program that is accessing a different database. Also the
error is happening on an SQL Select from a view and this select is
then showing data in an HTML table for the user. I don't think this
view should need to lock anything, I just want to read the data. Is
there anything I can do to fix this?

On Jun 22, 8:17 am, Altman <balt... (AT) easy-automation (DOT) com> wrote:
Read "Analyzing Deadlocks with SQL Server Profiler" in BOL.

http://sqlserver-tips.blogspot.com/

Try using
select * from table (NOLOCK)
where xxxx = xxxx
This will not lock the database as it reads.


"Altman" <baltman (AT) easy-automation (DOT) com> wrote

Oscar Santiesteban (o_santiesteban (AT) bellsouth (DOT) net) writes:
This may on the other hand lead to that the query returns incorrect
results, which may even more seroius. There are situations where NOLOCK
is called for, but you need to understand the implications. If you
don't - don't try it.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Jun 23, 4:10 am, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
I Think that the nolock will work for me. I understand the
implications and I think that my program will be able to handle it.
What I would've liked better was something like read committed but
didn't lock records.

On Jun 26, 10:30 am, Altman <balt... (AT) easy-automation (DOT) com> wrote:
If you are on 2005, consider snapshot isolation.

http://sqlserver-tips.blogspot.com