DTS - SP from a client connection

#1

Hi,

When I execute an SP in a connection defined on a remote server from my
machine, it runs locally on my machine.

I am confused - shouldnt the sp run on that server with my machine as the
client?

#2

Depends. What does the following mean:

Quote:

I execute an SP in a connection defined on a remote server from my
machine
What are you using to execute the stored procedure? They

can't execute in a connection so I'm not sure what task or
tool you are using to execute this.
What's defined where?
If you could give steps on what is configured where and how
someone else could walk through and reproduce the issue -
step by step-, that would probably make it easier for
everyone to help you out on this.

-Sue

On Tue, 6 Apr 2004 13:23:37 -0700, "Arun"
<aganesan (AT) esurance (DOT) com> wrote:

Quote:

Hi,

When I execute an SP in a connection defined on a remote server from my
machine, it runs locally on my machine.

I am confused - shouldnt the sp run on that server with my machine as the
client?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS - SP from a client connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS - SP from a client connection - 04-06-2004 , 03:23 PM

Re: DTS - SP from a client connection - 04-06-2004 , 07:40 PM