Ways to Fasten up Windows XP

(1) Do disk Clean up of C:\ Drive
(2) Increase virtual memory
(3) Defrag your machine
Right click C: Drive > Properties > Tools > Defragment Now > Click on C Drive and
then Defragment tab
(4) Clean the data from the hidden folders like "System Volume Information",
"Recyclers" (You have to take the ownership of the above folders before deleting
its contents)
(5) Delete files from C:\Windows\Prefetch
(6) Stop unnecessary programs from loading at the startup
Type msconfig in RUN and in 'Start up' tab Uncheck all the ones that you don't use
too often, click ok and restart the machine.
(7) Do not save folders/ files on the desktop.
(8) Get rid of themes and skins
(9) Finally, keep your machine virus free

Solution for slow opening of Excel and Word files

- Open My Computer.
- Go to Tools -> Folder Options, and click on File Types.
- Find the extension of the file in question (XLS, DOC, etc.)
- Highlight the extension, and click on the "Advanced" tab
- Select Open in the list and click button "Edit"
- Click into the "Application used..." field, and scroll to the end of the command.
- Put a space at the end, and type in "%1\" (With the quotes)
- Uncheck "Use DDE" if it is present
- Click on "OK"

Network Connection Wizard | VPN option greyed out

This issue may occur if the following services are disabled:

1) Telephony
2) Remote Access Connection Manager
3) Remote Access Auto Connection Manager

Go to RUN and type services.msc
Once you get the list of services, enable the above 3 services.

Enable Routing on Windows XP

To enable TCP/IP forwarding, follow these steps:

1. Start Registry Editor (Regedit.exe).
2. In Registry Editor, locate the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3. Set the following registry value:
Value Name: IPEnableRouter
Value type: REG_DWORD
Value Data: 1
A value of 1 enables TCP/IP forwarding for all network connections that are installed and used by this computer.
4. Quit Registry Editor.
5. Restart the machine

Solution to error "Unable to login to primavera due to login failure or bad password"

Open the SQL Query analyzer and access the pmdb database
Note: Use your database instead of pmdb database

Execute the following files

Exec sp_change_users_login 'update_one','pubuser','pubuser'
Exec sp_change_users_login 'update_one','privuser','privuser'

Enjoy

Creating SQL login with disabling Windows Password Policy requirements

Open SQL query analyzer and run the following lines

create login username with password = 'password', check_policy=off

Cracking trial period of MS Office 2007

1.In Windows Explorer, browse to the following folder:
C:\Program Files\Common Files\Microsoft Shared\OFFICE12\Office Setup Controller\Proof.en\

2.Right click on Proof.XML file, select “Open With…” in the right click menu.

3.In the “Open With” window, select Notepad to be used to open the XML file.

4.Find and Replace All 'AlwaysInsalled' to 'NeverInstalled '

5.Save the Proof.xml file

Commands used to send email from Command Prompt

First establish a connection to the mail server by using telnet
Go to start--run--cmd
then type
telnet 25
once you are logged in type

HELO

You will get a welcome message from the mail server.
Then proceed with the the following steps

MAIL FROM:

RCPT TO:

DATA
SUBJECT:

.

Set multiple login for Google Talk, Yahoo Messenger

Google Talk

1. Create a shortcut of Gtalk on the desktop
2. Right click that icon and select properties and then in the target place you will see something like this. “”C:\Program Files\Google\Google Talk\googletalk.exe” /startmenu”
3. Rename it as”"C:\Program Files\Google\Google Talk\googletalk.exe” /nomutex”
4. click apply and OK


Yahoo Messenger

1. Go to Run - Type regedit and hit enter
2. Navigate to HKEY_CURRENT_USER / Software / yahoo / pager /Test
3. On the right pane , right-click and choose new Dword value
4. Name it as Plural
5. Double click "Plural" and assign a decimal value of 1
6. Now close the registry and login with multiple Ids

