SQL Server 2000 Lock and Unlock question

Hi,

We are developing our C#.Net 2.0 applications using the SQL Server 2000 as
our database server.
We didn't do anything useing the Lock and Unlock so far, and our application
runs seems fine, but I'm not sure.
Given on this situation that Client A and Client B and Client ... are using
our application and they all will insert record into a SQL Server Table
TableA.
Do we need to do anything like Lock or Unlock for handling that TableA?
Thanks for help.


Jason

Re: SQL Server 2000 Lock and Unlock question

This is an IIS newsgroup, you should check in a sql group. Gor your
question, I'd recommend checking out Patterns and Practices sql perf chapter
14.

http://msdn2.microsoft.com/en-us/library/ms998577.aspx

--

Best regards,

Steve Schofield
Windows Server MVP - IIS
http://weblogs.asp.net/steveschofield



"Jason Huang" wrote in message
news:eFf19Nu6HHA.5752@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> We are developing our C#.Net 2.0 applications using the SQL Server 2000 as
> our database server.
> We didn't do anything useing the Lock and Unlock so far, and our
> application runs seems fine, but I'm not sure.
> Given on this situation that Client A and Client B and Client ... are
> using our application and they all will insert record into a SQL Server
> Table TableA.
> Do we need to do anything like Lock or Unlock for handling that TableA?
> Thanks for help.
>
>
> Jason
>
>