Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Renaming Database

    I got an MSSQL database which I'm trying to export to MySQL using DTS, the name of the database is and when I try to export the tables I get the following error:

    Error Source: Microsoft OLE DB Provider for SQL Server
    Error Description: Unspecified error
    Could not find server '' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
    Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema required by DTS.
    My guess is that since the database name ends with .com DTS is thinking that it's a server and not a db...... I got 2 databases that end with .com and a few others that don't, if I try to export any of the ones that end with .com I get the same error, but if I try to export another one it works just fine.... My question is, is there any way I can rename the database to something else or is there any other way around this problem..?

    Thanks in advance,

  2. #2
    Join Date
    Oct 2001
    sp_renamedb will rename a database.

    Have you tried []

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts