You administer two SQL Server 2008 instances named Instance1 and Instance2.
A database named Customers resides on Instance1. You move the Customers database
from Instance1 to Instance2.
A SQL Server login named User1 that has the password “111999” is used by a user to
access the database on Instance1. You create the same SQL Server login on Instance2.
The user attempts to access the Customers database on Instance2 by using the SQL Server
login User1. However, the user receives an error message which indicates that the access to
the Customers database is denied.
You need to ensure that User1 can access the Customers database.
Which Transact-SQL statements should you execute on Instance2?
A.
USE Customers; ALTER USER User1 WITH LOGIN = User1;
B.
USE Customers; ALTER USER User1 ENABLE;
C.
USE Customers; ALTER LOGIN User1 WITH PASSWORD = ‘111999’ UNLOCK;
D.
USE Customers; ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;