Re: Linked server execution plans

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Charles J Ryan (charlesryan1_at_msn.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 14:07:13 -0500

"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:e8RoPK7iEHA.340@TK2MSFTNGP10.phx.gbl...
> Having a stored procedure on the linked server, and calling it using
> 4-part
> name acceptable in this case?
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
>

Unfortunately no.

The server being linked to does not support stored procedures.

Relevant Pages

  • Re: T-SQL is not quite there yet
    ... StoredProc1 does the same thing to insert data from StoredProc2. ... I assume a lot of this has to do with that the linked server may not ... SQL Server instance, one could surely wish that SQL Server had special ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked Server
    ... SQL instance to be able to delegate on your behalf to the 2nd SQL Server ... [Create Linked Server Object on Middle Server] ... set up its login to use delegation. ...
    (microsoft.public.sqlserver.server)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)
  • Re: MAS90
    ... To set up a linked server from SQL Server 2000 to MAS90 using Enterprise ...
    (comp.databases.ms-access)
  • Re: Support team security
    ... to view Linked Server properties (this is a tool requirement not a SQL ... Jasper Smith (SQL Server MVP) ... SQL Server Agent Job Schedule and Job history ...
    (microsoft.public.sqlserver.security)