How to change Database User's schema to DBO in MSSQL.

  1. Login to SQL Server with Database User Credential.

  2. Right Click on Database and select New Query.

    Database-select

  3. Run the below command.

ALTER USER db_user WITH DEFAULT_SCHEMA = dbo;

Here db_user will be changed by your Database user.

command-fire

Note: Your Database shouldn’t have any table if you are doing this for Nopcommmerce installation.

  • 0 Users Found This Useful

Was this answer helpful?