Copy database

• cachafeiro

  SSC-Addicted

  Points: 476

  More actions

  November 13, 2001 at 9:43 am

  #158044

  Hi,

  I'm trying to copy a SQL SERVER 2000 database and I can´t with the following error:

  Transfer Status: Creating Users on destination database

  [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary.

  I tried on the following ways:

  restore backup.

  copy database wizard

  export/import.

  Only using attach database I can copy that.

  It's very odd...

  Thanks a lot

  JAIME

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  November 13, 2001 at 10:10 am

  #420059

  Can you provide more details? Your description only generally states the problem.

  I.e. If you run a restore, what script do you use or what do you check in EM to restore the db? What error exactly is retured? Where is this error from?

  Steve Jones

  steve@dkranch.net