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

1

Login to SQL Server with Database User Credential.
Right Click on Database and select New Query.
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.

Get Windows Shared Hosting

Was this answer helpful?

Related Articles

Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver] This error usually occurs when you try to insert or update data in MS Access database i.e. you do... Choosing Between SQL Server 2012 and SQL Server 2014 If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to... Microsoft SQL Server 2016 Recommendation The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the... Where is the database folder for MS-Access database? 'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb... How to Shrink Transaction Logs of Database in MS SQL? This article will assist you to shrink/truncate the transaction logs of the database in MS SQL...

« Back