Default schema for connection

Solved!
MRvLuijpen
Default schema for connection

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

0 Kudos
1 Solution
Clรฉment_Stenac

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.

View solution in original post

0 Kudos
1 Reply
Clรฉment_Stenac

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.

0 Kudos