Is there any more to the message and what environment or prgramming method were you using to execute (QA, ASP, C#.NET)?

1) Have you tried deleting the account and readding?

2) Try doing so using sp_grantlogin instead then use EM to fix the parameters.

3) Are you using SQL 2000 EM or SQL...

In Windows a files Modified date does not change until the file closes. A database opens and event thou constantly change never closes until the server shuts down or active...

Is that user account a part of any other groups. NT has a most restrictive processing handle. Could be in another group specifically denied.

I would expect if A fails B never runs. But it depends on what A does and B does and if B relies on an ything produced in A.

I would create a job you run your DTS package without (or with if you want to happen periodically anyway) and set the job as owned by the account you...

It will rollback any work it performed.

What is the package doing (step-by-step), could be you are not getting a completion message from an object involved in the process. Had this happen with an earlier version of...

It is available in mine as "Text File".

A cursor is a memory object and as such does store the data in memory. It is not all stored in memory at the same time. In fact creating and opening a...

Constantly? If so look at what queries are running. You may have on or more queries do large data work and bottlenecking on the CPU. But you could also have...

I have not heard anything. Could be their server is on the fritz.

What account is SQL Agent running under. I have had this issue with Oracle myself because the account has to hav rights to use the driver.

I have done this before but many times the included Windows driver cannot work with live databases when they are open and reports as some files are locked.

I have had this happen at least twice to me but mostly after installing updates (OS) or applications and just needed to reboot to clear things up.