|
Posted by Oscar Santiesteban on 06/23/07 03:15
Try using
select * from table (NOLOCK)
where xxxx = xxxx
This will not lock the database as it reads.
"Altman" <baltman@easy-automation.com> wrote in message
news:1182518265.867797.118630@k79g2000hse.googlegroups.com...
>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?
>
Navigation:
[Reply to this message]
|