Description
Suggest removing and schema qualifiers on SQLSERVER objects inthe installation scripts - leav it to the user to define whether they want to use dbo or another schema.
For example I have a single SQLSERVER database with multiple schemas (mimicking hte oracle install), I also have to modify the contents of the C_DB_FULLSCHEMA filed in the ***_DB_LOOKUP tables plus ensure the invidual users have access to the schema.
But removing the dbo qualifier from the install scripts allows the user more flexibility.
For example I have a single SQLSERVER database with multiple schemas (mimicking hte oracle install), I also have to modify the contents of the C_DB_FULLSCHEMA filed in the ***_DB_LOOKUP tables plus ensure the invidual users have access to the schema.
But removing the dbo qualifier from the install scripts allows the user more flexibility.