You are the administrator of your company network. You are in charge of two SQL Server 2008 instances respectively named Instance1 and Instance2. On Instance1, there’s a database named Taskgo. Now you migrate the Taskgo database from Instance1 to Instance2. A user uses a SQL Server login named TEX with the password “Re#99$45” to access the database on Instance1.
On Instance2, you create the same SQL Server login. The user tries to use the SQL Server login TEX to access the Taskgo database on Instance2. But the user gets an error message, saying that the access to the AdventureWorks database is denied. Now you must make sure that the user is able to access the Taskgo database.So which Transact-SQL statements should you execute on Instance2?
A.
USE AdventureWorks;ALTER LOGIN Mary ENABLE;
B.
USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary;
C.
USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = ‘Re#99$45’ UNLOCK;
D.
USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;