thanks everyone,We found the problem.The service account which starts the service,password expired.The account was created wrongly to expire.Restarted service and everything is working again.

the security is "be made using the login's current security context"

i will check the sql logs for an error message something like you sayid.Because the jobs is still...

the excel .xls file is dropped in a shared folder every day and then I need to add the branch name and code to each line.

thanks I will give this one a try.Permission is handled by our sysadmin department on the moment and I want to double check.I also do not have access to go...

Thank you very much,denied the user also alter database and create database.Just to make sure they do not get access through any other group.

hi

I have added the logging now.But I can not find any truncation.

This is a part of the log file

hi

how do I implement that,sorry I am still learning.

thanks it worked,I can see the linked server now

thank you,I will go and try that now and let you know if it worked.

Thank you.I will try that out today and report back to you

will try that and report back

the thing is,they only need to view the job and the history of the job and not make any changes to the job.Like edit the schedule or add or delete...