【多选题】
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. <br /> So what action should you perform&en
A、You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert
B、You should modify all logins by using the ALTER LOGIN ... HASHED statement.
C、You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.
D、You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement.
E、You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules
查看正确答案
