CODEWITHSUNDEEP
sql-serverevent-viewersql-server-2022windows-server-2022
Sandaly KEITA
Sandaly KEITA

Reputation: 9

Problem with the dll (version 1.2) of an extended stored procedure in SQL Server 2022

I'm using SQL Server 2022 (v16.0.4165.4) on Windows Server 2022 Datacenter 21H2 20348.2849.

Our extended stored procedure works 95% of the time, but it occasionally generates overflow errors (BEX64, SQLException64) in the Windows event log.

In the Event Viewer we have an Information Event 1001 from Windows Error Reporting (Event name BEX64). What's strange is that this indicates that there was an error with version 1.1, a previous version of our dll and with version v16.0.4125.3 of SQL Server 2022.

We tried uninstalling the extended stored procedure and SQL Server updates up to version before 16.0.4125.3 but the error remains the same.

Same by deactivating our antivirus or installing our dll in the C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn directory.

When we set up a new server with version 1.2 of our dll, there is no problem. I have more than 100 servers so this is not a feasible solution.

We are looking to add logs to our dll but also to migrate to CLR.

On the other hand, it is absolutely necessary to understand why in the Event Viewer the error information is false.

Do you have any ideas or suggestions?

Upvotes: 0

Views: 47

Answers (0)

Related Questions