You cannot execute procedures on the 2005 server

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

(Continued from previous question...)

You cannot execute procedures on the 2005 server. Why not?

You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not?

Answer:You need to enable RPC.

Explanation: By default, RPC is disabled in SQL Server 2005. You need to set the "remote access option" in your server configuration to 1 to allow the execution of stored procedures from a remote server.

(Continued on next question...)

Other Job Interview Questions

• You restart your SQL Server on a Sunday morning after some maintenance ...
• How many of these servers can you consolidate?
• What T-SQL function can achieve this?
• What is an example of hardware partitioning?
• What T-SQL function can achieve this?
• In SQL Server 2005, what permissions does a user need to successfully execute the USE command?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?
• What type of update did you perform?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• More...