create trigger

Question

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Here is an article that deals with the basics of DML triggers, http://www.sqlservercentral.com/articles/Triggers/64214/.

You should also lookup triggers in Books On Line.

SSMS also has templates that show you the syntax on how to create triggers.

Have you tried anything, yet?

GSquared SSC Guru Points: 260824 More actions · Answer 2

Insert, update and delete triggers are placed on specific tables, not on a whole database or server. You have to add them to each table.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon