Hi,

@smtpsrvr is set to a valid mail server address.

i am able to send mails and receive in general.

I did not have from addr mentioned earlier - but then...

hi,

thnx - makes sense.

Hi,

I am still not able to receive the mails - do i have to configure outlook to receive mails from sql server

Let me know.

Thnx.

i tried exec sp_changedbowner 'dbo'

but i get: Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line 33

The login 'dbo' does not exist.

How to change it - such that database...

Hi,

I had it char..... changed it to varchar - in the debugger it shows fine now.

But then i dont get the email notification.

DECLARE @msg int

   DECLARE @to varchar(50)

   DECLARE @from...

Hi,

Chk this sp_help_job

Thnx,

Natalie

Hi,

Thanks for the reply.

But i am still a bit confused on this -

(1) why does this happen if the recovery is set to full.

(2) What if we...