• vk-kirov (2/10/2010)


    In the example above, we will see request_mode = Sch-M (schema modification). This is specific to DDL events.

    Not true. From Books Online - Lock Modes:

    Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected tables by concurrent operations.

    So, table truncation is explicitly defined as a DML operation.