asked on

execute sp_addlinkedserver to add the server to sysservers

Hi experts

I have SQL 2000 SP4

i want to export the customers table in CSV
i followed the export wizard
i selected the source
i select the destination
when i click next i get the follwoing error:

Error Source : Mircosoft OLE DB Provider for SQL Server
Error Description : unspecified error
Could not find v8-pat in sysservers. execute sp_addlinkedserver to add the server to sysservers

context : Error calling getrowSet to get DBSHEMA_TABLES schema info.
Your provider does not support all the schema rowset required by DTS

Please note that my server name is not v8-pat !
please help

ASKER CERTIFIED SOLUTION

Bradley Haynes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

humer2000

ASKER

hi i followed your instructions and still not working
i have same error message
yes i m using EM with sa account
the problem is that my server name is nemesis-26 and in the error message i am getting
Could not find v8-pat in sysservers. execute sp_addlinkedserver to add the server to sysservers
v8-pat is not the server name, not even a db name !

humer2000

ASKER

ahh i have noticed something in accordance with what u said
the db name is v8-pat.com

do u thing the problem is in the DOT with the db name ?

Bradley Haynes

Yes the DOT is a problem. The DOT notation indicates the default db in MySQL, i know special characters are not allowed in SQL Server 2000 db names i.e \,@, and the like.

Here is a link to a document that covers naming conventions.
http://72.14.253.104/search?q=cache:8KuZeftIxgIJ:www.cms.hhs.gov/DBAdmin/downloads/SQLServerStandardsandGuildelines.pdf+sql+2000+naming+rules&hl=en&ct=clnk&cd=3&gl=us