What is the default TCP/IP port # used by MS SQL

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

(Continued from previous question...)

What is the default TCP/IP port # used by MS SQL Server to receive connection requests?

The default TCP/IP port # used by MS SQL Server to receive connection requests is 1433.

(Continued on next question...)

Other Job Interview Questions

• What is a Stored Procedure in MS SQL Server?
• Does MS SQL Server support IPX/SPX?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• What is the meaning of Data Normalization?
• What does Extend refer to in MS SQL Server?
• What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
• What is a Page in MS SQL Server?
• Is T-SQL language syntax case-sensitive?
• What is the main purpose of assigning a user with the "processadmin" role?
• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• More...