Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 The current user is not an owner of the selected d

Author  Topic 

tatau2000
Starting Member

1 Post

Posted - 2007-05-29 : 01:24:15
I have a SQL 2005 question for you. In the SQL server Management Studio. When I right click on the database and use the SQL Server Import and Export wizard, I can import databases but cannot export them.

The error says:

The current user is not an owner of the selected database. This might cause some operations with this database to fail.


I use sa to loginto the server Management Studio, does anyone know how to create a database where the user and owner are the smae so I can export?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-29 : 13:48:12
sa should have all permissions on the server. Who is db owner?
Go to Top of Page
   

- Advertisement -