Post reply

Unable to copy database

  • April 27, 2005 at 10:55 am

    #113769

    I am having an issue I never have come accross. I am importing data into our newly created "test" databases from "production" databases. All are succesful except one. I get this error when I try to import data. "[Microsoft][ODBC SQL Server Driver][SQL Server] The name '1' is not permitted in this context. Only constants, expressions or variables allowed here. Column names are not permitted." Any ideas? I don't know if it is a sp or something else. All the tables came over with no errors.

     

  • April 28, 2005 at 8:57 am

    #555563

    Just a questions:

    Are there any objects that begin with '1' in the database ?

    If so, then it needs to be renamed or escaped ... e.g. N'1 table'

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • April 28, 2005 at 9:00 am

    #555564

    That was it. Thanks.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply