Removing supervisor password (SVP) on ThinkPad T42

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…

Continue Reading

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 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;  

Continue Reading

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…

Continue Reading

End of content

No more pages to load

Close Menu