[SQL Server Data Warehousing] CDC function should generate an error, but doesn't

Eileen,

Your response simply quotes BOL.  I know what the valid values are, and in some way that's the point.  In that BOL article, it says,

"If the specified LSN range does not fall within the change tracking timeline for the capture instance, the function returns error 208 ("An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes."). "

However,  in the above code fragment, I am indeed sending in a value that is not in the correct range (a null for the second parameter), and I'm not getting error 208.  Instead, I'm getting an empty result set.  I expect error 208, per BOL, and I'm not getting it.

Thanks,

Jason

.

social.technet.microsoft.com/Forums