change database user's schema

  1. K

    Steps to change Database User's schema in MSSQL

    You can follow below steps: Login to SQL server database. Now right click on particular database and select “New Query” option. After that run this command: ALTER USER db_user WITH DEFAULT_SCHEMA = dbo; Here db_user is your database username.
Top