dbo login name problem

[Former Member]

Hello,

After copying my R/3 system - detach from the source and attach to the destination i noticed that that the dbo user does'nt have a login name configured.I used the sql stored procedure to attach the copied database as described in note 151603 -

USE master

exec sp_attach_db '<SID>',

'F:\<SID>DATA1\<SID>DATA1.mdf',

'E:\<SID>LOG1\<SID>LOG1.ldf'.

When i attached the DB on the source system the dbo had login name configured - domain\<sid>adm.

Does anyone know why this is happening on the destination system only?

As mentioned above i used the stored procedure sp_attach_db to attach the db in the destination system but used the another methood on the source system - from the enterprise manager - right click on databases ->all tasks->attach DB and here i had the option of configuring the wanted login name.How do i do it using the sp_attach_db stored procedure?

Regards,

Moshe

[clas_hortien · Accepted solution]

Hello,

you have to run the stored procedure

use <SID>

exec sp_changedbowner '<Valid Login>'

after you attached the database with sp_attach_db. It is recommended to use the 'sa' login as the owner, as NT logins may change. But you can use an NT login as well, if you want.

Best regards

Clas