IF OBJECT_ID('tSQLt.ApplyTrigger') IS NOT NULL DROP PROCEDURE tSQLt.ApplyTrigger;

CREATE PROCEDURE tSQLt.ApplyTrigger

@TableName NVARCHAR(MAX),

@TriggerName NVARCHAR(MAX)

DECLARE @OrgTableObjectId INT;

DECLARE @NewNameOfOriginalTrigger NVARCHAR(MAX);

SELECT @OrgTableObjectId = OrgTableObjectId FROM tSQLt.Private_GetOriginalTableInfo(OBJECT_ID(@TableName)) orgTbl

IF(@OrgTableObjectId IS NULL)

BEGIN

RAISERROR('%s does not exist or was not faked by tSQLt.FakeTable.', 16, 10, @TableName);

END;

DECLARE @FullTriggerName NVARCHAR(MAX);

DECLARE @TriggerObjectId INT;

SELECT @FullTriggerName = QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name), @TriggerObjectId = object_id

FROM sys.objects WHERE PARSENAME(@TriggerName,1) = name AND parent_object_id = @OrgTableObjectId;

DECLARE @TriggerCode NVARCHAR(MAX);

SELECT @TriggerCode = m.definition

FROM sys.sql_modules m

WHERE m.object_id = @TriggerObjectId;

IF (@TriggerCode IS NULL)

BEGIN

RAISERROR('%s is not a trigger on %s', 16, 10, @TriggerName, @TableName);

END;

EXEC tSQLt.RemoveObject @ObjectName = @FullTriggerName, @NewName = @NewNameOfOriginalTrigger OUTPUT;

EXEC(@TriggerCode);

EXEC tSQLt.Private_MarktSQLtTempObject @ObjectName = @FullTriggerName, @ObjectType = N'TRIGGER', @NewNameOfOriginalObject = @NewNameOfOriginalTrigger;

END;