Sql Server RSS

• • Reply
  

  Prem Kumar

  0 Points

  1 Post

  Sql Server

  Aug 26, 2010 07:02 AM|LINK

  I want a get the datas of a particular column from a table of a different database server from a database on selecting a table in another server.
  

  • Moved by anas on Aug 26, 2010 09:28 AM
• • Reply
  

  nareshguree2...

  Star

  11118 Points

  1997 Posts

  Re: Sql Server

  Aug 26, 2010 10:21 AM|LINK

  if you want to query with multiple database then you need to use query with database owner

  like

  select * from DatabaseName.DBO.TableName a inner joint

  DatabaseName2.DBO.TableName2 b on a.id= b.id

   

• • Reply
  

  jsd24

  Participant

  1380 Points

  255 Posts

  Re: Sql Server

  Aug 26, 2010 12:31 PM|LINK

  use  Openrowset Command in SQL

  refere this link

  http://jsdideas.blogspot.com/2010/07/openrowset-command-in-sql.html

  
  

  Mark As Answer
  

  ---

  
  
  My Blog : http://jsdideas.blogspot.com
• • Reply
  

  raghav_khung...

  All-Star

  32835 Points

  5563 Posts

  MVP

  Re: Sql Server

  Aug 26, 2010 01:02 PM|LINK

  First you need to make linked sever please refer :

  http://www.execsql.com/post/Linked-Servers-in-SQL-Server-2005.aspx

  Raghav|My Articles|My Blog
  
  • Marked as answer by Hong-Gang Chen - MSFT on Sep 02, 2010 10:43 AM
• • Reply
  

  shashankgwl

  All-Star

  18926 Points

  3662 Posts

  Re: Sql Server

  Aug 26, 2010 01:09 PM|LINK

  http://technet.microsoft.com/en-us/library/ms190479.aspx
  

  http://msdn.microsoft.com/en-us/library/aa259589%28SQL.80%29.aspx
  

  
  

  SHASHANK BHIDE
  All is well if it runs well.
  blog