Fix : SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (LogToTableWrite)

SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (LogToTableWrite)

I find that error message was continously logged into SQLAgent.out file for every one second, to troubleshoot this:

First verify are there any jobs that are very frequently running thru SQL Agent.

Verify that Job Step properties and click on advanced and verify whether Log to table check box is selected or not

If it is selected click on view button and verify you can see the same message into that table.

If you observe the same message then uncheck that check box and save the job