execute sp_addlinkedserver to add the server to sysservers

Posted on 2007-10-04
Last Modified: 2008-01-09
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
Question by:humer2000
    LVL 8

    Accepted Solution

    Are you using EM to run the DTS? If so, have you register the servers, Source and
    destination? It should be all you need. When you register the server you will need a valid
    user id with SQL Server administration rights (could use sa, but for security
    reasons you should have an account to run this DTS jobs) so the DTS package will run without
    any problems.
    There is a problem with DTS in SQL Server 2000 Service
    Pack 2. Databases with dots in the names will generate the errors you are seeing.
    Rename the destination database so the name does not contain a dot.
    LVL 1

    Author Comment

    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 !
    LVL 1

    Author Comment

    ahh i have noticed something in accordance with what u said
    the db name is

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

    Expert Comment

    by: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.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now