Tips for Preventing Laptops from Overheating ...

           You must have noticed that your laptop getting hotter and hotter when you touch it after leaving it on for a few hours this is because laptop's fans are netorious for collecting dirt, dust, and other chemicals in the air. So here   are some tips and tricks that help you to cut down heat issues and keep your laptop breathing better.

• Put your laptop on a cooling rack (like the ones for baking). This alone allows your laptop's bottom to breath better and circulate air flow in a more effective manner.
• Use a can of air on your vents every few months or so. This will help to expell out the dust and prevent dirt from clogging up the inside of your computer.
• Don't leave your laptop on a bed or couch. Because the laptop sinks in to the bed, the ventilation system can't do it's job and keep the laptop cool enough to operate.
• Durring high pollen seasons, limit the time you use your laptop outdoors. These particles are nasty and clog up systems faster than anything else.
• Avoid smoking near computers. This will cause nicoteine build up on your fans and burn them out. And a burnt out fan disables your computers ability to keep it self cool.
• Consider investing in a USB powered laptop cooler. 
• Put your computer into standby when your not using it. The less the computer is on, the less heat it will generate and prevent it from over heating.

Avoiding risk factors can keep your laptop in great shape and around for many more years to come!

Courtesy : www.tipstechtricks.com/

SQL Server 2000 : installation, Backup & Restore

SQL Server 2000 : 

Installation, Backup & Restore: Click to View

&

Backup SQL Query

Local Backup: BACKUP DATABASE <DBNAME> TO DISK = 'DriveName:\FolderName\<DBNAME.BAK>' For Eg. Database name = 'TEST' BACKUP DATABASE TEST TO DISK = 'E:\BACKUP\TEST.BAK'

Network Backup: BACKUP DATABASE <DBNAME> TO DISK = '\\SystemName\SharredFolderName\<DBNAME.BAK>' For Eg. Database name  = 'TEST' BACKUP DATABASE TEST TO DISK = '\\System1\BACKUP\TEST.BAK'

By using this 2 line you can create query for all databases in a single query

How to Backup Database SQL Server

How to Backup Database in SQL Server using Enterprise Manager Maintenance Plan Wizard (SQL 2000)

1. Open SQL Enterprise Manager.

2. In the console tree under Microsoft SQL Servers --> SQL Server Group --> DB_Server Name --> Management, right-click Database Maintenance, then select New Maintenance Plan.

3. When the Database Maintenance Plan Wizard appears, click Next.

4. In the Select Databases dialog box, select These databases, then select the user database and deselect the system databases: master, model, and msdb. The name of the user database is the name of the Backup_test database. The default name of Backup_test databases is Backup_test_, where is the name of the Backup_test server.

5. Click Next. The Update Data Optimization Information dialog box appears.

• Select Reorganize data and index pages.
• Select Change free space per page percentage to, and type 10 as the percentage.
• Select Remove unused space from database files.
• Schedule the data optimization tasks to execute during off-peak times. Click Change to change the default schedule.

6. Click Next. The Database Integrity Check dialog box appears.

7. Select Check database integrity and Perform these checks before doing backups.

8. Click Next. The Specify the Database Backup Plan dialog box appears.

9. Schedule the database backup tasks to execute during off-peak times. Click Change to change the default schedule

10. Click Next. The Specify Backup Disk Directory dialog box appears.

11. Select Use the default backup directory.

12. Click Next. The Specify the Transaction Log Backup Plan dialog box appears.

13. Select Back up the transaction log as part of the maintenance plan and Verify the integrity of the backup when complete.

14. Schedule the transaction log backup tasks to execute during off-peak times. Click Change to change the default schedule.

15. Click Next. The Specify the Transaction Log Backup Disk Directory dialog box appears.

16. Select Use the default backup directory.

17. Click Next three times. The Completing the Database Maintenance Plan Wizard dialog box appears.

18. Click Finish.

Most Common Computer Problems and their Solutions

