CREATE TABLE [dbo].[MyTable](
[Value] [int] NULL
) ON [PRIMARY]
CREATE NONCLUSTERED INDEX [MyIndex] ON [dbo].[MyTable]
(
[Value] ASC
) ON [PRIMARY]
CREATE TRIGGER MyTrigger
ON MyTable
AFTER UPDATE
AS RAISERROR ('Notify Customer Relations', 16, 10);
ALTER TABLE [dbo].[MyTable] ENABLE TRIGGER [MyTrigger]