View

• What if I edit a View in use?

  Apr 16, 2017

  There are times we need to modify a view in production, we can use tools like sp_who2 / sp_whoisactive or use the DMV’s and Extended Events ourselves to see who’s using the views at the moment. But what happens when we need to modify the view but it’s currently in use?

  Modifying the underlying table for the view should not make an impact when running alter view. This is not true to users trying to access the view.