Queued update

Dear friends

I have a simple doubt.

1)What is the difference between Queued Updating & Immediate Updating in Transactional Relplication.

2)What is the difference between Meged Replication & Peer to Peer replication.Because in both each node will Act as Publisher/Subscriber.So load balancing is possible both type replication na?

3) how to replicate views,stored procedure & functions.Beacuse when applying intial snapshot the copy is getting in subscriber.But afterwards whatever changes occurring in view,procedure not propagating from publisher to subscriber.what to do in this case

Filson

1. Queue can handle offline changes, immediate updating works only when publisher/subscriber are connected, otherwise change at the subscriber will fail.

2. In a nutshell, P2P is used mostly for server-server environment, Merge is for server-client environment. Read BOL topics (cited below) for more information.

3. In sp_addpublication/sp_addmergepublication, set @.replicate_ddl = 1. For more information about schema changes, see "Making Schema Changes on Publication Databases", http://msdn2.microsoft.com/en-us/library/ms151870.aspx.

For more information, please see Books Online topic "SQL Server Replication", http://msdn2.microsoft.com/en-us/library/ms151198.aspx.