Task Manager Disabled: Note:DO SCAN YOUR MACHINE WITH A GOOD ANTIVIRUS. BECAUSE THIS PROGRAMS DON'T TURNED OFF BY HIMSELF OR AUTOMATICALLY. IT HAS TO A VIRUS EFFECT OR A ADMINISTRATOR HAS TO MANUALLY DISABLE THIS PROGRAMS.Using Group Policy Editor - for Windows XP Professional to Enable Task Manager. * Click Start, Run, type gpedit.msc and click OK. * Navigate to this branch: User Configuration / Administrative Templates / System / Ctrl+Alt+Delete Options / Remove Task Manager * Double-click the Remove Task Manager option. * Set the policy to Not Configured. Enable RegEdit [It is not tested] REGEDIT4 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersio n\Policies\System] "DisableRegistryTools"=dword:00000000 Save the text file as any name u with extension .reg example:- "enable.reg" After that double click to run the file.

I can't see Hidden files/folders in my computer. Even I enable the option "Show hidden files/folders" in "Tools -> Folder Options", its automatically disabled again. Solution1: Go to your Start menu, click on Run and open up your Registry Editor by typing "regedit" without the quotes and pressing OK. Once there go to: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Folde r\Hidden\SHOWALL Delete the value CheckedValue. (Its type should be REG_SZ and data should be 0 or 1.) Create a new DWORD value called CheckedValue (same as above, except that the type is REG_DWORD) by right clicking on the right pane->New->DWORD Value. Modify the value data to 1 (0x00000001). Solution 2: Open regedit and goto: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced In right-side pane, change value of "Hidden" to as following: 1 - To show hidden file 2 - To not show hidden files If it doesn't work, then scan your computer with an anti-virus software.

Restore Deleted Recycle Bin Icon from Desktop: Method #1: 1. Right-click an empty area of your desktop 2. Select Properties 3. Click the Desktop tab 4. Click the Customize button 5. Click Restore Default 6. Exit all windows and restart your computer Method #2: Note: Be sure to make a backup copy of your registry prior to making any changes. Go to Start>> Run. Type in: regedit [Enter] Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Desktop\NameSpace Hold the mouse on NameSpace and right-click once. From the resulting menu, select Edit>> New>> Key Copy and Paste the following Key code (including the brackets): {645FF040-5081-101B-9F08-00AA002F954E} Press Enter on your keyboard, exit the registry editor and restart your system.

Blank User Accounts Applet : Problem: When you double-click User Accounts applet in the Control Panel, the User Accounts applet opens, but it may be completely blank. The buttons Back | Forward | Home are displayed in the dialog. Resolution: To resolve the problem, type these commands from Start, Run dialog: regsvr32 jscript.dll If that does not help, execute the following commands as well. regsvr32 nusrmgr.cpl regsvr32 /i mshtml.dll

Force windows XP to reboot upon crashing: This registry edit will cause your system to reboot itself automatically upon crashing. This can be useful if you have a reason for keeping your system on 24/7: Open REGEDIT Navigate to 'HKEY_LOCAL_MACHINE\SYSTEM \CurrentControlSet\Control\CrashControl' Edit the 'AutoReboot' value to '1'

Stand By Icon Disabled: Problem: I reinstalled my windows and now "Stand By" option is Grey out in shutdown dialog box and I can't use it. Sol: Install VGA drivers from your motherboard CD and the option will be enabled. If you don't have the motherboard CD, then go to the manufacturer site and download the required drivers.

Improving the Slow Boot up time: There are a variety of reasons why your windows XP system would boot slowly. Most of the times it this has to do with the startup applications. If you would like to speed up the bootup sequence, consider removing some of the startup applications that you do not need. Easiest way to remove startup apps is through System Configuration Utility. Go to Start then Run and enter MSCONFIG and go to the Startup tab. Deselect/UnCheck application(s) that you do not want to startup at boot time.

