Exit 70-458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Question 1 of 5
0% complete
Q1 Single choice

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?

  • A

    Option A

  • B

    Option B

  • C

    Option C

  • D

    Option D

Previous Next