Recently received two ThinkPad T42 laptops ( some company decided to upgrade its IT and were giving away them almost for free ). After turning them on got an 271 error and later was prompted to enter password. It seems battery was dead on both of those laptops and when its dead, real time clock goes bananas and you are asked for supervisor password to set the clock again ( if supervisor password was set ). Offcourse nobody knew anything about what password it was. So had to figure it out myself how to solve this situation. On ThinkPad T42 SVP password is stored on EEPROM chip 24RF08. One thing that sometimes work and was reported by many T42 users is to short pins 3 and 4 of 24RF08, procedure: Short pins 3 and 4 of 24RF08, keep them short Tun on ThinkPad Press F1 to go to BIOS If asked for password press enter Go to Security - Passwords - Supervisor password Release shorted pins Enter new password, save and reboot. Then go to BIOS again and disable SVP password by entering the password you just saved. Like they say - "it worked on my two t42 machines" ;)
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 GO Check if table is tracked: SELECT [name], is_tracked_by_cdc FROM sys.tables WHERE is_tracked_by_cdc=1 GO Select changes: select * from [cdc].SchemaName_SourceTableName_CT Cleanup tracked changes: EXECUTE sys.sp_cdc_change_job @job_type = N'cleanup', @retention = 2880;
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 [HKEY_CLASSES_ROOT\Folder\shell\CMD\command] @="C:\\Windows\\System32\\cmd.exe /K \"cd /d %1\""