Posts

Showing posts from March, 2010

Windows Hot Fixes

Windows Search Doesn't Work: ============================== Follow these steps to try to solve this problem. 1. Click Start > Run and type regsvr32 wshom.ocx 2. Click Start > Run and type regsvr32 jscript.dll 3. Click Start > Run and type regsvr32 urlmon.dll Restart the computer and try to search. It should work with no problems. No Folders/Directory showing in USB Pen/Flash Drive: ========================================= No windows user might be there who hasn't face this most irritating problem. When a user connects the flash drive, then some hidden services (virus) make all folder hidden and and creates a replica of that folder as FolderName.Exe Now what to do??? all you have to do is a little command scripting. Follow the steps:  Open Command window, type "cmd" in Run and press Enter: Switch to the Flash drive directory, suppose the directory is F: C:\Documents and Settings\Administrator>F:  List all files and Di...

Sql Server 7 Administration Tips

Resolving Sql Server Database Suspect Problem: All of us who work with SQL server (specially sql server 7 version) database frequently, might have faced the peculiar problem "Database Suspect" and black icon overlays the database icon in Enterprise Manager. Hence we can't access the Database. Here is the solution to resolve the problem. The concept is simply delete and rebuild the database log file. Follow the following steps: -------------------------- First of all delete the Database log (*.ldf) file of the suspected database. then --1.) Reset the status from "Suspect': EXEC sp_resetstatus ' ' --2.) Set the database property "allow updates': exec sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE --3.) Set the database to "Emergency Mode": UPDATE master..sysdatabases SET status=-32768 WHERE name=' ' --4.) Rebuild the database log file: dbcc rebuild_log (' ','F:\MSSQL7\Data\ _log') For example: S...