when i execute xp_sendmail return the next error: [Microsoft][ODBC SQL Server Driver]Timeout expired

• Ivan Parra

  Old Hand

  Points: 316

  More actions

  July 19, 2005 at 6:31 pm

  #86861

  Im sending mails with xp_sendmail, this use a query to create an attachment, 

  In this query im accessing tables from another server through a link server, some queries works but another complex queries return the next error:

  [Microsoft][ODBC SQL Server Driver]Timeout expired

  I checked the timeout of the link server, is 0 that means unlimited, the remote server in its properties the timeout for remote server connections is 0 (unlimited too), and in the local server the timeout for remote server connections is 0.

  This query if i run it in Query analizer is slow but it works, but in my xp_sendmail command it doesn't work and return the error of timeout expired

  If someone knows something, please help me

• philcart

  SSC-Forever

  Points: 47797

  More actions

  July 19, 2005 at 7:56 pm

  #575699

  It's a bit hard to provide a solution when you haven't provided any details about your environment, table and query design

   

  --------------------
  Colt 45 - the original point and click interface