I've taken over a legacy system on SQL 7 that uses XP_SendMail to send out password hints. I've broken down the stored procedure and have found that the queries to select the variables to pass into XP_Sendmail work. However, the stored procedure hangs when executing master..xp_sendmail and the same holds true when I try to execute this via Sql Query Analyzer.
We have an asp page that call the stored procedure to email out the password hint. I am receiving the following error when attempting to use the asp page :
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/email_passhint.asp, line 32
I've extended the timeouts on the query for the file/system dsn and I still receive the same error. The only started happening after we migrated to a new server, which happened to be a windows 2000 server to a windows 2003 server.