it says that you must specifiy the sender if you have specified SMTP server. aLSO,

if is set as the user user.name@company.com then i get follwoing error:

Failure sending mail:...

Hi,

email admin says that the computer (IP address) has permission to send email with anonymous.

What is going wrong here

Hi,

Here is the issues:

if i set it to anonymous the db mail does not work with error :

The mail could not be sent to the recipients because of the mail...

Hi,

If i do anonymous then i get this message failing:

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2011-11-05T08:27:16)....

Hi,

The DB mail is set to use the basic with my username and password.

Also, I have full rights to send mail on my regular computer and i can send...

Hi,

The OS is Windows 2008 R2 Ent.

Thanks

Hi,

yes. I confirmed with sysadmin, however i have setup same profile on SQL 2005 server and it works fine. I am trying to configure on SQL 2008.

Hi,

If i check the SSL connection option then also fails. Also, Admin have set the anonymous enabled for sending mail.

Thanks

Hi,

So the suggestin would be the make tempdb and log to lets say about 15 G and!!

if so how can i do that.. alter database command?

Please let me know.

thanks

Pat

Hi I have schedule job to do shrink log and db which runs every 2 min. also the message for auto grow shows up every 3 to 4 mins a...

Hi,

They have request to update one table when user access report, but user will inoput certain information on the report or parameter.

Thanks

Pat

Hi

I tried that but got the error saying:

[Execute SQL Task] Error: Executing the query "declare @file nvarchar(255) set @file = ? insert into emailtemp(c1) values (?)" failed with the...

Hi,

I have fname variable define. I can't understand the expression how can i right in express.

is it right.

if count(@[User::Fname]) = 0 then exec send_dbmail?

else exec send_dbmail @body = @[User::Fname]

?

please help

thanks that looks like it worked.

thanks

Paresh

hi,

i did that and getting following error.

I have variable called imp with datatype string and value select sp1 from table where id = '143'

and in sql command exec spname ?...