Set Background image for pen drives

Create a file as 'desktop.ini' and copy the below contents

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

[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
Attributes=1
IconArea_Image=bground.jpg
IconArea_Text=0xffffffff

Copy the image file in the pen drive.
Rename the image file from 'bground.jpg' to the actual filename

Find the Serial number and the Product id of Autocad Software

Go to start -- run -- and type
regedit

Navigate to
HKLM\SOFTWARE\Autodesk\AutoCAD\R17.2


Copy your serial key
Enjoy!!!

Drive icons not displaying

Delete the follwoing key from the registry

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\DriveIcons\C\DefaultIcon]

Replace the drive letter "C" with the drive not displaying icon

MSX Server SQL error

MSX SQL server error is caused due to change in computer name after installing SQL Server. To fix this error you have to run these two statements in Query analyzer

1) list the jobs
select * from msdb..sysjobs

2) update the originating_server
update msdb..sysjobs
set originating_server = 'your new computer name'
where originating_server = 'your old computer name'

Renaming a computer that hosts SQL Server

To rename a computer that hosts a stand-alone instance of SQL Server

For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

sp_dropserver
GO
sp_addserver , local
GO

Restart the instance of SQL Server.

For a renamed computer that hosts a named instance of SQL Server, run the following procedures:

sp_dropserver
GO
sp_addserver , local
GO

Restart the instance of SQL Server.

After the Renaming Operation

After a computer has been renamed, any connections that used the old computer name must connect by using the new name.
To verify that the renaming operation has completed successfully

Select information from either @@SERVERNAME or sys.servers. The @@SERVERNAME function will return the new name, and the sys.servers table will show the new name. The following example shows the use of @@SERVERNAME.

SELECT @@SERVERNAME AS 'Server Name'

Images are not displaying in Microsoft Outlook

Have you ever come across situation were the images are not displaying in Microsoft Outlook? You will experience this when you get emails with images, the content will display but the pictures will not.
Before we go in to the fix for this let’s discuss the process of Outlook:
When you open any attachments in outlook it will temporarily save it in the windows Temporary internet folder. It’s a special folder called OLK, OLK is a super hiddenl folder which you can’t view from the explorer. So all the attachments in your Outlook will store in this folder so each and every time when you open an attachment those attachments will store in this OLK folder as a junk and when the amount of this junk increases you will experience this problem. So lets see how to fix this problem.Fix 1.
• Open your registry ( Type in “Regedit” in Run box”)
• Then navigate to this key in the registry “HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security
• On the right side you could see a key called “OutlookSecureTempFolder” Right click on this key and click on Modify
• You will get a folder path something like this “C:\Users\Renjith\AppData\Local\Microsoft\Windows\Temporary Internet Files\OLKC801”
• Copy this folder path and type in the Run box which will open up this location
• Now clear all the files in this folder.
• After this if you try to open any emails which has images it will display the images.
Fix 2.
• Delete the “OutlookSecureTempFolder” key from the registry and restart the computer
• This will actually create another OLK folder. I will not suggest you doing this because this will not delete all the junk files.

Hide program from control panel

Method 1

* Click Start, Run and type Regedit.exe
* Navigate to the following location:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Uninstall \ AnalogX Proxy

* In the right-pane, right-click the DisplayName value and choose Rename
* Rename it to anything (For example, NoDisplayName )

The AnalogX Proxy entry is now hidden. To make it visible again, rename the value back to DisplayName
Method 2

* Click Start, Run and type Regedit.exe
* Navigate to the following location:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Uninstall \ AnalogX Proxy

* In the right-pane, create a new REG_DWORD value named SystemComponent
* Double-click SystemComponent and set its data to 1

The AnalogX Proxy entry is now hidden. To make it

Google Tricks

(1) Get Rapidshare Links for softwares/movies/songs

Open www.google.com
and type the following words in the google search

rapidshare.com/files softwarename