Computer tips and tricks techno stuff

How to Recover Suspected Database SQL 2000/2005/2008          “Database suspected” a very annoying issue in the field of Data management. Some time due to sudden power failure or some other reasons our database gets suspected and we can not use it anymore.       To over come this issue, there are some tricks that may be helpful to recover your suspected database 1.          Restore latest backup                   The easiest way to make suspected database is to restore it with latest available healthy backup. It’s always very easy and secure method.. but what if you don’t have backup ?           Then you need to try out second option 2.          Using SQL Query                You need to execute following query in query analyzer to overcome this issue EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(‘yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (‘yourDBname’, REPAIR_ALLO

                                        Hi friends                Now a days , we all are facing problem while doing day end in postman module due to pending articles in BOs ( RL RLAD VP COD etc)           I have tried to develop one small tool to view all pending articles in all BO. Monitoring of all articles through this tool in daily basis can help us to reduce pendency of COD Articles in our office also Hope this tool will be useful to us                              Download Request :- please give this page link to your website to share this post and kindly directly don't copy this post to any website       Regards Ketan Joshi System Admin Palanpur HO-385001

All in one Driver Solution Many times we are facing the problem while reinstalling a system is missing of drivers. Here is a very useful tool to help us. Thats driver pack solution from  Drp.su Features :- Supports most of the systems including Desktops, Laptops, Printers No need to worry about search around the internet for drivers Automatic detection of missing drivers Silent installation All in one single DVD image for  free . Download torrent   Torrent Size: 39.3 KB Files size : 2.9 GB Make sure you selected only drivers for installation, while using this program, else it will install many software inbuilt with in. Source : All in one Driver Solution -  Live to learn

HP LASERJET P1000-P1500 BASIC DRIVERS FOR WINDOWS Written By Admin on Jul 28, 2015 | July 28, 2015 Installation Procedure Close any software programs running on your computer. Click the Download only button and save this file. Double click on the downloaded file. The self-extracting process will appear. Click to accept the terms in the license agreement. Click Next. Driver installation begins. Driver files are pre-installed during this process. A screen pops up to prompt to connect the USB cable. Insert the USB cable. Device is connected, waiting for PnP to finish installing driver. Click Finish to complete software installation. Compatibility: Microsoft Windows Vista Microsoft Windows 7 (32-bit) Microsoft Windows Server 2003 Microsoft Windows 8 (32-bit) Microsoft Windows 8.1 (32-bit) Microsoft Windows XP Microsoft Windows 2000 Download Drivers For HP Laserjet P1000 Series Download

The best way to install an operating system is to install OS from a USB Pen drive. It will only take 20-25 minutes for the installation. You need to enable USB Boot from BIOS Setup and set USB as first preference in boot order. Article Prepared by : Sanoj P Raj System Administrator, Alathur Mbr HPO,Palakkad   - 678541 Ph : 9809 904 904 Requirement:  1. A USB Pen drive (Preferably 8 Gb USB 3) 2. Windows 8 USB Installer Maker Software (A 900 Kb freeware software) 3. A Windows XP / Windows 7 / Windows 8.1 / Windows 10 / Windows Server OS DVD or ISO image of the same. Steps Involved: 1. Format the Pen drive 2. Copy all files from OS DVD to Pen drive / Extract ISO image of OS to Pen drive. 3. Use Windows 8 USB Installer Maker software to make the Pen drive bootable. Simply select the “USB drive letter” and click “Fix USB Boot” Now your Pen drive is a bootable USB drive.  Google Drive Link for Windows 8USB Installer Maker Software:  https://drive.google

Disable USB Ports on Windows Most of us have come across a situation where we need to disable the USB Port at offices for various reasons. Mostly to protect computers from viruses and to protect our data from being stolen. So, in this tutorial, I will try to explain various methods to enable / disable USB Port on any version on Windows OS The common methods used to block USB Port are  1. Changing the Registry Values 2. Disabling USB Device Manager 3. Uninstalling Your USB Mass Storage Drivers Method 1: Disable USB Port by Changing the Registry This is the simplest method. In this method, the registry value is changed so that it will disable the USB port.  1.Go to Run (Win+R) 2.Type Regedit 3. Go to HIKEY_LOCAL_MACHINE SYSTEM CURRENT CONTROL SET SERVICE USBSTOR 4. In USBSTOR, double click on start Change the value data to 4 to disable the USB Port Change the value data to 3 to enable the USB Port when required 5. Click ok and close the

You can do this using the Windows Update service. Via Control Panel > Administrative Tools, you can access Services. In the Services window, scroll down to Windows Update and turn off the process. To turn it off, right-click on the process, click on Properties and select Disabled. That will take care of Windows Updates not being installed on your machine. But since Windows is a Service now onwards, you have to keep your computer updated. To be able to install the next set of features or a newer build, you will require the earlier updates to be installed. That’s why if you use the above workaround, you will have to go to the Services and turn it on once in a while to download and update your copy of Windows. After you turn on the Windows Update service, when you open Windows Update in PC Settings, you will see a message that updates were not installed because computer was stopped. You will have to click on Retry so that all the available updates are downloaded and insta

Step 1: Start the computer in safe mode  1. Start the computer. 2. After the computer runs the Power On Self Test (POST), press F8 repeatedly to open the Windows Advanced Options menu. 3. On the Windows Advanced Options menu, use the arrow keys to select Safe Mode, and then press ENTER. 4. Use the arrow keys to select the Windows operating system that you want to start, and then press ENTER. 5. When the computer is running in safe mode, log on by using an account that has administrator rights and permissions. Then, click Yes in the message that states that Windows is running in safe mode. Step 2: Start Registry Editor Click Start, click Run, type regedit, and then click OK. Step 3: Remove the RESETS registry subkey  1. In Registry Editor, expand My Computer, and then expand HKEY_LOCAL_MACHINE. 2. Expand SOFTWARE, and then expand Microsoft. 3. Expand Windows NT, and then expand CurrentVersion. 4. Expand Winlogon, and then expand Notify. 5. Under Notify, right-click RESETS, and then cli

To find SOL ID of Other Post Offices There are many ways to find the SOL ID of the other POs in India Post finacle. Some of them are given below. Step By Step Procedure in Detail 1st Way: 1. Invoke HFTI menu 2. Delete the SOL ID in the SOL ID field and enter the pincode of the post office for which SOL ID has to be known. 3. Click on the searcher beside the SOL ID field. 4. System will display the SOL ID of that particular post office if it is migrated to finacle. 2nd Way: 1. Invoke HAFI menu 2. Delete the SOL ID in the SOL ID field and enter the pincode of the post office for which SOL ID has to be known. 3. Click on the searcher beside the SOL ID field. 4. System will display the SOL ID of that particular post office if it is migrated to finacle. 3rd Way: 1. Invoke HFTR menu 2. Delete the SOL ID in the SOL ID field and enter the pincode of the post office for which SOL ID has to be known. 3. Click on the searcher beside the SOL ID field. 4. Syste

HIDDEN ANDROID SECRET CODES *#*#778O#*#* = Factory Data Reset *#*#I472365#*#* = Quick GPS Test *#*#0673#*#* OR *#*#0289#*#*  = Audio Test *#*#2664#*#* = Touch Screen Test #’#273283*255*663282*#*#* = Backup Media Files *#*#0283#*#* = Packet Loopback Test *2767*3855# = Reinstalls The Phones Firmware & Format Your Phone *#*#232339#*#* OR *#*#526#*#* = WireIess Lan Test *#*# 1575#*#* = Different GPS Test *#*#4636#*#*‘ = Complete Information About your Phone *#*#2663#*#* = Touch Screen Version *#*#232337#*# = Displays bluetooth Device Address *#*#4986*2650468#*#* = PDA, Phone. Hardware, RF Call Date *#*#44336#*#* = Displays Build Time *#06# = Displays IMEI Number *#*#8255#*#* = Google Talk Service Monitoring *#*#I I I I#*#*   |  *‘#*#2222#*#* = FTA Software Version FTA | Hardware \/ersion *#*#3264#*#* = Rom version *#*#23233I#‘*#* = bluetooth Test *#*# 1234#’#’ = PDA and Phone Firmware Info *#*#0*#*#*=

‘Linking of Aadhar with Postal saving accounts must’ After making Aadhaar mandatory for filing income tax returns, the government of India has now made it mandatory to link Aadhaar with savings accounts by December 31. In this backdrop, all the esteemed account holders of the Department of Posts are informed that the last date for seeding of Aadhaar numbers with the accounts has been has been fixed as December 31 by the government of India, a Press Information Bureau statement said.  “All the account holders of the department of posts are requested to contact their respective post offices along with Aadhaar card/Aadhaar number and get the Aadhaar numbers seeded with their accounts as a mandatory exercise.” All the account holders are also requested to seed their mobile numbers with their accounts to get real time SMS alerts of transactions, it added.

Query to reduce the size of eMO database in SQL When MDF of SQL database file grow and consume more space in the HDD and the MM Modules/SQL Management studios becomes unresponsive in  most of the times.In my case, emo mdf file size increased to 93 GB due to which the hard disk space was almost occupied by the eMO database file(MDF) file also we can't do any emo operation in the eMO module. So the following query was executed and the mdf file size was reduced to minimum ie. 1 gb. Pls circulate dis among our friends. Note:Applicable to SQL Server 2008. USE eMO GO ALTER DATABASE [eMO] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE ([eMO_log], 1) ALTER DATABASE [eMO] SET RECOVERY FULL WITH NO_WAIT GO