sql server replication: am i going crazy or sp_publication_validation is? -- sql server replication

am i going crazy or sp_publication_validation is?

Koni
8/29/2006 11:00:27 AM

sql server replication:

sp_publication_validation does not seem to show any errors/mismatches
after I delete a bunch of rows from a subscribed table. The ManStud GUI
validation function works fine and catches the mismatch in row counts.

use opeidev
go
declare @ReturnCode int

exec @ReturnCode = sp_publication_validation
@publication = 'OpeiDev'
, @rowcount_only = 1
, @full_or_fast = 0

--select @ReturnCode

Re: am i going crazy or sp_publication_validation is?

Koni
8/29/2006 12:28:35 PM

[quoted text, click to view]

Re: am i going crazy or sp_publication_validation is?

Hilary Cotter
8/29/2006 12:52:40 PM

This should work. However what is ManStud GUI?

--
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

[quoted text, click to view]

Re: am i going crazy or sp_publication_validation is?

Hilary Cotter
8/29/2006 1:53:11 PM

My guess was Deuce Bigalow male gigolo.

--
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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.