Skip to content

Instantly share code, notes, and snippets.

@max-mulawa

max-mulawa/DML Trigger Snippet 6.sql

Created April 20, 2011 09:45
Show Gist options
  • Save max-mulawa/930859 to your computer and use it in GitHub Desktop.
Save max-mulawa/930859 to your computer and use it in GitHub Desktop.
Download ZIP
DML Trigger Snippet 6
Raw
DML Trigger Snippet 6.sql
CREATE TRIGGER dbo.Customers_stopUpdates
ON dbo.Customers
AFTER UPDATE
AS
BEGIN
RAISERROR ('Cutomers table cannot be updated.', 16, 1)
ROLLBACK TRAN
END
GO
DROP TRIGGER dbo.Customers_stopUpdates;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment