Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-17 : 07:53:41
|
ann writes "i created a trigger, code shown below, but its not working the way i want it to. i want the code to pass the k_content of the record that i updated. the stored proc that this trigger is calling is working but its not doing anything coz (i think) the value of the k_content that is being passed is not correct. im using sql 7, os is win2k server. i know this may seem a little easy on you guys but im really desperate for an answer. ill do anything.
CREATE TRIGGER if_content_was_updated
ON s_content FOR INSERT,UPDATE NOT FOR REPLICATION
AS
IF UPDATE (s_url) OR UPDATE (t_content)
BEGIN
EXEC SendEmailToSubscriptionClients k_content
END
would appreciate your help on this. thanks.
ann" |
|
|
|
|
|
triggers