Click here to Skip to main content
12,955,170 members (60,442 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I am using SQL Server 2008 R2.

step 1. I create a login user named 'mtcs', just a user ,no database mapping.

step 2. I create a database named 'DBMTCS', and ,I assign the 'mtcs' as owner to database 'DBMTCS'.

step 3. After step1,2, I want change the schema from the User Mapping of the user 'mtcs' ,but can not.

step 1. I create a database named 'DBMTCS', the owner is default.

step 2. I create a login user 'mtcs', than I do the user mapping, I changed the schema of 'DBMTCS'.

step 3. I change the owner of 'DBMTCS', but can not.

Before this test, I just want to create a database which has its own user and schema.Still not complete. so there I have 2 questions:

1.Whats the difference between the database OWNER and login user MAPPING?

2.How to change the schema of the database?

Thanks in advance
Posted 12-Nov-12 22:32pm
digimanus 13-Nov-12 5:48am
an explanation can be found here

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,559
CHill60 3,550
Maciej Los 3,153
ppolymorphe 2,030
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 13 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100