For more information, see CREATE TRIGGER (Transact-SQL). Truncating Large Tables Microsoft SQL Server has the ability to drop or truncate tables that have more than 128 extents without holding simultaneous locks on all the extents required for the drop.