July 26, 2005 at 12:44 pm
I have a pc with SQL Server 2000 Personal Edition. I have a stored procedure in my database which send mails using tha command xp_sendmail and I attach csv files. Syntax:
EXEC master..xp_sendmail @recipients = 'ivanips2000@hotmail.com', @subject = 'Test2', @attachments = 'd:\filesSendMail\test2.csv'
When i attach small files, i dont have any problem, it works very well, but when i attach files with size of 2 MB or higher, i get the error:
[Microsoft][SQL Server Driver]Timeout expired.
It's weird because i get an error but it works, the mail is sent completely. My problem is because my stored procedure execute the xp_sendmail several times and the error stop the process.
What can i do to fix this problem????, i'm tired because i have this problem since last week.
July 26, 2005 at 1:38 pm
Reboot your PC. Also make sure to send the attach file that is within the limit of file attachment for your exchange server.
mom
July 26, 2005 at 2:33 pm
I restarted my pc every day, i have some days with this problem. The limit of the exchange problem es big because the xp_sendmail throw an error but it works, the mail is sent. To confirm, i sent a mail through outlook without problems.
What more can be??
July 26, 2005 at 2:37 pm
Sorry, i forgot to tell you the size of the attach file in the mail was 6 MB. This size is bigger than the files that i using in the xp_sendmail (I use files of 3 Mb)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply