force the closure of the connection to a linked table

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  November 10, 2010 at 2:46 am

  #231327

  Is there any way to force the closure of the connection to a linked table after a query has been executed ? If so what is the relevant T-SQL ?

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  November 10, 2010 at 11:57 am

  #1249095

  is this for MS Access? just set a low timeout value on the server level

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  November 11, 2010 at 2:08 am

  #1249326

  No this is for a SQL Server linked table to a legacy system