TROUBLE WHERE RESTORING A DATABASE

  • Hi, i have a db called BDinformix , The table's owners from this DB are : security and informix. When i take a backup from the db BDinformix to antoher computer running the same version of SQL Server, i could restore the db, but i forget to create the users (security and informix) before the restore (i made this after restore, so i couldnt delete the users from db). So if i want to make a query like :

    SELECT * FROM table1

    the server says "unknown object 'table1'" , but if i write

    SELECT * FROM informix.table1

    it works!! , so i was thinking "if i delete the users from Security->Logins and if I delete the db, i could do the process again , but i will create the users before restore the db, it will sure works " . But, it didn't work. I've been searching the web but nothing yet (i'm still searching) so any help would be a great healp for thi very very newbie

    Thanks a Lot

    Fred Lankovich

  • See BOL for sp_addlogin example E.

    Basically create you Informix login on your new box so that it is identical to the Informix login on your old box.

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

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