SQL Server >

SQL Server Forums >

SQL Server Database Engine >

sql_server_locks

sql_server_locks

Saturday, July 28, 2012 7:56 AM

0

Hi,

any one can explain what is lock and how we can use it,How to avoid the locking

Thanks

Ram_dba123
- Reply
- Quote

All Replies

Saturday, July 28, 2012 8:54 AM

1
Hi,

Please read:

http://msdn.microsoft.com/en-us/library/ms175519(v=sql.105).aspx - locks

http://msdn.microsoft.com/en-us/library/ms189122(v=sql.105).aspx - isolation levels

http://msdn.microsoft.com/en-us/library/ms188277(v=sql.105).aspx - versioning

http://msdn.microsoft.com/en-us/library/ms189857(v=sql.105).aspx - locking hints

http://blogs.technet.com/b/josebda/archive/2009/03/19/sql-server-2008-locking.aspx

Thanks, Andrew
- Proposed As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee Saturday, July 28, 2012 9:22 PM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, August 05, 2012 3:46 PM
- Reply
- Quote
Sunday, July 29, 2012 5:34 PM

0

Hi andrew,

Thanks for you are reply ,Please send me any video related links it will more help full for me

Thanks

Ramesh
- Reply
- Quote

Frequently asked questions - Forums help