Regedit Disabled By Admin: Open Notepad pad, copy paste the following text to the note pad:: REGEDIT4 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersio n\Policies\System] "DisableRegistryTools"=dword:00000000 Save the text file as any name u with extension .reg example:- "enable.reg" After that double click to run the file.

Double-clicking any drive opens search option: Solution 1: That's a virus named as ravmon.exe and autorun.inf Scan first with a good antivirus [Nod32 Recommended] then try this trick. First show the hidden files and folders options then try this method 1. Go to Start-->run and type cmd then click ok 2. If u want to remove the infected file from c drive then type C: in command prompt and press enter 3. Type autorun.inf and press enter autorun.inf file is opened 4. Now type "attrib autorun.inf -s -h -r" and press enter 5. Now delete the file by typing "del autorun.inf" and press enter 6.Now type autorun.inf and press enter now, u will find no infected autorun.inf file. 7. same way do for all other drives then restart your pc

I accidentally deleted my "mspaint.exe"/"notepad.exe"/etc. file, how can I get it back? Solution:: You can use any of following methods: A. Goto "%windir%\System32\DLLCache" folder and look for the file, if its there then copy it to "%windir%\System32\" folder. B. Insert your Windows Setup CD and goto "I386" folder. Now look for the same file, it'll present there but the last letter of extension will be "_". e.g., u'll get "mspaint.ex_"/"notepad.ex_"/etc. Now open Command Prompt and goto "I386" folder and give following command: expand mspaint.ex_ mspaint.exe expand notepad.ex_ notepad.exe etc. Now u can copy the file to "%windir%\System32" folder. C. Give following command in Command Prompt: sfc /scannow It'll automatically restore the files.

When I right-click on Start button and select "Open", a "Copy To" or "Move To" dialog box opens automatically. Solution: Open regedit and goto: Code: HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers\ Now under this key, delete following 2 keys: Copy To Move To

Windows is showing some wrong icons of files. How can I reset the corrupted icons? Solution: You can use any of following methods: A. Download TweakUI and then click on "Repair Icons" in "Repair" section. B. Open My Computer and goto: C:\Documents and Settings\User_Name\Local Settings\Application Data Replace C:\ with your system drive and "user_Name" with your username. Now there'll be a HIDDEN file "iconcache.db", delete it and restart your system.

A strange process "ctfmon.exe" always runs in background and if I click on "End Process" button, it restarts automatically. Solution: Open Control Panel and goto Add/Remove Programs list. Now click on the Microsoft Office entry and then click on "Change" button. Now select "Add/Remove Features" and click on "Next". Now expand "Office Shared Features" and click on "Alternative User Input" and then select "Not Available" and finally click on Update. It'll permanently remove that ctfmon.exe and your problem will be solved.

My Windows Login Screen has changed to "Classic Logon Box". I want the new Welcome Screen back. Solution: Type "control userpasswords" in RUN dialog box or Open "User Accounts" in Control Panel. Then click on "Change the way Users log on and off". Now check the option "Use Welcome Screen". If you get following error: Uninstall client services for netware. Then Open "Network Connections" and open Properties of your Internet Connection. Now goto "Networking" tab and select "Client services on Netware" option and click on the "Uninstall" button

Whenever I start my computer, Scandisk starts running even I proper shut down the PC last time. Solution: Do as following: A. Open regedit and goto: Code: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager In right-side pane, change the value of BootExecute to: autocheck autochk * B. If the above trick doesnt help then give following commands in Command Prompt: chkntfs /x drive_name for e.g., if ScanDisk runs automatically for C: and D: drives, then give following commands one by one: chkntfs /x C: chkntfs /x D:

When I start my computer, I get error message: "Windows\System32\config\system" file missing or corrupt Solution:: Boot using Windows Setup CD and enter into "Recovery Console" by pressing "R". Now Log into windows installation and enter admin password. Now give following commands at prompt: copy %windir%\Repair\system %windir%\System32\Config If it doesnt work, then again boot into "Recovery Console" and give following commands: fixmbr bootcfg /scan bootcfg /rebuild fixboot

