You administer a SQL Server 2008 instance that runs on a Windows Server 2003 computer.
The instance uses mixed authentication mode.
You need to ensure that the SQL Server 2008 authenticated logins follow the same
password complexity rules that are enforced by Windows Server 2003. You also need to
ensure that the password complexity rules continue to be enforced.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
Use the ALTER LOGIN … HASHED statement to modify all logins.
B.
Use the ALTER LOGIN … CHECK_POLICY = ON statement to modify all logins.
C.
Use the ALTER LOGIN … CHECK_EXPIRATION = ON statement to modify all logins.
D.
Use Policy-Based Management to create a policy that prevents any violation of these
rules.
E.
Create an SQL Server Agent job that runs periodically to raise an alert if a rule violation is
detected.