Skip to main content


Showing posts from August, 2010

Clearing Windows Update Downloads to save space

Problem : You want to delete the updates downloaded by Windows XP from your system to clean up the space.

Solution : Windows XP stores the update downloads at following location. By deleting files from here you can free up the space.


Also you can create a batch file so that you just have to click on it & it will delete the folder contents whenever you want to delete. Copy & paste below code into a notepad, save it as "delete_windows_update_files.bat"

CD %Windir%
CD SoftwareDistribution
DEL /F /S /Q Download

Windows Run Commands

Accessibility Controls- access.cpl
Add Hardware Wizard- hdwwiz.cpl
Add/Remove Programs- appwiz.cpl
Administrative Tools- control.exe admintools
Automatic Updates- wuaucpl.cpl
Bluetooth Transfer Wizard- fsquirt
Calculator- calc
Certificate Manager- certmgr.msc
Character Map- charmap
Check Disk Utility- chkdsk
Clipboard Viewer- clipbrd
Command Prompt- cmd
Component Services- dcomcnfg
Computer Management- compmgmt.msc
Date and Time Properties- timedate.cpl
DDE Shares- ddeshare
Device Manager- devmgmt.msc
Direct X Control Panel (if installed)- directx.cpl
Direct X Troubleshooter- dxdiag
Disk Cleanup Utility- cleanmgr
Disk Defragment- dfrg.msc
Disk Management- diskmgmt.msc
Disk Partition Manager- diskpart
Display Properties- control.exe
Desktop display Properties- desk.cpl
Display Properties (w/Appearance Tab Preselected)- control.exe color
Dr. Watson System Troubleshooting Utility- drwtsn32
Driver Verifier Utility- verifier
Event Viewer- eventvwr.msc
File Signature Verification Tool- sigverif
Findfast- findfast.cpl

SSRS 2005 : Different color for Alternative Rows

Problem : You want each row in your tabular data to have different color, like zibra cross.
Solution :
1. Select the Row
2. Go to Properties
3. in BackgroundColor property Choose, Expression

4. Write in the Expression window :

=IIF((RowNumber("dataset_name") mod 2 =0),"Gray","White")

And you are done. Keywords: SQL Server Reporting Services, SSRS, SSRS Alternative Row Color