When testing connectivity in SQL Server, you use

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

(Continued from previous question...)

When testing connectivity in SQL Server, you use which utility in conjunction with the readpipe utility to establish a connection?

Answer
makepipe
Explanation
The makepipe utility is used with the readpipe utility to test connectivity only for named pipes connections. This utility has been deprecated in SQL Server 2005.

(Continued on next question...)

Other Job Interview Questions

• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• How can you determine which Service Broker ports are being used on your server?
• How many users can be added to an application role in SQL Server 2005?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• In SQL Server 2005, which network protocols use endpoints?
• A certificate is like which type of key in SQL Server 2005 encryption?
• You are troubleshooting a Service Broker application ...
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• More...