I set up a transactional replication between two server with updating subscriber and queued updating as a failover option. When the connection between those two server is disconnect, I have to change manually the update method on subscriber to Queued Update by right clicking the publication on subscription directory on the subsriber. Is there any T-SQL code to change the update method on the subscriber ? Thanks in advance.