row locking with MS SQL Server 
Author Message
 row locking with MS SQL Server

Try this : in your query add "WITH (ROWLOCK)"

For example : UPDATE mytable WITH (ROWLOCK) SET myfield = 'whatever'

Hope this will help



Sat, 20 Sep 2003 19:08:48 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How do I apply row-level locking in SQL server with ADO

2. ADO SQL Server Row Locking

3. Record Locking in MS SQL Server 6.5

4. Get Username or Computername after lock (or deadlock) errors from MS SQL server (7 or 6.5)

5. Executing MS SQL Server 2000 stored procs via MS Access 2000

6. Moving Oracle records to MS SQL Server using MS Access

7. Complicated Record Handling on MS Sql server and MS Accesses Databases

8. CA-Prog Analyst, MS SQL Server, Visual Basic and MS Access

9. Access to MS ACCES and MS SQL server

10. Row Locking Using ADO 2.0 to an SQL 7 database

11. Monitor on Server with MS SQL Server Does Not Respond

12. Application Development: MS-Access, Visual Basic, SQL Server, SQL Anywhere

 

 
Powered by phpBB® Forum Software