You administer two SQL Server 2008 instances named Instance 1 and Instance 2. A
database named AdventureWorks resides on Instance1. You move the AdventureWorks
database from Instance1 to Instance2.
A SQL Server login named Mary with the password “Re#99$45” 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 AdventureWorks database on Instance2 by using the SQL
Server login Mary. However, the user receives an error message which indicates that the
access to the AdventureWorks database is denied.
You need to ensure that the user can access the AdventureWorks database.
Which Transact-SQL statements should you execute on Instance!?
A.
USE AdventureWorks; ALTER USER Mary WITH LOGIN = Mary;
B.
USE AdventureWorks: ALTER LOGIN Mary ENABLE;
C.
USE Adventure Works; ALTER LOGIN Mary WITH PASSWORD = ‘Re#99$45’ UNLOCK;
D.
USE AdventureWorks; ALTER LOGIN Mary WITH DEFAULT_DATABASE =
AdventureWorks;