Hi there,

I have a similar goal expect I dont have a UID. I thought I could just do a select into via a db link but it doesn't like it...

so...

Tried a reboot but no joy.

My issue is if I change the job owner the if fails to connect to the server using the database link and I get the...

http://support.microsoft.com/kb/241643/

I've been using this link but still cant get my jobs to work. I've changed the job owner to sa and it still fails.. have also restarted...

thats a bit easier than oracle.

Thanks very much,

so just set a verible and hard coded it?

Hi there,

New to sql server... So I found a 2gb database with a 45gb transaction log. The backup mode is full but its showing no backup of the transaction log.

So...

I dont know how I missed that one, works really well. I might try add a backup componet also.