Meditation: Replicate Data from Multiple Instances into a Single Reporting Database

  Somebody approached me recently with a question like this: Question: We’ll be hosting our existing application in one data center, but we’ll be setting up 2 more instances in two different data centers. Is possible to use replication to move all the data into an single database so that we can report on all…

0

Procedure Execution with Table-Valued Parameters Involved Cannot be Replicated

  Somebody approached me with this error, asking whether this is by design or caused by certain conditions. Msg 25023, Level 16, State 1, Server <removed name>, Procedure sp_MSaddexecarticle, Line 192 Stored procedures containing table-value parameters cannot be published as ‘[serializable] proc exec’ articles.   Step 1: The first thing I wanted to do was…

0