In a query window I receive a message that it can't find
the store procedure. I can run the store procedure in
query analyzer when logged in directly on that server.
I've even tryed running system store procedures like
sp_helpdb, or sp_who and get the same message 'can't find
stored procedure.'
Too also mention that I can't create these as Link
servers because I have SQL replication running.
Replication creates the other servers as remote servers.
[quoted text, click to view] >-----Original Message-----
>One of the biggest differences is that remote servers
are for
>backwards compatability. You should be using linked
servers if this is
>to access a SQL Server that is higher than version 6.5.
>If there is no error message and no error number, how do
you know you
>are getting errors? If you actually do have error
messages, please
>post the exact error message.
>And what steps did you take to set this up as a remote
server?
>
>-Sue
>
>On Fri, 25 Jun 2004 08:54:59 -0700, "Jay Bukstein"
><jay_bukstein@hotmail.com> wrote:
>
>>No, in SQL 2000, This is Remote Server, not a linked
>>server, it looks like the difference is a remote server
>>is only for other MS SQL server's using native SQL
>>Drivers where link servers a OLE DB providers, and
there
>>is no error number associated with it.
>>
>>I also had no trouble define the Remote server, I just
>>can't execute a remote storder Procedure using the
>>following Query analyzer command
>>exec lax-dd.dbname.dbo.test.
>>
>>Any other ideas.
>>
>>
>>
>>>-----Original Message-----
>>>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?
>>>
>>>.
>>>
>
>.
