Forum Discussion
BenLin1998
Oct 12, 2023Copper Contributor
Deprecate Feature Found in sys.sp_cdc_scan
Hello,
I was trying to resolve deprecated feature of SQL Server in my application. And a deprecated feature sysdatabases was found when I execute sys.sp_cdc_scan. Here is the screenshot of the event session.
Please confirm if sys.sp_cdc_scan uses deprecated feature, if yes, please fix it. Thank you.
I create the event session with following script:
CREATE EVENT SESSION [Deprecated and Discontinued 5] ON SERVER
ADD EVENT sqlserver.deprecation_announcement(
ACTION(sqlserver.client_app_name,sqlserver.client_connection_id,sqlserver.database_name,sqlserver.nt_username,sqlserver.sql_text)),
ADD EVENT sqlserver.deprecation_final_support(
ACTION(sqlserver.client_app_name,sqlserver.client_connection_id,sqlserver.database_name,sqlserver.nt_username,sqlserver.sql_text))
ADD TARGET package0.event_file(SET filename=N'Deprecated and Discontinued 5',max_file_size=(1000))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO
No RepliesBe the first to reply