Post reply

SQL Server database repliaction/query issue

  • July 29, 2004 at 10:00 am

    #85137

    Hi there,

    We've created a copy of a sql database by:

    1) detaching said database

    2) copying, then renaming the copied database

    3) Attaching the two databases with different names (eg NW and NW2)

    However when we use either database and try and do a query on the table, it renames the table with a _1 on the end (eg Currency becomes Currency_1) and it dosn't show any of the fields available for the table, although the data is still there.

    Help!!

    Regards

    Dave

     

  • August 2, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 15, 2004 at 7:44 am

    #519016

    I think _1 is added because there is another table found with tha same name !!


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • August 21, 2006 at 9:44 am

    #655924

    I'm having the same problem. Was there a final solution found for this?

  • August 21, 2006 at 11:17 am

    #655948

    By saying "renaming the database" what do you mean? Did you only change the name of the files or you changed the name of the database while you're attaching it.

Viewing 5 posts - 1 through 4 (of 4 total)

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