Which of these is not a parameter you can pass t

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which of these is not a parameter you can pass to the LOGINPROPERTY function?

Answer: IsNTAuth

Explanation: IsNTAuth is not a property you can retrive. You can get IsLocked, IsExpired, IsMustChange, BadPasswordCount, BadPasswordTime, HistoryLength, LockoutTime, PasswordLastSetTime, and PasswordHash.

(Continued on next question...)

Other Job Interview Questions

• You are looking to setup a large Notification Services application...
• What's an allocation unit?
• How many credentials can one login be mapped to?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• What are triggers? What are the different types of triggers in SQL Server 2000?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• Error severity 13 indicates what?
• In replication, what is each set of the source data that is replicated from the source server called?
• More...