DBA > Job Interview Questions > Microsoft SQL Server FAQs

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