Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unanswered: SQLServer2000- Accessing remote server

    From a stored procedure on server1 and database1 how can I access a remote server and database. Please provide me the command or text that I can use in stored procedure. Does it need any userid and password that can be included in the command?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    8
    You need to register the remote server and configure the security information for the connection. After that you access the server via "server2.database2.dbo.table1"

    In the Enterprise manager Linked Servers on under Security

  3. #3
    Join Date
    Jan 2003
    Posts
    8
    You need to register the remote server and configure the security information for the connection. After that you access the server via "server2.database2.dbo.table1"

    In the Enterprise manager Linked Servers on under Security

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •