Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  lock delays & retries

Author  Topic  bienew Starting Member 8 Posts Posted - 2007-08-01 : 05:40:57 Hi, With JET, when a query is trying to open a locked record, I can use the "Jet OLEDB:Lock Delay" and "Jet OLEDB:Lock retry" properties, to set how long I want to wait until the record is released, or how many times I want to retry the query before giving up. How do I manage it with SQL server (SQLNCLI) ? I'm executing VB applications and don't want them to wait for too long when a record is locked. Thank you.