How Locks held when executing Stored procedure

• gana79950

  Old Hand

  Points: 371

  More actions

  September 4, 2019 at 4:50 pm

  #3677302

  Hi,

  I have to execute a stored procedure which is copying data from source tables from one database to archive database and then delete copied records from source tables. This procedure is doing this for more than 100 tables.

  refer: http://vyaskn.tripod.com/sql_archive_data.htm

  Question:

  while executing this procedure, does the table locks acquired on all of the tables as soon as the procedure started or it only locks one table at a time as it executes?

  • This topic was modified 5 years, 2 months ago by  gana79950.
  • This topic was modified 5 years, 2 months ago by  gana79950.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 5, 2019 at 5:10 pm

  #3677712

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.