hi

Please review the syntax below for me, it does not execute or give error. How do i check if my trigger are enableb or configured to run.


--DROP TRIGGER User_Defined_field_KAE
CREATE TRIGGER User_Defined_field_KAE
ON [dbo].[AMGR_User_Fields_Tbl]
AFTER
INSERT

AS

INSERT INTO [dbo].[AMGR_User_Fields_Tbl]
(Client_Id,
Type_Id )
SELECT
I.Client_Id,
'1088'
FROM inserted I, [dbo].[AMGR_User_Field_Defs_Tbl] AS A
WHERE I.Type_Id = a.Type_Id
AND A.code_id = I.code_id;

UPDATE [dbo].[AMGR_User_Fields_Tbl]
SET AlphanumericCol = (select USER_PHONE_4
FROM [dbo].[ADMN_User_Details] AS R inner join [dbo].[AMGR_User_Field_Defs_Tbl] AS S
ON S.Description = r.user_firstname + ' ' + r.user_name
WHERE S.Type_Id = 107 AND
S.code_id = 58);