RNet Communication Error Solution

Problem : 
While running RNet communciation, the following error mesage

"The channel " http  is not registered with remoting services"

Solution :

Do the following steps to rectify this problem


1. Go to the folder C:\windows\System32\drivers\etc ( if you have installed windows on D partition then the path will be like D:\windows\System32\drivers\etc)


2. Open the file “Hosts” file using notepad
3. There will be an entry like the following inside the hosts file
127.0.0.1 localhost


Add one more entry below.


218.248.43.143 regnnet.ptcmysore.gov.in

HOW TO REPAIR A SQL SUSPECTED DATABASE

Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired.

A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.

To get the exact reason of a database going into suspect mode can be found using the following query

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

Output of the above query will give the errors in the database.

To repair the database, run the following queries in Query Analyzer,

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_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER

And you are done.

You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation i.e. once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries.

Install Windows xp Very Fast

Now, this tip will be very helpful for those who frequently install windows xp operating system. Normally OS installation takes around 40 minutes to complete, but through this trick you can now save 10-15 minutes. This simple tricks goes this way.
1. Boot through Windows XP CD.
2. After all the files are completely loaded, you get the option to select the partition. Select “c”.
3. Now Format the partition, whether it is normal or quick with NTFS or FAT
4. Once the formatting is completed, All the setup files required for installation are copied. Restart your system by pressing Enter.
Now, here begins the Simple trick to save 10-15 minutes.
5. After rebooting, you get a screen where it takes 40 minutes to complete or finalize the OS installation.
6. Now, Press SHIFT + F10 Key ->  This opens command prompt.
7. Enter “Taskmgr” at the command prompt window. This will open Task Manager.
8. Click the Process Tab, here we find a process called Setup.exe -> Right Click on Setup.exe -> Set Priority -> Select High or Above Normal. Initially it will be Normal.
Thats it, no more work to do. Relax your self and see how fast the installation process completes

Use System Restore

System Restore is one of those programs that can be a life-saver when you've been the unfortunate recipient of unstable software, a badly timed power outage, or a damaging thunderstorm. System Restore records important documents, settings, and preferences on your computer. If the unthinkable happens and your computer files are damaged or inaccessible, you can use System Restore to restore your computer to the same state it was in before the data was lost.
System Restore creates restore points daily and whenever you install device drivers, automatic updates, and some applications. But it's a good idea to get into the habit of creating a system checkpoint (called a restore point) when you're about to install new software or take any action you suspect might make your computer unstable. Then, if there's any conflict at all, you can restore your computer to the point just before you began the installati

Create a restore point in Windows 7

1.      In Control Panel, click System.

2.      In the left pane, click System protection.

3. Click the System Protection tab, and then click Create

4.  In the System Protection dialog box     type a description, and then click Create