HOW TO RESTRIC INSERT IN A TABLE

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 1

Write a trigger that doesn't allow inserts. Instead of trigger.

Tom

er sql SSC Eights! Points: 943 More actions · Answer 2

hi, I've implemented this.

IF EXISTS (SELECT name FROM sysobjects

WHERE name = 'NOT_FOR_INSERT' AND type = 'TR')

DROP TRIGGER NOT_FOR_INSERT

CREATE TRIGGER NOT_FOR_INSERT

ON SERVICE_REQUEST

FOR INSERT

AS RAISERROR (50009, 16, 10)

ROLLBACK TRANSACTION

GO