Solution : https://service.sap.com/sap/support/notes/1294762 (SAP Service marketplace login required)
Summary :
The SCHEMA4SAP.VBS VB-script generates SQL scripts for SAP database configurations on SQL Server, offering schema repair and move functionalities. The schema repair script addresses issues such as incorrect default databases, missing or modified SQL logins, and changes to Windows SIDs, setting proper permissions and default databases. The schema move script facilitates the risky operation of reassigning database objects between schemas, advisable only with expert handling. SCHEMA4SAP is compatible across various SAP NetWeaver and SQL Server releases, and functions without installation on Windows servers from 2003 onwards, ensuring ease of launch and operational simplicity for SAP database administrators.
Key words :
input box appears showing, sql server related settings, sql server management studio, sap system copy guide, schema move script moves, schema repair script corrects, schema repair script fixes, additional input box appears, attached vb-script schema4sap, sql server schema names
Related Notes :
| 1101017 | Log shipping on SQL Server 2005 |
| 610640 | sp_check_sap_login |
| 592514 | MSSQL: internal database users, permissions and security |
| 555223 | FAQ: Microsoft SQL Server |
| 551915 | R/3 won't start after database restore or database copy |