Microsoft
70-458 · Question #98
You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add a SQL login, [User1], to the database. However, you receive the following error…
The correct answer is B. Option B. 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 a SQL login, [User1], to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [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?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(42 responses)- A5% (2)
- B71% (30)
- C17% (7)
- D7% (3)
Community Discussion
No community discussion yet for this question.
