Timeout on SP across Linked Servers

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  June 22, 2004 at 3:35 am

  #85306

  Ignore this post.

  Administrators or moderators, please delete.

• vbenus

  Ten Centuries

  Points: 1053

  More actions

  June 22, 2004 at 3:46 am

  #511359

  Hi,

  try to exec simple query from Server A to Server B and reverse

  (on ServerB: select * from ServerA.master.dbo.sysobjects,

  on ServerA: select * from ServerB.master.dbo.sysobjects)

  So you can check where is problem (on server A or Server B).

  Try to check msdtc is running on both servers.

  Also you can check remote query timeout via sp_configure.

  I hope something useful

  ---

  Kindest Regards,

  vbenus