The SORT_IN_TEMPDB = ON option isn't supported for resumable index operations. The DDL command with RESUMABLE = ON can't be executed inside an explicit transaction. You cannot create an index using a ...

Locks are held on [!INCLUDE ssNoVersion] resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by different transactions. For example, if an exclusive ...