Hi Bhuvnesh,

Not sure theres anything more in the logfile, that I haven't shared before... But as I'm looking for some help:-D

I highlighted in bold where I believe the SQLAGENT...

Hello Robbert & Bhuvnesh,

Thanks again for your responses.

Bhuvnesh: Other SQL jobs owned by the same job owner (which failed) - work fine. In fact the only failure I'm seeing is...

Hi Robbert,

Thanks for your comment. Unfortunately the owner of the job already has 'master' set as its default database...

Andy

My apologies - the post got away from me....

The SQL logfile shows:-

Login failed for user.....

Error: 18456, Severity: 14, State: 16

I'm assuming that the SQL job couldn't connect due to the...

Thanks Roshan.

I'm not sure that trailing space will always be present. I had assumed as the syntax is support by T-SQL, it would also work in Profiler:rolleyes:

Thanks again for your...