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?

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?

Accepted Answer

C. ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];

Answer

A. DROP USER [User1];

Answer

B. ALTER SERVER RCLS Isysadmin] ADD MEMBER [Corpnet\User1];

Answer

D. ALTER ROLE [db owner] ADD MEMBBR [Corpnet\User1];

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…

Question

Options

How the community answered

Community Discussion