Yes, nested triggers are enabled, but still it does not seem to work...
-----Original Message-----
From: Carol Green
[mailto:mssqldba-ezmlmshield-x68597834.[Email address protected]
Sent: Tuesday, October 31, 2006 4:22 AM
To: LazyDBA Discussion
Subject: RE: cascading triggers
Yes - as long as you have the nested triggers box checked (see server
settings under the properties for the server).
Carol.
-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x36394452.[Email address protected]
Sent: 30 October 2006 22:10
To: LazyDBA Discussion
Subject: cascading triggers
If Table A has a trigger1 that deletes a row from Table B, can Table B
have a trigger2 that deletes a row from Table C?
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within
it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the
information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment
on the part of Optilan unless confirmed by a communication signed on behalf
of the company.
Any email cannot be guaranteed to be secure, error free or free from
viruses. Although every possible care is taken by Optilan, Optilan does not
accept any liability whatsoever for any loss or damage which may be caused
as a result of the transmission of this message by email.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page