ALTER LOGIN CHECK_POLICY = { ON | OFF }

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

If you have the following below requirements:

1. SQL Server 2008 logins must have the same password complexity rules which are enforced by

Windows Server for authentication.

2. Full compliance of all users with regarding to adhering to the password complexity rules

Answer:

Applies only to SQL Server logins. Specifies that the Windows password policies of the computer

on which SQL Server is running should be enforced on this login. The default value is ON.

ALTER LOGIN CHECK_POLICY = { ON | OFF }

You should consider using the ALTER LOGIN ... CHECK_POLICY = ON statement to change

the entire login of all users.

Create a policy using Policy-Based Management that matches the requirements

Policy-Based Management is a system for managing one or more instances of SQL Server 2008.

When SQL Server policy administrators use Policy-Based Management, they use SQL Server

Management Studio to create policies to manage entities on the server, such as the instance of

SQL Server, databases, or other SQL Server objects.

You can access www.free-online-exams.com for the whole latest version of the exam

Get Oracle Certifications for all Exams
Free Online Exams.com