Wednesday, March 7, 2012

Expand_268 & Expand_268_PAL Srored procedure in Publisher DB

Hi,
I am seeing lot of Stored Procedures named like Expand_% and Expand_%_PAL in
my Publisher Database. I could not find any documentation on these Procedures
in any Replication article. I would appreciate if somebody can explain!
Thanks in Advance!
Vikas Kohli
They're used by merge replication during synchronization and you can see
which table they apply to by examining their TSQL. Sometimes they are
orphaned procs left behind after removing a publication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment