The process cannot access the file because it is being used by another process. [SQLSTATE 42000] (Error 22022). The step failed.

  • In Sql server 2005 dev edition observing the followed error.

    SQLServerAgent Error: The process cannot access the file because it is being used by another process. [SQLSTATE 42000] (Error 22022).

    Earlier the below script executed without error .From few days we are observing this error. Sql agent is running fine.

    EXEC dbo.sp_cycle_agent_errorlog ;

    GO

  • The error message indicates the SQL Agent error logfile is locked by another proces. This proces could be for example an Anti-Virus application. When this error occurs you can use "Proces Explorer" from sysinternals to examine all processes using a specific file.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply