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
There are various types of locs takes place in database, check this link for detail understanding
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?