Extended stored procedures registered with sp_procoption do not work in sql server 2022.

승규 김 0 Reputation points
2023-11-21T05:35:39.05+00:00

If you register an extended stored procedure with sp_procoption in the sql 2022 server, an error occurs when the DB starts and the dll file cannot be loaded. (normal in sql server 2019 and sql server 2016)

However, when the extended stored procedure is called after DB starts, it is executed while loading the dll file normally.

What's even more strange is that even if you register an extended stored procedure with 'return true', which has no function, the same error occurs in SQL Server 2022.

===========================

sql server log

===========================

11/22/2023 09:42:53,spid41s,알 수 없음,* Location: specproc.cpp:20248

11/22/2023 09:42:53,spid41s,알 수 없음,*

11/22/2023 09:42:53,spid41s,알 수 없음,* 11/22/23 09:42:53 spid 41

11/22/2023 09:42:53,spid41s,알 수 없음,* BEGIN STACK DUMP:

11/22/2023 09:42:53,spid41s,알 수 없음,*

11/22/2023 09:42:53,spid41s,알 수 없음,* *******************************************************************************

11/22/2023 09:42:53,spid41s,알 수 없음,***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt

11/22/2023 09:42:53,spid41s,알 수 없음,**Dump thread - spid = 0<c/> EC = 0x0000023D0B5E3D10 Connection = 0x0000023D0B5E3CA0

11/22/2023 09:42:53,spid41s,알 수 없음,Using 'dbghelp.dll' version '4.0.5'

11/22/2023 09:42:53,spid41s,알 수 없음,CImageHelper::Init () Version-specific dbghelp.dll is not used

11/22/2023 09:42:53,spid18s,알 수 없음,Launched startup procedure 'init_func'.

11/22/2023 09:42:53,spid18s,알 수 없음,Recovery is complete. This is an informational message only. No user action is required.

11/22/2023 09:42:53,spid30s,알 수 없음,Service Broker manager has started.

11/22/2023 09:42:53,spid30s,알 수 없음,The Database Mirroring endpoint is in disabled or stopped state.

11/22/2023 09:42:53,spid30s,알 수 없음,The Service Broker endpoint is in disabled or stopped state.

11/22/2023 09:42:53,spid20s,알 수 없음,The tempdb database has 4 data file(s).

11/22/2023 09:42:53,spid52,알 수 없음,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

11/22/2023 09:42:53,spid52,알 수 없음,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

11/22/2023 09:42:52,spid52,알 수 없음,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

11/22/2023 09:42:52,spid20s,알 수 없음,Starting up database 'tempdb'.

11/22/2023 09:42:52,spid32s,알 수 없음,Starting up database 'msdb'.

11/22/2023 09:42:52,spid30s,알 수 없음,Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.

11/22/2023 09:42:52,spid20s,알 수 없음,Clearing tempdb database.

11/22/2023 09:42:52,spid30s,알 수 없음,Always On: The availability replica manager is starting. This is an informational message only. No user action is required.

11/22/2023 09:42:52,spid18s,알 수 없음,Server name is 'WIN-0MQEJ9QV349'. This is an informational message only. No user action is required.

11/22/2023 09:42:52,spid18s,알 수 없음,SQL Trace ID 1 was started by login "sa".

11/22/2023 09:42:52,spid18s,알 수 없음,XE session 'telemetry_xevents' started.

11/22/2023 09:42:52,spid18s,알 수 없음,XE session 'system_health' started.

11/22/2023 09:42:52,Server,알 수 없음,The SQL Server Network Interface library co

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
{count} votes