Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI set up a linked server and attempt the following command: exec serverX.dbX.dbo.procX I get this message: Server 'serverX' is not configured for RPC. This used to work in the beta version of 2005. Running a select still works: select * from serverX.dbX.dbo.tableX The help file is worthless since it tells me to use a linked server... Anyone have an idea what I am missing???
Post Follow-up to this messageGo back to the properties of 'serverX' linked server. On the 'Server Options' properties sheet, select the RPC (from the server) and RPC out (to the server) check box. "cathedr@wa.state.gov" wrote: > I set up a linked server and attempt the following command: > exec serverX.dbX.dbo.procX > I get this message: > Server 'serverX' is not configured for RPC. > This used to work in the beta version of 2005. > > Running a select still works: > select * from serverX.dbX.dbo.tableX > > The help file is worthless since it tells me to use a linked server... > Anyone have an idea what I am missing???
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread