doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'

• RazLinky

  SSC Enthusiast

  Points: 171

  More actions

  August 9, 2022 at 11:53 am

  #4074356

  i have a cursor that runs on all my views

   

  and then exec sp_refreshview in order to validate it .

  when sp_refreshview executing, does it locks the view ?

• Site Owners

  SSC Guru

  Points: 80311

  More actions

  August 10, 2022 at 12:10 pm

  #4074775

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

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