Remote Stored Procedures

From: Remote server (jay_bukstein_at_hotmail.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 13:26:08 -0700

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?

Relevant Pages

  • Re: User Termination
    ... I guess I was looking to create a stored proc that would do all this. ... multiple servers, ... Finally drop the login using sp_droplogin ... So if any given server has 10 or 12 databases, ...
    (microsoft.public.sqlserver.security)
  • Help with sp_helpmergepullsubscription
    ... This stored proc seems to have started running periodically on one of our ... servers and nobody can determine why. ... We are not using replication and have ...
    (microsoft.public.sqlserver.server)
  • 1 SP -- 2 SQL Servers
    ... What do I need to do to allow 1 stored proc to perform an ... isnert/update/select on 2 physically different servers? ... same LAN. ...
    (microsoft.public.sqlserver.programming)
  • Re: OAB replication issue
    ... The 9175 event usually indicates that the store is not running and or we ... Possible ad replication problems? ... settings, pf settings, smtp settings, etc. ... replications are being sent and recieved by both servers. ...
    (microsoft.public.exchange.admin)
  • Howto move / copy items
    ... one of the FE servers. ... of documents (notes, eml, Word....). ... we have another WSSstore on another FE ... The first attempt used streams to duplicate the items (as per the ...
    (microsoft.public.exchange2000.development)