title: Adding table lock manually to specified table in SQL Server
body: <p>I want to INSERT into one tables but prevent INSERTING to another one. It is possible to LOCK for example table <strong>a</strong> for INSERTING, INSERT to table <strong>b</strong> and then UNLOCK table <strong>a</strong>?</p>
  
  <p>TABLOCK can lock only the table I am INSERTING in.</p>
  
  <p>Thanks</p>
  
  <p>Martin Pilch</p>