In SQL Server 2005, if you initialize a subscrip

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

(Continued from previous question...)

In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?

Answer: In clear text.

Explanation: The password is sent in clear text, which is why a UNC share on a Windows Authenticated server is recommended.

(Continued on next question...)

Other Job Interview Questions

• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• How many users can be added to an application role in SQL Server 2005?
• What is the cost threshhold for parallelism in SQL Server 2005?
• Can you call Notification Services APIs from unmanaged code?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• In a new default SQL Server 2005 installation, what is the status of the dedicated administrator connection?
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• Which framework would you use to manage this database programatically?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• More...