Re: Remote Stored Procedures
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/25/04
- Previous message: Remote server: "Remote Stored Procedures"
- In reply to: Remote server: "Remote Stored Procedures"
- Next in thread: Jay Bukstein: "Re: Remote Stored Procedures"
- Reply: Jay Bukstein: "Re: Remote Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 19:06:53 -0600
When you get errors and are having problems troubleshooting
those, it's always a good idea to post the error numbers and
the exact error messages.
Anyway....I'm guessing the problem is that you need to set
up a linked server to the other remote SQL Server. See the
books online topic: OLE DB Provider for SQL Server
You can also find more information in books online under
sp_addlinkedserver
-Sue
On Thu, 24 Jun 2004 13:26:08 -0700, "Remote server"
<jay_bukstein@hotmail.com> wrote:
>I have a stored proc on a server called lax-dd and the
>stored proc name is test. Both servers are in the same
>domain and the sa passwords are the same on both servers.
>
>I in query analyzer run exec lax-dd.dbname.dbo.test.
>
>I get errors it doesn't understand the dash(-) in the
>servername. I've tried placing the string in quot and
>have problems finding the store proc...
>
>Any ideas?
- Previous message: Remote server: "Remote Stored Procedures"
- In reply to: Remote server: "Remote Stored Procedures"
- Next in thread: Jay Bukstein: "Re: Remote Stored Procedures"
- Reply: Jay Bukstein: "Re: Remote Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
