Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2009-08-24 : 23:42:02
|
| Hi,Is it possible to use a distributed query to execute a stored procedure on another SQL server without using RPC?I have one dev server and production server. now, i want to execute a stored procedure which is there on prod from dev server.What are the ways we can accomplish this task??I tried with Linked Server but it throwing me an error RPC not configured for the target server.EXEC [ServerName\SQL_01].ADVENTUREWORKS.DBO.TEST_SPMsg 7411, Level 16, State 1, Line 1Server 'ServerName\SQL_01' is not configured for RPC. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-08-25 : 05:08:43
|
| So why not configure RPC? |
 |
|
|
|
|
|
Execute stored proc residing on diff sql server