You are the SQL administrator for your company. You have installed SQL Server 2008 on two Windows Server2008 computers.
You create a new database named Research for the research department on the SQL Server2008 instance named SQL_production.
You have been asked to ensure that all SQL logins created for the research department employees meet thefollowing criteria:
? The logins should be able to issue commands within the Research database without specifically includingthe database name in the command.
? The Windows Server 2008 password policies and password expiration should be enforced for the SQLlogins.
? The account should create a temporary password and force the user to reset the password.

You decide to create a template account to use to create all the research department accounts.
You plan tocreate a CREATE LOGIN script from the template account for future use.
You open the SQL Server Management Studio, and open the SQL_production instance.
Then you right-click the Security folder, point to New , and select Login.
On the General page, you type Template in the Login namebox.
exhibit What else should you do? (Choose all that apply. Each correct answer represents part of the solution.)