Solution : https://service.sap.com/sap/support/notes/1086375 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues observed in ABAP and Java environments on SQL Server 2005, detailing symptoms like missing tables and views, malfunctioning reports in RSA1 and DB02, errors during Support Packages import, and deployment complications in Java. Predominantly caused by inconsistencies between user ID and schema ID, these issues stem from the differentiation in ownership and schema definition practices between SQL Server 2000 and 2005. Remedies include aligning schema and user IDs using provided scripts, with a comprehensive approach involving system backups, SAP system shutdowns, and running corrective scripts within SQL Server Development Studio for resolution.
Key words :
0][sql server]alter table switch statement failed, //tc/dictionarydatabase/645_val_rel/src/_dictionary_database_dbs/java/, exe [microsoft][sql server native client 10, /sap/dictionary/database/dbs/dbmodificationmanager, database user sap<sid>db, java environment sap<sid>db -, component bc-db-mss, 22 pm sep/26/2007 dbs-info, line set @schematofix = 'prd', sql server development studio
Related Notes :
| 1690835 | MSS: Add. Info. - Software Update Manager 1.0 SP4 |
| 1678749 | R3szchk computes size 0 for all tables and indexes |
| 1656672 | tp getdbobjsize returns size 0 for all objects |
| 1612995 | MSS: Add. Info. - Software Update Manager 1.0 SP3 |
| 1161733 | SQL Server: SAP EHPI for SAP NetWeaver 7.0 |
| 1088859 | Schema id is not equal to user_id |