Click here to Skip to main content
12,396,461 members (36,777 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL SQL-Server
I am using SQL Server 2008 R2.

TEST 1:
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.


TEST 2:
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
Comments
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


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 13 Nov 2012
Copyright © CodeProject, 1999-2016
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