 sqlcmd -S localhost\SQLEXPRESS -i C:\app\ambari-server-1.3.0-SNAPSHOT\resources\Ambari-DDL-SQLServer-CREATE.sql
 */
 
-use [$(AMBARIDBNAME)]
-GO
 
 ------create the database------
 


    delete from task
    from task t inner join deleted d on t.taskId = d.taskId
END

GO

    DROP TRIGGER trigger_task_delete;
GO

exec('CREATE TRIGGER trigger_task_delete
ON task
INSTEAD OF DELETE
AS
