October 23, 2008 at 6:18 am
Hi,
I have a database . i implemented a DDL trigger on CREATE or DROP procedure ...in that trigger i insert stored proc text (From EVENTDATA function) into one table on another server B database and on that table i have applied DML INSERT trigger,and that DML trigger apply proc on server B database
the whole process is basically to synchronization two database's Stored Proc.
Can any body tell me that in DML trigger whether the proc will be deployed before completion
of that DML trigger .
i know it is a bit confusing but a little attention can tell you whole scenario ?
Please Help
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2008 at 7:35 am
I don't know the answer to your question, but I wonder if you could figure it out by putting a WAITFOR DELAY in your triggers and refreshing each server to see when the changes went live?
PS - Do you need to add ALTER PROCEDURE to your DDL trigger?
PSS - Just 'cause I want to guess even though I don't know, I'm going to throw in that I think the proc will be created on both servers simultaneously.
Good Luck!
Chad
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply