Help needed

• cutespn

  SSCommitted

  Points: 1669

  More actions

  August 5, 2003 at 10:25 pm

  #101608

  hi,

  i have two databases says A and B,A resides in my local machine and B resides in remote machine. I need to write a

  SP to query Db B but it should reside in database A.

  thnx in advance.

  sudheer.

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  August 6, 2003 at 1:50 am

  #468756

  You will need to set up a linked server (in Enterprise Manager) and then you can query a remote database:

  select *

  from [remote_server].[database_name].[owner].[table_name]

  If you fully qualify it with the remote server name then you can use it as you would any other database.

  Jeremy