DDL Trigger to update Instead Of Insert trigger

DDL Trigger to update Instead Of Insert trigger

Post by Daniel Jam » Fri, 10 Mar 2006 08:18:58


Peter,

Why not just use column level DENY, e.g.,

DENY UPDATE ON [dbo].[Application] (CreationDate) TO <<UserEntitly1>>
DENY UPDATE ON [dbo].[Application] (CreationDate) TO <<UserEntitly2>>
...

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org