You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2.
A database is relocated from one instance of SQL Server 2008 R2 to a different instance. A
ABC.com user previously accessed the database using specific credentials, and would like to
make use of those same credentials to access the database.
Which of the following actions should you take?
A.
You should consider making use of the ALTER USER Transact-SQL statement that includes
the WITH LOGIN argument.
B.
You should consider making use of ALTER DATABASE Transact-SQL statement that includes
the WITH LOGIN argument.
C.
You should consider making use of the CREATE LOGIN Transact-SQL statement.
D.
You should consider making use of the CREATE USER Transact-SQL statement.
Explanation: