Hi All,

Please help me, i am in a nice mess due to a problem in dts
export/import.

When i try to export tables from my local server to remote it gives me
this message.


---------------------------
Copy SQL Server Objects
---------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]User does not have
permission to alter database 'robe81'.
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
failed.


---------------------------
OK
---------------------------

though Iam not trying to export any system tables. All tables are user
defined

and iam not trying to alter any database properties.

The permisson which my login has are:

db_securityadmin

db_ddladmin

Tables in my local server are owned by dbo and on remote by user
robe81 with above permissions.

I am wondering why this is happening.

DO any one has any pointers?

Thanks in advance

Ritesh K

I found this note at the bottom of the Books OnLine article for Alter database

Permission
ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These permissions are not transferable

I did not see any of these in your list

Russ Loski, MCS

Use profiler on the destination server to see what commands are failing.
This should help you determine why.

Rand
This posting is provided "as is" with no warranties and confers no rights.