Query to Remote LinkedServer

• day-476284

  SSCommitted

  Points: 1844

  More actions

  October 6, 2008 at 9:45 am

  #194386

  Hi,

  I need to call a linkedserver in the remote server.

  Server1 : 64bit SQL 2005

  Server2 : 32bit SQL 2005 + 32BitLinkedServer

  The sproc needs to run in server1 but i cannot create the linkedserver in 64bit due to

  it requires VFPOLEDB 32bit provider.

  Anyone knows if there is any way to do that in T-SQL?

  Thanks everyone,

• day-476284

  SSCommitted

  Points: 1844

  More actions

  October 6, 2008 at 10:11 am

  #881205

  Basicly, I need a query which will run in Server1 to call 32BitLinkedServer in Server2.