Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot get the column information
Message
From
28/03/2008 15:12:18
 
 
To
28/03/2008 14:41:01
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Miscellaneous
Thread ID:
01306583
Message ID:
01306594
Views:
3
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform