What is wrong with this CREATE LOGIN statement?

CREATE LOGIN users\temp1 FROM WINDOWS MUST CHANGE

 Posted by Bandi on 7/1/2014 | Category: Sql Server Interview questions | Views: 633 | Points: 40
Select from following answers:
  1. needs to use WITH SUBJECT as well
  2. needs to use CHECK POLICY = ON
  3. can’t use MUST CHANGE with a windows login
  4. needs to use the HASHED argument for windows logins
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response