Although the procedures for manipulating scripts are defined as stored procedures, internally they are converted to DDL statements. As a result, all rules that apply to DDL statements apply to these stored procedures. For example, a DDL statement calling the stored procedure must be the last statement in a transaction.