You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. So what action should you perform to achieve this goal?（）
- AYou should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert
- BYou should modify all logins by using the ALTER LOGIN ... HASHED statement.
- CYou should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.
- DYou should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement.
- EYou should create a policy by using Policy-Based Management. The policy prevents any violation of these rule