plz help me connet two table in two database

• pegahgolpayegan

  Newbie

  Points: 1

  More actions

  July 19, 2008 at 12:01 pm

  #381798

  i want to connect two table in two sqlserver database 2000 for insert of one to other

  how can? i need script

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 19, 2008 at 12:43 pm

  #845342

  Start by reading Books On Line (BOL)

  URL for linked servers is:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6ef578bf-8da7-46e0-88b5-e310fc908bb0.htm

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  July 19, 2008 at 1:51 pm

  #845350

  INSERT into TargetDB.dbo.OutTable

  SELECT * From SourceDB.dbo.InTable

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]