Visit  : http://mrsupport.blogspot.com/  for Latest Technical Updates

Delete downloaded files and Browsing History

Due to privacy and security concerns, most people wish to delete their surfing history and files from their computer. It also prevents problems due to virus , spyware and increases the computer speed. Usually this is simple, but at times you can face problems.  

How to delete websites visited from Internet Explorer/ browser history

To clear your history from Internet Explorer :

1. Click Tools and Internet Options on the drop down menu,

2. Click on the General Settings tab.  

3. In the temporary internet files section , Click "delete cookies" (to delete cookies in cache)

4. Then click on  "delete files" . This deletes the html pages and images you download that Internet Explorer saves on your hard disk. Deleting files may take time, if  you have visited many websites. Wait till all the files are deleted, interrupting will cause partial deletion of files.

5. Then go to the history section, first "clear history" . Then set the "days to keep pages in history" at "0" . Click on apply to save this setting

6. Then click on "settings" , select "view files" click on top of page "edit" then click on "select all" then click on selected files, then click on "delete".  There should be no files if step 4 has been done properly

7. Click on the General Content tab in the Internet Options menu.

8. Under Personal information, click on the AutoComplete box. 

9. Uncheck "Web Addresses", "Forms" and "User Names and Passwords on Forms".

10. Click on "Clear Forms" & "Clear Passwords"

11. Click in the "Advanced" tab.

12. Go to the Security section and check "Empty Temporary Internet Files Folder When Browser is Closed" (This essentially does steps 3 and 4 every time you close your browser)

To clear your history from Mozilla Firefox:

1. Go to the "Tools" menu.

2. Select "Options" > "Privacy" > "History."

3. Click on "Clear." To completely disable the history function, set "Remember visited pages for the last X days" to zero ("0"). 4. Click "OK" to exit.
or Firebox * Either press Ctrl+Shift+Del or Click Tools=>Clear Private Data.
* To permanently stop saving data that you entered in search and form fields :
Goto to Tools=>options=>Privacy=>Saved... uncheck the "Save Information As I enter in Form and Search Fields"
your search or form entries will not appear anymore.

Google Toolbar :

 To clear your search history from the drop-down text box on the Google Toolbar:1. Click on the 'Google' logo to access the drop-down menu.
2. Select the 'Clear Search History' option. This will clear all the previous searches from the drop-down box.
All you recent searches on the toolbar will be cleared

This should be used only by experienced users, since making a mistake could damage your computer and you will lose all data
To delete the search tool in the start menu, Go to Start >> Run >> Type in REGEDIT
Navigate to the HKEY_CURRENT_USER \ Software \ Microsoft\Search Assitant\ACMru
Your actual search list is kept there. Delete the actual text used for your searches, nothing else.

Other options for cleaning traces of online activity are CCleaner  (Free)

10 Tips for Securing your PC

1. Update / patch ALL your software every now and then!

2. Check / adjust ALL your settings so they are safe, since they ARENT by default!

3. Use firewall, like ZoneAlarm!

4. Use good passwords: at least 13marks long, containing both letters and numbers. Remember to chance your password every few months atleast!

5. Get good anti-virus & Spyware softwares and keep it updated!

6. Don’t open or execute files that you are not 100% sure are absolutely safe no matter where or how you get them.

7. Wipe your historyfiles (like cookies, internet history and temporary files, etc.), logs and personal files, with specific wiping program (like Eraser) instead of just deleting them.

8. Use encryption to enhance your privacy! Use encrypted email (like Hushmail or Ziplip) and encrypt sensitive files on your computer (PGP).

9. Don’t use public computers for anything you need to type in your logins, they usually have Trojan horses that capture your passwords.

10. Don’t assume anything. If you don’t know, find out! If you cant or don’t understand, ask someone who knows! There’s nothing more dangerous than doing something you don’t really know anything about. That’s the best way to cripple your system or get a Trojan horse on your computer!

What’s the IP Address of my Router?

