Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    165

    Unanswered: Stored procedure to access another database...

    Hi. I'm trying to write a stored procedure that will access another database on a different server. How can I set this up in a stored procedure? It is a SQL Server 2000 database and it will be using SQL server authentication. Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Check out Linked Servers and also four part naming conventions in Books Online. All the details and more are in those topics

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    be careful about cross server joins though. those will kill your perf.

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    look at openquery and openrowset functions.

Posting Permissions

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