Hi there,
I've set up a replicationprocess which runs smoothly. Now I wish to check things and start using the sp_publication_validation, as described in BOL. BTW, I am aware that I can run validationcheck in EM; I've done this and these actions perform without problem.
However, when running sp_publication_validation it ends with the error:
Server: Msg 20026, Level 16, State 1, Procedure sp_publication_validation, Line 58
The publication 'Northwind_Pub1' does not exist.
So I copy this procedure and generate it in Pubs as usp_publication_validation and add some PRINT lines to see where things go wrong. I find the statement and run it isolated like this:
declare @publish_bit int
set @publish_bit = 1
select * from master..sysdatabases
where name = 'Northwind' collate database_default
and (category & @publish_bit) = @publish_bit
I can see, that not the PUBLICATIONNAME is demanded, but the db-name, so I apply the db_name Northwind with this statement. And it returns the proper info! When I run the stored procedure now, it ends with the same error.
Am I doing something wrong here? What do I miss? Is this a known bug, of which I klnow nothing?
Any help apreciated,
Hans Brouwer
I've set up a replicationprocess which runs smoothly. Now I wish to check things and start using the sp_publication_validation, as described in BOL. BTW, I am aware that I can run validationcheck in EM; I've done this and these actions perform without problem.
However, when running sp_publication_validation it ends with the error:
Server: Msg 20026, Level 16, State 1, Procedure sp_publication_validation, Line 58
The publication 'Northwind_Pub1' does not exist.
So I copy this procedure and generate it in Pubs as usp_publication_validation and add some PRINT lines to see where things go wrong. I find the statement and run it isolated like this:
declare @publish_bit int
set @publish_bit = 1
select * from master..sysdatabases
where name = 'Northwind' collate database_default
and (category & @publish_bit) = @publish_bit
I can see, that not the PUBLICATIONNAME is demanded, but the db-name, so I apply the db_name Northwind with this statement. And it returns the proper info! When I run the stored procedure now, it ends with the same error.
Am I doing something wrong here? What do I miss? Is this a known bug, of which I klnow nothing?
Any help apreciated,
Hans Brouwer