Sql Server Default Schema cant be set

0
6

its a reqular issue while restoring and creating login for the restored database, say if we are restoring a database db1 with login name db1 and if there is a schema named db1

scenario in detail

1. database : db1

2. Login name : db1

3. schema : db1

 

Image

Please dont check server admin , setup admin, sysadmin, if not checked default schema will be treated as dbo , to take another schema uncheck security roles by keeping public only

SHARE
Previous articleWebsite domain names: any suffixes could be possible after landmark vote
Next articleGoogle Voice Search
abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.

LEAVE A REPLY

Please enter your comment!
Please enter your name here