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
Check if it is enabled:
SELECT [name], database_id, is_cdc_enabled  
FROM sys.databases
WHERE is_cdc_enabled = 1
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
Check if table is tracked:
SELECT [name], is_tracked_by_cdc  
FROM sys.tables
WHERE is_tracked_by_cdc=1
Select changes:
select * from [cdc].SchemaName_SourceTableName_CT
Cleanup tracked changes:
EXECUTE sys.sp_cdc_change_job
    @job_type = N‘cleanup’,
    @retention = 2880;  

Open command prompt from any folders context menu

There are many tools that can do that for You, but it easy to make it yourself.

When a user right-clicks a Shell object such as a file, the Shell displays a shortcut (context) menu. This menu contains a list of commands that the user can select to perform various actions on the item. These commands are also known as shortcut menu items or verbs. Shortcut menus can be customized.

What you have to do is just add some registry entry in [HKEY_CLASSES_ROOT\Folder\shell\.

All entries here are responsible for what menus to show when you press right menu button and open context menu for a folder.

Command cmd.exe /K \”cd /d %1\”” will open command prompt and navigate to current folder (%1 will by replaced by folder name You are opening context menu automatically )

More on this here.

Save this to any .reg file and execute it:

Windows Registry Editor Version 5.00

@=”C:\\Windows\\System32\\cmd.exe /K \”cd /d %1\””

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
EnableMenuItem (GetSystemMenu(handle(parentwindow()), FALSE), SC_CLOSE, MF_BYCOMMAND + MF_ENABLED)
End If