Results 1 to 2 of 2

Thread: Problem with table locking in Yukon (SQL 2005)

  1. #1
    Join Date
    Aug 2004
    Posts
    52

    Problem with table locking in Yukon (SQL 2005)

    Hi there,
    Let me thanks to all of you for giving satisfactory answers to all my previous queries regarding DTS in MS-SQL server2000.

    Now I've problem with table locking in MSSQL 2005 (Yukon).
    I want to lock table for Insert/Update/Delete operation.
    Situation is something like this..

    I want to lock table for Insert operation.
    Once I locked the table, it should not allow me to insert records further ahead. Same way for delete & update..
    After certain routines , I need to unlock the table.

    Kindly let me know equivalent syntax in T-SQL , MS-SQL Server2005 (Yukon).

    Thanks in advance.

    Avadhoot

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried 'insert table_name with (holdlock) ... values ...'?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •