Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Change the Schema in Sql 2005

Hello Experts,

We have refreshed our QAS system from PRD (abap + java) system. The schema on the system is MCOD (IE SID). Although the database has come up, but in SAP we are not able to access the schema because the schema currently belongs to PRD system.

I have looked at OSS note 551915 but this script is valid for Sql 2000. We have Sql 2005.

Also, I have looked at a couple of scripts but that have not worked on our scenario to convert the scema.

Can anyone share and paste the Alter schema script to convert all the tables both for (SAPPRDDB and PRD) ?

Please Help!

Thanks,

Antarpreet

Former Member
Former Member replied

Hello,

Refer to OSS Note 551915 R3 wont start after database restore or database copy!

Run this script and your issue should be resolved!

Thanks!

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question