January 22, 2008 at 8:47 am
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
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
He is in the database role db_owner.
January 22, 2008 at 9:45 am
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
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