Connecting to linked servers..

Results 1 to 2 of 2

Thread: Connecting to linked servers..

  1. #1
    Join Date
    Dec 1969

    Default Connecting to linked servers..

    I am trying to run a query in query analyzer that pulls data in from another server. I ran sp_addlinkedserver and now I&#039;m trying to write the sql.<BR><BR><BR>SELECT * FROM [HUMBOLDT75GRIPANET].[dbo].[DTS]<BR><BR>My Server name is HUMBOLDT75<BR>Database name is GRIPANET<BR>Table name is DTS<BR><BR>Any help would help<BR><BR>Thanks<BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default 4 part naming

    select * from servername.databasename.owner.object<BR><BR>-or in your case<BR><BR>select * from humboldt75.gripanet.dbo.dts

Posting Permissions

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