Schema name is missing in the ALTER trigger statement when it contains different schema name the dbo.
See below the script from dbForge and SSMS
ex. script generated bij dbForge
Code: Select all
--
-- Alter trigger [trfOutBOM] on table [EAI].[OutBOM]
--
GO
IF OBJECT_ID(N'[EAI].[trfOutBOM]', 'TR') IS NOT NULL
EXEC sp_executesql N'CREATE OR ALTER TRIGGER [trfOutBOM] ON [EAI].[OutBOM]
AFTER INSERT, DELETE
AS
BEGIN
DECLARE @SystemTrigger BIT = 0
IF UPDATE (DatumUpdate) AND Update(DatumCreatie) AND UPDATE (LastUser) AND UPDATE (LastHost)
SET @SystemTrigger = 1;
Code: Select all
ALTER TRIGGER [EAI].[trfOutBOM] ON [EAI].[OutBOM]
AFTER INSERT, DELETE
AS
BEGIN
DECLARE @SystemTrigger BIT = 0
IF UPDATE (DatumUpdate) AND Update(DatumCreatie) AND UPDATE (LastUser) AND UPDATE (LastHost)
SET @SystemTrigger = 1;
Ganendran