none
What type of lock prevents an architecture change?

Answers

  • What type of lock prevents an architecture change?

    I assume by architectural change, you mean a change to the database schema (change to an object).  In that case, a schema modification lock (SCH_M) is what you are referring to.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Praveen Rayan D'sa Friday, December 20, 2013 4:24 AM
    • Marked as answer by Yesi P Friday, December 20, 2013 3:42 PM
    Friday, December 20, 2013 3:48 AM

All replies