Validate subscriptions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deni - 30 Jul 2006 03:29 GMT

SQL server 2000
replication - Tran with read only subsriber
When i run Validate subscriptions on publication i see error as below :

SQL server enterprise manager could not validate subscriptions.
Error 20585: Validation failure. Object '(null)' does not exist.

Any idea what is wrong ?

Reply to this Message

Hilary Cotter - 31 Jul 2006 03:50 GMT

Try running it through query analyzer

exec sp_publication_validation @publication = N'MyPublication',
@rowcount_only = 1, @full_or_fast = 2, @shutdown_agent = 0

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> SQL server 2000
> replication - Tran with read only subsriber
[quoted text clipped - 4 lines]
>
> Any idea what is wrong ?

Reply to this Message