sql server replication: Invalid object name tempdb.dbo.MSdistributor

Invalid object name tempdb.dbo.MSdistributor_access

Jack
8/20/2007 10:20:01 AM

sql server replication:

Hi,
We have a sql server which is being used for replication. A remote user
while trying to sync is now getting the following replication error: Invalid
object name tempdb.dbo.MSdistibutor_access

I have no idea how to troubleshoot this. Any direction/help is highly
helpful. Thanks in advance.

Re: Invalid object name tempdb.dbo.MSdistributor_access

Hilary Cotter
8/20/2007 10:58:21 PM

issue a call to sp_MSrepl_startup and see if this solves the problem.

--
relevantNoise - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]