There is no manipulation. It is a straight import.

There are just 4 jobs that fail. The common point between them is they import data from text files.

I have tried stopping starting the agent / sql services. Tried to...

Multiple accounts is definitely an option...

Can you provide more information on how you integrated SSRS with Windows SMTP?

Long story short

An MX record or Mail exchanger record is a type of resource record in the Domain Name System (DNS) specifying how Internet...

You need the account to have access on AD to read and write SPN at the very least...

This will generate an SSPI error on SQL Server 2000 but on SQL...

The service account doesn't have have privileges over the file. Is there a work-around on this?

I tried both NTFS and share permissions to the agent account, but that didn't help either. I don't want to give either service Local Administrator privileges.

Any other suggestions...

is there a way to identify users that haven't logged in to SQL Server for n days?

I got off the phone with Microsoft and this is a KNOWN BUG with SQL Server 2005 SP1. This has been fixed in SP2. The only change you may have...

If you need a job to check if your database is in Suspect mode every 30 minutes, you might want to do some rethinking of how your database is setup.

Yelena,

If you see the trace script i have posted in the previous page, the problem is that the filters are not working as expected.

On SQL 2000, the trace picks...

Can you post the events and filters? Do different event categories need to be created on different traces for this to work?

TIA

Has anyone seen this URL. It says this is a bug in SQL 2005.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=258393

Does anyone know any work arounds?

If the agent logs cycle each time you restart it then schedule a Windows job to do that every week or however often you think it is necessary

These are agent logs and not error logs. It seems to me like 260GB of logs is unusual and this is the only server that i have had this problem...