You wish to initialize subscribers to your SQL S

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

(Continued from previous question...)

You wish to initialize subscribers to your SQL Server 2005 database using FTP. Which versions can you do this with?

Answer: SQL Server 2005 and SQL Server 2000 subscribers only.

Explanation: You can only do this with SQL Server 2005 or SQL Server 2000 subscribers. SQL Server 7 subscribers are not supported through FTP.

(Continued on next question...)

Other Job Interview Questions

• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What the heck does ATN2 do?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• You restart your SQL Server on a Sunday morning after some maintenance ...
• When creating a SQL Server 2005 Service Broker message type, what does the EMPTY validation option mean?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• Which framework would you use to manage this database programatically?
• What does this code return? select 6 | 7 Figure it out without running it.
• More...