Post reply

Owner of imported files

  • January 22, 2008 at 8:47 am

    #185949

    We have a user that is using the SQL Server 2000 DTS import Wizard to import Access tables into a database he is DBO of. The problem is all of the table are imported with his user id instead or DBO.

    Anyone have any idea why?

    Thanks.

  • January 22, 2008 at 9:03 am

    #770491

    Is he mapped to DBO or does he have dbadmin rights?

    The tables are still likely created under his name if the former. You can use sp_changeobjectowner to fix this.

  • January 22, 2008 at 9:12 am

    #770496

    He is in the database role db_owner.

  • January 22, 2008 at 9:45 am

    #770531

    Have the user specify the name of the new table as "dbo.tablename" in the Wizard. He/she can do that by clicking the "Edit SQL" button to edit the create statement.

    Greg

  • January 22, 2008 at 9:47 am

    #770532

    OK, thanks very much for the answers.

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

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