One more thing the above sql statement runs multiple times ( 1000 - 5000 ) times in a hour. I was thinking instead of running this statement can I put...

Thank you all will check the follow the advice

it adds the new logins in the table with create date. The same trigger am testing on local it is working but not firing on QA client box. Do you...

I am having DDL trigger with server scope. The same trigger gets executed on a local box with 2014 without AAG configured , but If I ran the code on...

Please provide your input.

I wanted the output of the query to applied in another server.

The paswd being VARBINARY is not getting written to the output sql file. Could you please help here.

Or is it possible to copy the below statement to be one...

Thanks Gail Shaw, I was able to capture login and passed it to Sproc.

I will test on DEV first and follow up with all the env.

Thanks for replying back now, I am going to optimize the code as suggested and update the group.

Any update?

Hi All,

Please provide me your input for both the scenario.

Hi expert ,

Could you please provide your expert opinion.

In my replication R1 and R2 and R3 , I am not able to reinitialize as R1 and R2 act as both publisher and subscriber.

How do I handle re...

I did find the issue and resolved it.:-)

Issue : Multiple rows were not able to get applied on subscription when AFTER INSERT ,UPDATE trigger is enabled.

Data flow: Publisher - Table...

I tried that , but we need the trigger to update FLI table hence I cannot use NOT FOR REPLICATION.