Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Server 2022

Sandaly Keita 0 Reputation points
2025-01-20T15:17:25.4266667+00:00

SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849

Our Extended Stored Procedure works 95% but it occasionally generates overflow errors (BEX64) 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 16.0.4125.3 of SQL Server 2022.

We tried uninstalling 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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,437 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,662 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.