In SQL Server 2005, which network protocols use

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

(Continued from previous question...)

In SQL Server 2005, which network protocols use endpoints?

Answer
All of the above

Explanation
All communication points with SQL Server using network protocols use an endpoint. SQL Server creates defaults for each protocol that you enable.

(Continued on next question...)

Other Job Interview Questions

• You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting...
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• What does the SQL Writer service do?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• How many credentials can one login be mapped to?
• What value should you use for the BROKER_INSTANCE parameter?
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• More...