Microsoft
70-458 · Question #88
You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add the [Corpnet\User1] login to the database. However, you receive the following error…
The correct answer is C. ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1]. See the full explanation below for the reasoning.
Question
You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add the [Corpnet\User1] login to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [Corpnet\User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions. Which Transact-SQL statement should you use?
Options
- ADROP USER [User1];
- BALTER SERVER RCLS Isysadmin] ADD MEMBER [Corpnet\User1];
- CALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];
- DALTER ROLE [db owner] ADD MEMBBR [Corpnet\User1];
How the community answered
(55 responses)- A5% (3)
- B9% (5)
- C82% (45)
- D4% (2)
Community Discussion
No community discussion yet for this question.