TABLOCK HINT NOT USED IN ISQL

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  January 6, 2004 at 9:58 am

  #107037

  I have a stored procedure which uses TABLOCK hint when executing. It works fine from QA. However, when I execute the same sp from a batch file using ISQL, it does not lock the table and , instead, locks extents in tempdb. Is this because ISQL communicates differently with SQL Server 7?

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  January 7, 2004 at 4:27 am

  #488919

  Could be.

  Have you tried with OSQL instead of ISQL?

  /Kenneth