topic Re: Enable archiving on SQL Server enterprise geodatabase feature class causes Invalid Cursor State error in Geodatabase Questions

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

Col_Forbin — Tue, 27 Aug 2019 20:21:02 GMT

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.

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

Col_Forbin — Wed, 28 Aug 2019 12:54:49 GMT

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.

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

Jamie_Leitch_CNF — Mon, 23 Mar 2026 15:53:06 GMT

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.