Showing posts with label CDC function should generate an error. Show all posts
Showing posts with label CDC function should generate an error. Show all posts

Thursday, April 11, 2013

[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

Tuesday, April 9, 2013

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


When I execute this following code, the null as the second parameter to the get_all_changes function should generate an error back to the user.  However, it doesn't.  It just returns an empty result set.  If I don't have a where clause, it does generate the expected error.  Does anyone know why this behaves in this manner?



SELECT *
FROM cdc.fn_cdc_get_all_changes_dbo_Table1(0x01, null, 'all')
WHERE
CAST(sys.fn_cdc_is_bit_set(1, __$update_mask) AS int) >0

Thanks,


Jason



.

social.technet.microsoft.com/Forums

Monday, April 8, 2013

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


When I execute this following code, the null as the second parameter to the get_all_changes function should generate an error back to the user.  However, it doesn't.  It just returns an empty result set.  If I don't have a where clause, it does generate the expected error.  Does anyone know why this behaves in this manner?



SELECT *
FROM cdc.fn_cdc_get_all_changes_dbo_Table1(0x01, null, 'all')
WHERE
CAST(sys.fn_cdc_is_bit_set(1, __$update_mask) AS int) >0

Thanks,


Jason



.

social.technet.microsoft.com/Forums

Friday, April 5, 2013

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


When I execute this following code, the null as the second parameter to the get_all_changes function should generate an error back to the user.  However, it doesn't.  It just returns an empty result set.  If I don't have a where clause, it does generate the expected error.  Does anyone know why this behaves in this manner?



SELECT *
FROM cdc.fn_cdc_get_all_changes_dbo_Table1(0x01, null, 'all')
WHERE
CAST(sys.fn_cdc_is_bit_set(1, __$update_mask) AS int) >0

Thanks,


Jason



.

social.technet.microsoft.com/Forums

CDC function should generate an error, but doesn't


When I execute this following code, the null as the second parameter to the get_all_changes function should generate an error back to the user.  However, it doesn't.  It just returns an empty result set.  If I don't have a where clause, it does generate the expected error.  Does anyone know why this behaves in this manner?



SELECT *
FROM cdc.fn_cdc_get_all_changes_dbo_Table1(0x01, null, 'all')
WHERE
CAST(sys.fn_cdc_is_bit_set(1, __$update_mask) AS int) >0

Thanks,


Jason



.

social.technet.microsoft.com/Forums

Search This Blog