Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello Community,
Is it correct that if in a connection no default schema is entered, the default value was 'dbo' previously, but lately it's <username>.
Is this a setting which we can change back to the 'dbo' default value?
Thanks in advance.
Marc Robert
Hi,
If nothing is entered within DSS, the choice of the default schema is up to your SQL Server, as DSS will not be sending any specific command for it. We do not see a reason within DSS that would have caused this to change.
Hi,
If nothing is entered within DSS, the choice of the default schema is up to your SQL Server, as DSS will not be sending any specific command for it. We do not see a reason within DSS that would have caused this to change.