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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server Locking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-05 : 08:25:48
Haroon writes "Hi.this might not be a tough question to answer for you but its a problem for me.I wanted to know if SQL Server manages Locks by itself?.I have created a visual basic application with an Sql server database.The application also includes an account system thus increasing the need of appropriate locking.I have worked wholely in Stored Procedures.
If sql server manages locking itself,how do i check whether it does or not.Tell me a way that it practicle.
If sql server does not manage all locks,which types of locks will i have to manage.I require locks on insertion,updation and view.And please give me a clue as to how to implement locking.
Kindly mail me a solution.I'll be very thankful to you indeed.I'll wait for your quick reply.bye."

Nazim
A custom title

1408 Posts

Posted - 2002-08-05 : 08:36:35
see if this helps http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17983 .

-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson
Go to Top of Page
   

- Advertisement -