.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

how to lock table in sql server

Posted By: Ramesh     Posted Date: May 31, 2009    Points:2   Category :Sql Server
Hi,
how to lock table in sql server. i want to lock table while updating data into a table. Is there any way to do that?

Thanks in advance

Responses
Author: Vuyiswa Maseko             
Posted Date: June 01, 2009     Points: 5   

In SQL there are Locks

Look here

[u]
http://www.databasejournal.com/features/mssql/article.php/3566746/Controlling-Transactions-and-Locks-Part-5-SQL-2005-Snapshots.htm
[/u]

[u]
http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/
[/u]

[u]
http://duartes.org/gustavo/articles/Lock-Down-SQL-Server-2005.aspx
[/u]

[u]
http://www.databasejournal.com/features/mssql/article.php/3566746/Controlling-Transactions-and-Locks-Part-5-SQL-2005-Snapshots.htm
[/u]


Vuyiswa Maseko

Author: Narayanan             
Posted Date: July 20, 2011     Points: 20   

http://forums.techarena.in/software-development/1243154.htm
http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Ravi Ranjan Kumar             
Posted Date: July 25, 2011     Points: 20   

Try
http://msdn.microsoft.com/en-us/library/aa213039(SQL.80).aspx

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend