 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / August 2006am i going crazy or sp_publication_validation is?
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) This should work. However what is ManStud GUI?  SignatureHilary 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 > 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 [quoted text clipped - 12 lines] > > on MSSQl 2005 (9.0.1399) > This should work. However what is ManStud GUI? Management Studio My guess was Deuce Bigalow male gigolo. SignatureHilary 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 >> This should work. However what is ManStud GUI? >> > Management Studio |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.