This code disable updating of the table:
create trigger [dbo].[drawing_drawing_update]
on [dbo].[drawing_drawing]
for update
as
begin
set nocount on;
raiserror( N'Table can`t be updated.', 16, 1 ) with nowait;
rollback tran;
return;
end;
Alternatively, you can protect only specified updated field(s):
create trigger [dbo].[drawing_drawing_update]
on [dbo].[drawing_drawing]
for update
as
begin
set nocount on;
if UPDATE( validsince )
begin
raiserror( N'Field can`t be updated.', 16, 1 ) with nowait;
rollback tran;
return;
end;
end;
When you trying to save row in application, this message will appears:
No comments:
Post a Comment