Which of the following query determine sessions that had an empty scan ?

Question

TuteeHUB · Accepted Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count  0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0

TuteeHUB · Answer

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0

1.	Which of the following query determine sessions that had an empty scan ?
A.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0
B.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0
C.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0
D.	SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0
Answer» B. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

Discussion