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
