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?