Search This Blog

Tuesday, July 8, 2008

Remove virus manually which creates autorun.inf and does not opens drive on double click

When a drive is double clicked it checks for autorun.inf file which is executed for autorun. Many viruses create a file autorun.inf in each drive and try to execute their own codes on double click which prevents your drive to open on double click.

Here a tip to remove this error.

Goto your windows system32 directory generally it resides in

C:\WINDOWS\System32>

but the path may differ as you may opt for other name for your windows directory or drive.

now check following command:

.....\system32>dir/ah

It will show all hidden files in the system32 there will be three virus files namely

1. amvo.ex
2. amvo0.dll
3. amvo1.dll

delete all these files using following command.

del amvo.exe/f/ah

del amvo0.dll/f/ah

del amvo1.dll/f/ah

Two files will be deleted on of the dll file may not be deleted as it may be started now. When you will restart your system this file will be deleted automatically if antivirus is installed otherwise again apply same command and delete it.

Thanks.

Thursday, July 3, 2008

Scanning for Viruses using Mcafee SuperDAT

Mcafee SuperDAT engines are freely available on the Mcafee Official Site . So one can download it and save it in any folder say in "c:\sdat".

Now following steps has to be performed for scanning viruses or torjens etc.

1. Restart your system in "Safe mode Command prompt" because it ensures the least services are running on the ststem.

2. Now goto the folder and extract it with following command.

c:\sdat>Sdat5300.exe/e

Note : Engine name may vary because every day or two day new engine is released.

3. It will extract and will be of 19 files . Wait for complete extraction

4. Now start scanning with follwing command.

c:\sdat> scan /AD/All/clean

5. The scanning will be started wait for one or two hour as per your Hard drive capacity and usage.

Now enjoy your computing with virous free computer.

Wednesday, July 2, 2008

Customizing Background of a folder or Thumb drive in MS Windows XP SP2

You may have noticed a file desktop.ini in the system. A few changes in it enables you to set the background of a folder. For this purpose following steps has to be kept in mind for MS Windows XP SP2

1. Make the requisite folder attribute as system by followin command in DOS

attrib +s

e.g

c:\> attrib +s myfolder

2. Create a file "Desktop.ini" in the folder with the content

[{BE098140-A513-11D0-A3A4-00C04FD706EC}]

iconarea_image= image_name_with_path
iconarea_text= color_code

color code like 0x0000FF00


e.g

[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
iconarea_image=C:\Documents and Settings\All Users.WINXP\Documents\My Pictures\Sample Pictures\sunset.jpg
iconarea_text=0x0000FF00



Note: It suports any image like bmp, jpg, png, gif

Now the folder will look like




Searching duplicate Record

Very often we have to look for duplicate records in the database, Below is the query which can give you the result. SELECT COL1, COL2 , ...