Sounds like you may have messed up replication. Check the status's of the SQL Server replication agents to make sure they're all working and report no errors.
>In our process of migrating our data to SQL Server, I am running the script, based on the new backup, on a daily basis. After several successful run, I found today that I cannot run the script. It says:
>
>"Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "MYLINKEDSERVER".
>
>When I show the Execution plan, it says:
>
>Msg 208, Level 16, State 1, Procedure sp_MSrepl_check_server, Line 28
>Invalid object name name 'msdb.dbo.MSdistpublishers'.
>
>I am trying to figure out what could have changed since the last run.
>
>Anyone would have any idea on what is causing this?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05