Deprecate Feature Found in sys.sp_cdc_scan

Copper Contributor

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.

BenLin1998_0-1697077302020.png

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

 

0 Replies