Friday, March 30, 2012

replication error message in SQL Server 2005 (June CTP)

I upgraded from earlier version of SQL Server 2005 CTP to the June version.
When I try to create a new Publication for Replication (using the Management
Studio), I get the error message:
Invalid object name msdb.dbo.MSdistributiondbs
Yes, I do not have the above table and I don't see any old publications (the
older ones were removed via Publisher Properties). Why does SQL Server think
that I still have some old publications? Where does it store the info? I
don't find any tables like MSDdistribution, MSdistpublishers etc.http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason Manfield" wrote:
> I upgraded from earlier version of SQL Server 2005 CTP to the June version.
> When I try to create a new Publication for Replication (using the Management
> Studio), I get the error message:
> Invalid object name msdb.dbo.MSdistributiondbs
> Yes, I do not have the above table and I don't see any old publications (the
> older ones were removed via Publisher Properties). Why does SQL Server think
> that I still have some old publications? Where does it store the info? I
> don't find any tables like MSDdistribution, MSdistpublishers etc.
>

No comments:

Post a Comment