⇒ Trace IP Address whatismyipaddress.com

1) Enter IP Address 2) See location, ISP & more

Whether you are looking to upgrade the firmware of your existing router or need to further secure your Wireless network with an even stronger password, you first need to know the exact IP address of the router in order to access the various settings.

Now the default IP address of most routers is either 192.168.1.1 or 192.168.0.1 but in some cases - see example - you might have changed the default IP address at the time of installation and unfortunately, you do not remember that value any more.

Not a problem. There are at least two easy ways by which you can quickly determine the IP address of your router.

Option #1 – Go to Start –> Run and enter the following command in the Run box.

Cmd /k ipconfig

The IP address listed under “Default Gateway” is your router’s IP address

Option #2 – Open the Run box again and type the traceroute command as shown below:

md /k tracert http://mrsupport.blogspot.com

The IP Address listed at the first hop in the traceroute log is your router’s IP address.

If nothing works, you might have to reset the router to factory defaults and this will change its IP address back to 192.168.1.1 (Google the name of your router model for the exact value). 

Regsvr32 in Windows

In Microsoft Windows Operating Systems, “regsvr32” is a command-line utility used for registering and un-registering OLE controls like DLLs and ActiveX controls in the Windows Registry. For example – a DDL, to be used with regsvr32, must export the functions DllRegisterServer and DllUnregisterServer. This tool may require troubleshooting some problems in Windows, Microsoft Internet Explorer, or other programs.

Regsvr32.exe is incorporated in Microsoft IE 3.0 or later, Windows 95 OSR2 or later and Windows NT 4.0 Service Pack 5. Regsvr32.exe is either installed in System folder of (Windows Me / Windows 98/Windows 95) or System32 (Windows NT/Windows XP/Windows Vista/Windows 7) folder.

Regsvr32.exe Usage:

1. RegSvr32.exe command-line options:

Regsvr32 [/ u] [/ n] [/ i [: cmdline]] dllname

2. Parameters:

• /u   : It will unregister the file.
• /s   : Runs regsvr32 silently and does not display any message boxes.
• /n   : doesn’t call DllRegisterServer. This option should be used with /i.
• /i :cmdline : It calls DllInstall passing it an optional [cmdline]. When used with /u, it calls dll uninstall.
• dllname: Specifies the name of the dll file that will be registered.

For example, to manually register and unregister a DLL file shm.dll, we can do the following in CMD:

• regsvr32 shm.dll for registering a file.
• regsvr32 /u shm.dll for uninstalling a file.

Remove Write Protection On USB Pen Drive or Memory Card or iPod

problem in copying files on their USB portable devices like pen drives, memory card and iPod etc.

§  Cannot copy files and folders, drive is write protected

§  Cannot format the drive, drive is write protected

§  The disk is write protected

§  Remove write protection or use another disk

§  Media is write protected

Some times people say that suddenly their drive become write protected and they are not able to delete any files and folder on the drive and also not able to copy new files and folder to USB portable drive.

Let’s see how can you remove write protection on your portable devices like pen drives, memory cards, iPod and other USB mass storage devices.

Fix:

Write Protection on any portable USB Device can be applied by the physical lock provided on the card adjuster or some times provided on the pen drives, so make sure to make your drive not write protected by moving the lock in right direction.

But even after moving the physical lock for write protection the problem can happen due to some virus action. This happens when some virus or script which applies the registry hack to make any drive write protect when connected to the computer, In that case follow the procedure below to remove write protection from your pen drive.

1. Open Start Menu >> Run, type regedit and press Enter, this will open the registry editor.

2. Navigate to the following path:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies

Note: If the registry key StorageDevicePolicies key does not exist, you will need to create it

Download this batch file called add.bat from here, and double click after download the key will beautomatically added to registry.

3. Double click the key WriteProtect in the right pane and set the value to 0 in the Value Data Box and press OK button

(value 1 to Write protect the USB Pendrive)

4.Exit Registry, restart your computer and then again re-connect your USB pen drive on your computer