Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohan_praja
Starting Member
5 Posts |
 Posted - 2009-02-19 : 23:20:53
|
| HI everyone,i m new in sql server. i have created profile in database mail. and i configure that mail and successfully send too. i m sending a mail using job. then i received a mail (with attachment) also but i cant received a larger attachment mail(1 mb). then i see the database mail log the error displays like that. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2009-02-18T12:20:12). Exception Message: Cannot send mails to mail server. (The operation has timed out.). )"so whats the solution for that ??? please help me.............. |
|
|
rohan_praja
Starting Member
5 Posts |
Posted - 2009-02-20 : 03:20:02
|
| hi everyone,please Reply me.. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 16:39:23
|
| Here is what BOL says:[ @file_attachments = ] 'file_attachments'Is a semicolon-delimited list of file names to attach to the e-mail message. Files in the list must be specified as absolute paths. The attachments list is of type nvarchar(max). By default, Database Mail limits file attachments to 1 MB per file. |
|
|
|
rohan_praja
Starting Member
5 Posts |
Posted - 2009-02-20 : 22:40:55
|
| hi Sodeep, thanks to giving me reply . here in scrip i wrote the declare @filename nvarchar(max) then in sp_dbmail @file_attachments = @filename,it will be fine ? i m generating a report through query in pdf,excel. so the report is generated and attach with it. is it fine??? |
|
|
|
|
|
|
DataBase Mail