Track Data Changes (SQL Server)

Works for SQL Server starting with 2008. Enable change data capture for a database: EXEC sys.sp_cdc_enable_db GO Check if it is enabled: SELECT [name], database_id, is_cdc_enabled   FROM sys.databases WHERE is_cdc_enabled = 1 GO Enable change data capture for a table: EXEC sys.sp_cdc_enable_table @source_schema = N‘dbo’, @source_name= N‘MyTable’, @role_name= NULL, @filegroup_name = N‘CDC’, @supports_net_changes = 0 […]

PowerBuilder, disable system menu`s close button

ulong ll_parent_hwnd ulong ll_sys_menu_hwnd ulong ll_sys_menu_close_flags ulong ll_ret n_cst_numerical u_num ll_parent_hwnd = Handle(this.parentwindow()) ll_sys_menu_hwnd = GetSystemMenu(ll_parent_hwnd, FALSE) ll_sys_menu_close_flags = GetMenuState(ll_sys_menu_hwnd, SC_CLOSE, MF_BYCOMMAND ) ll_ret = u_num.of_bitwiseand(ll_sys_menu_close_flags , MF_DISABLED) ib_close_prev_enabled = (ll_ret = 0) If ib_close_prev_enabled Then EnableMenuItem (ll_sys_menu_hwnd, SC_CLOSE, MF_BYCOMMAND + MF_DISABLED + MF_GRAYED) End If   And to enable it later: If ib_close_prev_enabled Then […]