FROM SQL2005 TO SQL2005

• day-476284

  SSCommitted

  Points: 1844

  More actions

  September 24, 2008 at 10:58 am

  #191410

  Hi,

  I need to pull data from REMOTE_SERVER (WebSite Server)

  "Security" and "Performance" wise, which one solution below is better solution?

  QUERY:

  SELECT field1, field2, field3, ...

  FROM [REMOTE_SERVER].[Catalog].dbo.[Table1]

  WHERE field1 = @param

  1) Create "ConnectionString" in the local application to connect to REMOTE_SERVER.

  AND call sproc in the remote server.

  2) Create a LinkedServer to REMOTE_SERVER

  Thanks everyone,

  /Sel

• day-476284

  SSCommitted

  Points: 1844

  More actions

  October 6, 2008 at 9:18 am

  #881148

  I still could not solve this problem.

  Any thoughts?

• nary

  SSCrazy

  Points: 2869

  More actions

  October 6, 2008 at 9:43 am

  #881173

  Performance wise OPENQUERY is little more efficient .