Changind schema owner dbo to SIDadm

[Former Member]

Hi All,

After a homogeneous system copy, the schema owner is dbo.

I´d like it to be SIDadm.

Refering to note 551915, the script user_change.sql had been ran on SQL2005, but dbo schema user is coexisting with SIDadm.

Can anyone be a help on this?

Thanks!

Edited by: Saleki Siavauch on Aug 22, 2008 10:03 AM

[Former Member]

> Hi All,
> 
> After a homogeneous system copy, the schema owner is dbo.
> I´d like it to be SIDadm.
> 
> Refering to note 551915, the script user_change.sql had been ran on SQL2005, but dbo schema user is coexisting with SIDadm.
> 
> Can anyone be a help on this?
> 
> Thanks!
> 
> Edited by: Saleki Siavauch on Aug 22, 2008 10:03 AM

I hope you backed up your database.

I think what had happened is, you changed the user and profile parameter from schema "dbo" to "SIDadm" and started the SAP instance right? Because your database now contain objects with same name belonging to the two different schemas.

You need do:

1. Restore your database.

2. Shut down SAP.

3. If you are running 4.7 or older: Run sp_sapdroproc

4. Run the script to change dbo to SIDadm.

5. Start SAP.