Discussion:
am i going crazy or sp_publication_validation is?
(too old to reply)
Koni
2006-08-29 16:00:27 UTC
Permalink
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

on MSSQl 2005 (9.0.1399)
Hilary Cotter
2006-08-29 16:52:40 UTC
Permalink
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
Post by Koni
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
@publication = 'OpeiDev'
on MSSQl 2005 (9.0.1399)
Koni
2006-08-29 17:28:35 UTC
Permalink
Post by Hilary Cotter
This should work. However what is ManStud GUI?
Management Studio
Hilary Cotter
2006-08-29 17:53:11 UTC
Permalink
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
Post by Koni
Post by Hilary Cotter
This should work. However what is ManStud GUI?
Management Studio
t***@gmail.com
2013-04-02 17:18:25 UTC
Permalink
I am having the same issue. Were you ever able to figure out what caused the issue?
Post by Koni
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
@publication = 'OpeiDev'
on MSSQl 2005 (9.0.1399)
Loading...