What is the quickest way to get them working?

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

(Continued from previous question...)

What is the quickest way to get them working?

You have just installed a 64-bit SQL Server 2005 instance and want to move all your SQL Server 2005 data to this new instance. You wish to migrate your DTS packages, but they do not seem to run. What is the quickest way to get them working?

Answer: Rewrite them using SSIS.

Explanation: There is no 64-bit support for DTS packages. They must be rewritten in SSIS on a 32-bit computer and compiled for 64-bit execution.

(Continued on next question...)

Other Job Interview Questions

• Can you call Notification Services APIs from unmanaged code?
• On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?
• What is the granularity in seconds of the timestamp datatype?
• A certificate is like which type of key in SQL Server 2005 encryption?
• You cannot execute procedures on the 2005 server. Why not?
• In Full-Text Search, what is word breaking?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• Which of the following statements best describes the filter capabilities of Report Builder?
• In SQL Server 2005, which network protocols use endpoints?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• More...