We are trying to test the success of Transactional replications. by Googling , i found that i need to execute in our publisher this stored procedure :
However , When i execute :
exec sys.sp_publication_validation @publication=ReplicationFaouzi, @rowcount_only=0, @full_or_fast=0, @shutdown_agent=0
I get this error :
Msg 20026, Level 16, State 1, Procedure sp_MSpublication_validation, Line 57 The publication 'ReplicationFaouzi' doesn't exist ?
When i run this sql :
SELECT publication FROM MSpublications ORDER BY publication
I get in Result :
what is wrong ?
By checking the code of this stored procedure i found that it calls un-found stored procedure sys.sp_MSreplcheck_publish and sys.sp_MSrepl_getpublisherinfo :
exec @retcode = sys.sp_MSreplcheck_publish if @@error <> 0 or @retcode <> 0 begin return (1) end EXEC @retcode = sys.sp_MSrepl_getpublisherinfo @publisher = @publisher, @publisher_type = @publisher_type OUTPUT, @rpcheader = @cmd OUTPUT
sys.sp_MSreplcheck_publish exist under a database named model ,and i can't find sys.sp_MSrepl_getpublisherinfo!!
My Team re-created the replication database and now this sql command:
SELECT [name] FROM sys.databases WHERE is_published = 1;
dosen't return any value , but this :
SELECT [name] FROM sys.databases WHERE is_merge_published = 1;
Now, when i run :
USE [Guichet]; GO EXEC sp_helppublication;
I get nothing !