1. in SqlServer Agent Service startup acoount must be the same as  Startup Sql Service account

2. You must logon Windows with this account

3. You must define profile  for this user...

Thank you, David, for guick reply. Unfortunately, you idea doesn't give me desired result. I need to receive in

Enterprise manager  in Users :

in field 'Name' - dbo

in field 'Login...

Thank you, David, for guick reply. Unfortunately, you idea doesn't give me desired result. I need to receive in

Enterprise manager  in Users :

in field 'Name' - dbo

in field 'Login...

Thank you very much for your help.

How are users of Active Directory sending email?

We use by Exchange for sending email.

Thank you very much.

Both versions work fine.

I have only one question.

Why do you use

(RIGHT(run_time + 1000000,6)

or

right('00' + CAST((next_run_time/10000)         as varchar(2)),2) ?

I tested and it worked fine without all these...

Thanks evebody.

You realy help me. 

creating a UDF for returning several rows into one row

Somebody posted this nice solution earlier:

create function ValList ( @anID VARCHAR(5) ) returns varchar(500) as

BEGIN

DECLARE @retval VARCHAR(500)

SET @retval...

May be it wikk help

declare @STR varchar(30)

set @STR='First Middle Last'

select left (@str,CHARINDEX(' ',@str)),

substring(@str,CHARINDEX(' ',@str)+1, charindex (' ',@str,CHARINDEX(' ',@str)+1) -...

thanks for help