HAPPYCAT59 - Thanks for the reply! I started to go there but then I read at http://technet.microsoft.com/en-us/library/ms151718.aspx - Updatable Subscriptions for Transactional Replication - "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.".

So, I'm trying to figure out where Microsoft is headed with replication. What do you think? The big concern is:

What is today's best practice for a stored procedure that runs on a subscriber that needs to do an insert, update, or delete.

Thanks for your help.

PS - I tried to find some information on why Microsoft is deprecating "Updating Subscriptions for Transactional Publications" and couldn't find anything.