Change the Schema in Sql 2005
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) ?
Refer to OSS Note 551915 R3 wont start after database restore or database copy!
Run this script and your issue should be resolved!