Friday, February 24, 2012

dbo.MSdistribution_history

Hi All,
I want to know when dbo.MSdistribution_history table will be created
and where it will be present (under master database or any other
database)?
I think this table will be created when you enable replication on your
SQL Server and will reside under master database.
Please correct me if I am wrong and let me know ASAP.
Thanks and Regards,
Pramod
It's in the distribution database. There's a view called
'MSdistribution_status' that helps to get info from it.
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