RE: Link

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andras Jakus (andras.jakus_at_vodafone.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 00:36:09 -0800

HI,

Create stored procedure on Linked server:

CREATE PROCEDURE Test
AS
select col1, col2 FROM SERVER.DB.dbo.TABLE WITH (NOLOCK)

-----------------------------------------------------------------------------

Change the select statement to following:
EXECUTE [Linked Server].[Database].[Owner].[Test]

JBandi

Relevant Pages

  • calling stored procedure from c#
    ... My Noddy Stored Procedure ... PROCEDURE TEST (pCUR1 OUT CUR, ...
    (comp.databases.oracle.server)
  • Re: Informix stored procedure
    ... > I need to create a stored procedure, but keep getting a syntax error. ... > create procedure test() ...
    (comp.databases.informix)
  • Re: Copy Table Data via StoreProcedures
    ... If you are hung up on a stored procedure do something like this ... create procedure test as ... > How can I easily copy the data from one table of a SQL Database another ...
    (microsoft.public.sqlserver.replication)
  • Passing NULLs into stored procedures
    ... I have a bit of troubles using Null's that has been passed into a stored procedure. ... CREATE PROCEDURE test ... This returns no records even though some of the myColumn are NULL. ...
    (microsoft.public.sqlserver.programming)
  • Re: User-Defined Function
    ... It doesn't even have to be this elaborate with a linked server. ... Declare @line varchar ... suitable extended stored procedure. ... > server setup and an example of how to get directory information (but not ...
    (microsoft.public.sqlserver.programming)