Enable archiving on SQL Server enterprise geodatabase feature class causes Invalid Cursor State error

[Col_Forbin]

I am attempting to enable archiving on a feature class in a SQL Server 2017 enterprise geodatabase using ArcCatalog 10.7.  I get this error when I run the Enable Archiving geoprocessing tool:

[[Microsoft] [ODBC Driver 13 for SQL Server]Invalid cursor state]

What might be causing this error?  I thought it might be a database space issue but the database is set to auto-grow and there is lots of space on the server.

[Col_Forbin · Accepted solution]

Thanks to Esri support, the cause of this was a trigger on the table in the geodatabase.  Once the trigger was disabled, the enable archiving tool ran successfully.

[Jamie_Leitch_CNF]

Just to add another one to this. If there is a DDL trigger on the database and it is not set to "SET NOCOUNT ON" , this error will also occur. Either disable the DDL trigger or alter it to SET NOCOUNT ON.