You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and
uses the mixed authentication mode. Management wants you to ensure the following:
* SQL Server 2008 authenticated logins has the same password complexity rules which are enforced by Windows Server 2000.
* Full compliance of all users with regarding to adhering to the password complexity rules.
What should you do? (Choose TWO)
A.
You should consider using the ALTER LOGIN … CHECK_EXPIRATION = OFF statement to change the entire login of all users.
B.
You should consider using the ALTER LOGIN … CHECK_POLICY = ON statement to change the entire login of all users.
C.
You should consider using the ALTER LOGIN … CHECK_POLICY = OFF statement to change the entire login of all users.
D.
You should consider developing an SQL Server Agent job which implements to raise an alert, if triggered by a violation by any user.