Friday, November 14, 2008

Configure MSSQL database mail

MSSQL 2005 Enterprise or Standard versions provide mail feature integrated in the database, so that one can send bulk [:)] emails from the database.

Step 1

One should enable Database mail on the server, before setting up the Database Mail profile and accounts. Either can be done by using Transact SQL to enable Database Mail or the second method to use a GUI.
In the SQL Server Management Studio 2005, run the following statement.

use master
sp_configure 'show advanced options',1
reconfigure with override
sp_configure 'Database Mail XPs',1
--sp_configure 'SQL Mail XPs',0

Step 2
One can enable the Configuration Component Database account by using the sysmail_add_account procedure.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'TestMailAccount',
@description = 'Mail account for Database Mail',
@email_address = '',
@display_name = 'MyAccount',
@mailserver_name = ''

Step 3
Now one should create a Mail profile.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'TestMailProfile',
@description = 'Profile needed for database mail'

Step 4

Next will be the sysmail_add_profileaccount procedure, to include the Database Mail account which is created in step 2, along with the Database Mail profile in step 3.
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'TestMailProfile',
@account_name = 'TestMailAccount',
@sequence_number = 1

Step 5
You’d execute the below query.

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'TestMailProfile',
@principal_name = 'public',
@is_default = 1 ;

Step 6
After all these settings done, try to send a test mail from MSSQL Server.
You’d execute the below query.

declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' Test DB Email '
EXEC msdb.dbo.sp_send_dbmail @recipients='',
@subject = 'Test',
@body = @body1,
@body_format = 'HTML' ;

Step 7
You’d configure the Database Mail profile and its account using MSSQL Server Management Studio by right click Database Mail > Configuration.

Step 8

You can review the logs linked to Database Mail.
You’d execute the below query.

SELECT * FROM msdb.dbo.sysmail_event_log

Thursday, September 25, 2008

Vipassana : Indian Meditation Technique

विपस्सना (पाली) or विपस्याना means approaching into the impermanent nature, or अनिच्का, of mind and body विपस्सना is one of India's most ancient techniques of meditation, skilled to गौतम बुद्ध It is a way of self-transformation through self-observation and introspection In English, विपस्सना meditation is referred to simply as "insight consideration"

In a broader sense, विपस्सना has been used as one of two poles for the categorization of types of Buddhist meditation, the other being समथा(पाली) is a focusing, pacifying and calming meditation, common to many traditions in the world, especially योगा. It is used as training for विपस्सना, pacifying the mind and intensification the concentration in order to allow the work of insight. This is also sometimes discussed as "stopping and seeing." While समथा can peaceful the mind, only insight can reveal how the mind was uneasy to start with, which leads to प्रग्न्या (wisdom) and ग्याना (knowledge) and thus accepting, preventing it from being uneasy again।

The term is also used to refer to the Buddhist विपस्सना movement (modeled after थेरावदा Buddhism meditation practices), which employs विपस्सना meditation as its primary techniques and places emphasis on the teachings of the सतिपठाना सुत्ता। The primary initial subject of investigation in that style of meditation is sensation and feeling (वेदना)

विपस्सना is a पाली word from the संस्कृत prefix "vi-" and verbal root √paś. It is regularly translated as "insight" or "clear-seeing," though, the "in-" prefix may be misleading; "vi" in Indo-Aryan languages is corresponding to the Latin "dis." The "vi" in विपस्सना may then mean to see apart, or discern. Instead, the "vi" can function as an intensive, and thus विपस्सना may mean "seeing deeply". In any case, this is used metaphorically for a particularly powerful mental self-perception.

A synonym for "विपस्सना" is पच्काक्खा, "before the eyes," which refers to direct experiential observation. Thus, the type of seeing denoted by "विपस्सना" is that of direct observation, as opposed to facts derived from analysis or argument.

विपस्सना [in Tibetian language lhagthong] means in English as "superior seeing", "great vision" or "supreme wisdom." This may be interpreted as a "superior manner of seeing, and also as "seeing that which the essential nature is". Its nature is lucidity, clarity of mind.

Four Foundations of Mindfulness highlighted in the सतिपत्थाना सुत्ता; namely: काया (body or breath), वेदना (emotion or sensation), सित्ता (psyche), and धम्मा(mind objects). These phenomena differ from the खान्द्हस (aggregates) because the सित्ता factor is not connected to any aggregate, as it is the basic mood of the mind-body aggregate, while the धम्मा encompasses all mind objects that are fruits of कम्मा (i.e., the विन्नाना, सन्ना and संखारा aggregates), and also all mind objects that are not a fruit of कम्मा, such as the Four Noble Truths.

Saturday, September 13, 2008

Large Hadron Collider

Physicists start experiment to recreate Cosmic phenomenon in hope of finding How Universe began...

After 14 years and $8 billion, scientists at the European Center for Nuclear Research [CERN], outside Genava, succeeded in turning on the most powerful microscope ever built for investigating the elemental particles and forces of nature. Early on Wednesday (09102008) morning, the protons made their first circuit around a 17 mile long long racetrack known as the Large Hadron Collider, 300 feet underneath the Swiss French border, and then made a return journey.

Lyn Evans is the Project Director, an ocean and half a continent away from Geneva, several dozen physicists, journalists, students and just plain citizens gathered here at the Fermi National Accelerator Laboratory outside Chicago, to watch the dawn of a new generation in high energy physics, applauding each milestone of the night as the scientists at CERN slowly wrestled the beam into shape.

The collider is designed to accelerate protons to energies of 7 trillion electron volts and then smash them together, recreating conditions in the primordial fireball only a trillionth of a second after the big bang. The only thing physicists agree on is that they don't know what will happen - what laws prevail - under those conditions.

Many physicists hope to materialize a hypothetical particle called the Higgs boson, which according to theory endows other particles with mass, or identify the nature of the mysterious invisible dark matter that makes up 25 percent of the universe and provides the scaffolding for galaxies. Some dream of revealing new dimensions of space-time.

But those discoveries are in the future. If the new collider is a car, then what physicists did on Wednesday was turn on engine, that will now sit and warm up for a couple of months before anybody drives it anywhere. The first meaningful collisions, at an energy of 5 trillion electron volts, will not happen until late fall.


Wednesday, September 10, 2008

My TVS Apache RTR 160CC

Happy than never before....

Got my brand new TVS Apache RTR 160CC... These are brief overview.... which impressed me..



Apache 160 RTR



Top Speed:


Fuel Consumption:


Fuel Consumption:






4 stroke, Single

Maximum Power:


Maximum Torque:



5 Speed


Multi plate Wet





Cylinder Configuration:


Engine Block Material:


Chassis Type:

Double Cradle

Cooling Type:

Air Cooling



0 to 60:

5.56 sec.



2020.00 mm


730.00 mm


1050.00 mm



136.00 kg

Ground Clearance:

180.00 mm

Fuel Tank:

16.00 liters


1300.00 mm

Electrical System:









Yellow, Red, Black



Telescopic Forks, 105 mm Stroke


Mono tube Inverted Gas Filled Shox


Air Cooling


130 mm Drum

Stand Alarm:



Fuel Guage:


Self Start:


Tacho Meter:


Trip Meter:





2 Year



Passenger Footrest:


Passenger Backrest:

Step-up Seat:



My perception for Apache with other bikes in its segment...

My TVS Apache:
TOP SPEED :- Near About 122-125 KMPH
15.2 BHP Power, 160cc RTR Tech. Engine, Superb Look, Great Mileage 45-50kmpl at the speed of 70-80, Excellent to Ride, IMPORTED DISK BRAKE, 0-100 Kmph within 7 Seconds, Sharpest Headlight, Self start with KICK, Smooth Gear system, NO VIBRATION AT ALL

Top Speed: 115-118 kmph
16.5 BHP Power, 180cc DTSi, Nice look, Poor Mileage 35-40 kmpl running it on roads over 70-80, Handle is too tight, Simple Disk Brakes, 0-100 Kmph within 9 secs, Simple Headlight, Self start without Kick.

Top Speed: 120-123 Kmph
18 BHP Power, 200cc DTSi, Nice look, Poor Mileage 32-35 kmpl running it on roads over 70-80, Poor to Ride, Simple Disk Brakes, 0-100 Kmph within 8 secs (Still Less Than RTR), Simple Headlight, Self start without Kick

Now, Apache have some limitations, first Its not with Tubeless tire, but who needs, this is India..
& its Height…… major racing bikes do have height near about this one, so that you can control it easily :)

Let me know do you agree or not!!!!!

Tuesday, September 9, 2008

If I depart this life today?

I always get ready to live but never living.
At the last breathe of life, I may face the final curtain, My Friends I'd say, lived a life that's full, traveled each and every highway and more, much more than this, did it my way.

If I had my life to survive over, I'd provoke to make more mistakes next time. I'd rest; I'd limber up. I would be sillier than I have been this voyage. I would take fewer things sincerely. I would take more probability. I would scale more mountains and swim more rivers. I would eat more ice cream. I would perhaps have more actual troubles, b
ut I'd have fewer fantasy ones.

Hey, I'm one of those people who lived wisely and normally hour after hour, day after day. Oh, I had my moments, and if I had to do it over again, I'd have more of them. In fact, I'd try to have nothing else. Like one after the other, instead of alive so many years ahead of each day. I've been one of those persons who never goes anyplace without a hot water bottle, a raincoat, and a mobile.

If I had it to do over again, I would voyage lighter than I have.
If I had my life to breathe over again, I would start barefoot earlier in the spring and stay that way later in the fall. I would go to more drawing paintings; I would ride more bikes. I would pick more chances in life.

I may depart this life with my music still in me. Why is this so?
I’d get ready to breathe, before that, time may run out.

Lastly I will say, Life would be much easier if I had the source code.

Saturday, September 6, 2008

What is a DNS ZONE file

DNS zone file of the website which plays important role for its functionality. For example,
$ORIGIN -------; authorize the start of this zone file in the name space
$TTL 1h-------------------------; the default expiration time of a resource record without its own TTL value IN SOA
2008090610-------------------- ; serial number of this zone file [Generally this number represents the day when its created]
86400--------------------------- ; slave refresh (1 day)
86400 ---------------------------; slave retry time in case of a problem (1 day)
172800 -------------------------- ; slave expiration time (4 weeks)
3600 -----------------------------; minimum caching time in case of failed look ups (1 hour)
) NS -----------------; nameserver for NS -----------------; backup nameserver for MX 10 ----------; mailserver for A ---------------------------- ; IP address pointing to Server
www CNAME ----------------------------------------; "" is an alias for ""

Along with above records we need PTR & SPF records as well which resolves IP addresses into host names.

One common misconception about PTR records is that they are for domain names. The domain has to have one IP to make sure your emails are not rejected by other mail servers. The fact is that PTR records are for IP addresses and not for domain names. This means that if you are using one server to send emails you don’t have to worry about your PTR record if the server is already set with IP addresses. If your mail server already has a PTR record created then your mail would rarely be blocked.

Due to the reason of a significant majority of Spam comes from forged addresses, a new Sender Policy Framework (SPF) standard is being implemented by a number of ISPs and mail hosts including Hotmail, Yahoo, AOL, etc. Those providers have begun to require SPF to allow mail through their networks. So Mail servers will require SPF records for their domains if they want their mail to be accepted by those providers.

No action is required on user part as long as the Server where site is hosted has DNS with PTR and SPF records created.

Monday, September 1, 2008

God is in you, realize him.

I believe that doing affirmative things and seeing good qualities in others is what makes one experience God on earth. The person concerned can be dressed in a costly designer collection and will not offer a helping hand. Spirituality is not about finding God; it’s more about releasing the innate God in you through your actions and day-to-day events.

I don't think inner depth or religion has anything to do with an individual's personal style preferences. Possessing costly things does not make one less spiritual, nor do we need to sacrifice something in order to attain something else. It's our own self inflicted initiations that re-inform the faulty faith that we can't have it all. In reality, there's no reason why we can't strike a well stability between material things and spiritual enlightenment. Spirituality signifies achieving personal quality in every area of one's life; from family life to career as well as inner growth.

I also feel wearing signs of God is not as important as felling the belief and applying those values on a daily basis in one's life. But, if wearing these signs reminds one to carry out spiritual teachings, then it doesn't matter where the person wears them as long as they are sincerely applied.

I think there is a lesson in every incident one faces in life and it's important to learn from these numerous experiences. Whether it means becoming emotionally stronger when a family member is unwell or something as simple as learning patience from a child - there is much to learn from everyday life's daily lessons.

My idea of pleasure is that it emanates from inner peace - when that happens, it means that one has achieved harmony of life.

(The Sunday Times of India 08312008)

Saturday, August 30, 2008

Indian Classical Music

Indian classical music is basically composed of 7 basic notes सा रे ग म प ध नि, with five interspersed half-notes, resulting in a 12-note scale

हिन्दुस्तानी music:
This rhythmic group is based on rhythmic patterns called ताल. The melodic fundamentals are ‘melodic modes’, known as थाट , थाट are part of "musical personalities" called राग।

थाट - may consist of up to seven scale degrees or स्वर .

सरगम :

• सा = Do • रे = Re • ग = Mi • म = Fa • प = Sol • ध = La • नि = Ti • सा = Do

A typical rendition of हिन्दुस्तानी raga involves two stages:

अलाप : a rhythmically free improvisation on the rules for the राग in order to give existence to the राग and shape out its characteristics। The अलाप further divided into the अलाप, जोड़ and झल।

बंदिश or गत : It is a fixed, melodic composition set in a specific राग, performed with rhythmic accessory by a तबला or पखावज.
स्थायी : The initial melodic symphony.
अंतरा : The first body phrase melodic symphony
संचारी : The third body phrase melodic symphony, like in ध्रुपद बंदिश
आभोग : The fourth and concluding body phrase, melodic symphony, like in ध्रुपद बंदिश.
There are three variations of बंदिश, regarding tempo:
विलंबित बंदिश : A slow and steady melodic symphony,
मध्यलय बंदिश : A medium tempo melodic competition
द्रुत बंदिश : A fast tempo melodic symphony,

Types of Vocal music compositions:

The major vocal forms-cum-styles related with हिन्दुस्तानी classical music are ध्रुपद , ख्याल , and ठुमरी . Other forms include धमार , तराना , त्रिवट , चैती , कजरी , टप्पा , टाप -ख्याल , अश्तापदिस , दादरा , ग़ज़ल and भजन. Some forms come under folk or Semi-Classical or Classical ('Light' Classical) music,

ध्रुपद music is primarily devotional in theme and content. It contains recitals in praise of particular deities. ध्रुपद compositions begin with a relatively long and acyclic अलाप , traditionally performed by male singers.

ख्याल , is special as it is based on improvising and expressing feeling. ख्याल are also more popularly depicting emotional significance between two lovers, circumstances evoking intense feeling, or situations of ethological significance in Hinduism and Islam.

टप्पा is a form of Indian classical vocal music whose specialty is its rolling pace based on fast, delicate, tricky structure. The arrangement of words, with the help of tone vibrations performed in superb vocal style, create a charming ambiance.

तराना are songs that are used to convey a mood of delight and are usually performed towards the end of a concert. They consist of a few lines of musical sounds or बोल set to a harmony.

ठुमरी is a semi-classical vocal form, Punjabi, लखानोवी and पूरब अंग ठुमरी . Lyrics are in ब्रज भाषा and are usually romantic.

ग़ज़ल is an formerly Persian form of poetry. In the Indian sub-continent, ग़ज़ल became the most common form of poetry in the उर्दू language.

Thursday, August 28, 2008

Basic Customer Service protocols

I am not an expert, but want to share my some thoughts, which I think will be helpful :

Good customer service is the backbone of any business. Offering promotions and slashing the prices to bring in as many new customers as you want, but unless you can get some of those customers to come back, your business won’t be profitable for long.

Good customer service involves bringing old customers back. And about sending them away happy – happy enough to pass positive feedback about your business along to others, who may then try the product or service you offer for themselves and in their turn become repeat customers.

Few steps need to follow, these may be just followed by you, but will refresh your thoughts for once again,

Don’t make promises unless you WILL keep them. Confirm prior to any promise – because nothing annoys customers more than a broken one.

Listen to your customers. Let him complete and show him that you are listening by making the appropriate responses, like 'Ok', 'I see', such as suggesting how to solve the problem.

Deal with complaints. No one likes hearing complaints, and many of us have developed a reflex shrug, saying, “You can’t please all the people all the time”. But if you solve that complaint, it may lead for business positive response.

Be helpful - even if there’s no immediate profit in it.

Train your staff to be ALWAYS helpful, courteous, polite and knowledgeable. Do it yourself or hire expert to train them. Talk to them about good customer service regularly. Most importantly, give every member of your staff enough information and power to make those small customer-pleasing decisions, so he never has to say, “I don’t have appropriate rights to take this decision.”

Take the extra step. When customer arrives, Wait and see if he has questions about your product, or further needs. Whatever the extra step may be, if you want to provide good customer service, take it. They may not say so to you, but people notice when people make an extra effort and will tell other people.

Throw in something extra. Whether it’s a coupon for a future discount, additional information on how to use the product, or a genuine smile, people love to get more than they thought they were getting. A small thing, but so appreciated.

Its not a complete Customer service guide, but basic things to be followed... ;)

Monday, August 25, 2008

I quit smoking!

I quit smoking..

This is the story of this particular day which made a drastic change in my lifestyle, I hope it changes your perception as well.

All of us who have a smoking habit meet up with friends or colleagues and smoke our time out.
My friend's invitation for a cup of tea will start with obvious question, "Hey Dude, which brand?" and the answer would be either a Marlboro or a Classic Mild. Being well educated we all know the harmful effects of smoking a cigarette and how it affects people around us who don't have this habit. (Yes, even passive smokers have a great chance of having diseases related to smoking) At times its just our attitude which forces us to smoke and its not actually the urge of smoking a cigarette.

It is about this day when we were at this tea stall near a temple with some beggars rounding us for alms. One of them in particular was a grey-haired, wrinkled old beggar woman who approached us with her walking stick for alms of one rupee or more to help her buy lunch for herself. We looked at her and refused to oblige and asked her that how will a rupee get her a meal. She said that she will collect more alms and get the meal for herself.
We crushed our half burnt cigarettes with our shoes and moved forward without giving her any alms. She mumbled when we turned.... "These young men will burn more than a rupee for their bad habit but will never give a rupee to a hungry person."

I didn't say a word to her and went inside the temple but her words were hitting back on me and it was making me really sick about the whole feeling.
After a while when we came out from the temple we saw that the old women was sharing her lunch with another girl who had failed to collect enough alms for her meal.

I went to the beggar and questioned the old women of who the other girl was and she told me about her. (No, the girl was not related to her ) I asked her "You didn't know whether you'll get your lunch for today and here you are sharing your meal with this girl who just met you. How are you going to arrange for your dinner now" She replied to me " Don't worry son, God will arrange my dinner like how he did for my lunch" and I was really shaken by that statement of hers.

I was astonished at her generosity and could not utter a single word. It was a true lesson. The old woman who was not sure whether she would be able to arrange a rupee for her lunch did not hesitate to feed a hungry girl not worrying about her dinner. Her remarks which she made earlier were correct and it was true that two cigarettes could feed two hungry people was for me.

It was for the last time I had tossed that half-burned cigarette and crushed it under my shoes. I got the strength to quit the habit at that moment itself. No "statutory warning" on the cigarette packet or any health related articles could teach me the lesson that the beggar woman did that day"

I am not a saint to tell you about the ill effects of the smoking a cigarette but I am just your friend. The simple fact that a single cigarette can suffice a hungry human being has forced me to quit a habit which was pretty unnecessary in my life. I must tell you the feeling you get when you help a hungry or a needy person is all worth kicking the habit... Don't believe me...Try it!

[Courtesy: Sunday Times of India (24/08/2008)]

Saturday, August 23, 2008

How NAT is configured

As you are going through this topic, you are surely connected to the Internet and it’s for sure that you are in Network Address Translation (NAT) environment.

The Internet has gone bigger than ever imagined. You must be amazed to know the size of the Internet with NAT. To communicate on the internet every computer and web server must have a public IP address. An IP address is a unique 32-bit number. It specifies your location on global network.

When 32 bit IP (IPv4) addressing first came out, theoretically it can have 4,294,967,296 unique addresses (232). The actual number of available addresses is much smaller because of the way that the addresses are separated into ‘Classes’ and the need to set aside some of the addresses for multi-casting, testing or other specific use. (I will be posting on IP address classes very shortly.)

Network Address Translation is a single device like a router which acts as liaison between the Internet and a local network. One single unique IP address is required to represent your network of computers in a particular company.

Static NAT – Mapping an unregistered IP address to a registered IP address on a one-to-one basis. This is particularly useful when a device needs to be accessed from outside the network.

Dynamic NAT – Maps an unregistered IP address to a registered IP address from a group of registered IP addresses. Dynamic NAT also establishes a one-to-one mapping between unregistered and registered IP addresses but the mapping could vary depending on the registered addresses available in the pool at the time of communication.

Overloading – A form of dynamic NAT that maps multiple unregistered IP addresses to a single registered IP address by using different ports. It is also known as PAT (Port Address Translation), Single Address NAT or Port-Level Multiplexed NAT.

In my upcoming post I’ll let you know on "How your web request from your PC gets served as web page?"

Friday, August 22, 2008

How Spammers Get Email Addresses

How Spammers Get Addresses ? There are so many companies which sell CDs with plenty of valid e-mail addresses. With MS Word, you'd easily make those addresses into lines of 100 addresses each, and then cut and paste those lines in the "To:" field of any e-mail program.The problem with spam is, incredibly easy to send. Practically costs nothing to send it. Reply rate is also very less 1 is to 1000 ratio of e-mails, Where does a company get millions of valid e-mail addresses to put on a CD and sell to you? There are a number of primary sources.

newsgroups & chat rooms, Newbies often provide their screen names, or keep valid e-mail addresses, in newsgroups. Spammers do use a software to extract the screen names and e-mail addresses automatically.

The Web itself. There are thousands of Web sites, The programs that do the spidering is spambots, searchs the Web specifically looking for "@" sign that indicates an e-mail address.

Websites created ONLY to attract e-mail addresses. Just like, a spammer creates a site that says, "Win £1 million!!!, ONLY type your e-mail address here!" In the past, lots of large sites also sold the e-mail addresses of their members. Or the sites created "opt-in" e-mail lists by asking, "Would you like to receive e-mail newsletters from our partners?" If you answered yes, your address was then sold to a spammer.

Probably the most common source of e-mail addresses, however, is a "dictionary" search of the e-mail servers of large e-mail hosting companies like MSN, AOL or Hotmail. In the article Hotmail: A Spammer's Paradise?, the author describes the process:
A dictionary attack utilizes software that opens a connection to the target mail server and then rapidly submits millions of random e-mail addresses. Multiple adresses have slight variations, such as "" and "" The software then checks which addresses are "live," and adds those addresses to the spammer's list. These lists are typically resold to many other spammers. E-mail addresses generally are not private. Once a spammer gets a hold of your e-mail address and starts sharing it with other spammers, you are likely to get a lot of spam.

So keep in might, You are not safe and secured in this Virtual world!!!

Thursday, August 21, 2008

I don't hate Mozilla but use IE or Else VIRUS…

Here I have spent some time on google to find out the solution for this virus, may it'll help you to protect your computer from this virus! I Dont hate mozilla but use IE or Else… this is a virus…which has also blocked my AntiVirus can also not detect it… These virus are spreading through USBs / Pen drives. You'd take precaution to disable the auto run feature in the system.

Follow the simple steps:

1. Start -> Run.
2. RegEdit in the Run text box, press ENTER.

3. In the Registry Editor, locate and click the following registry key:
Modify the value of the Autorun to 0 (zero) so that CD-ROMs and Audio CDs do not run and start automatically when inserted.
4. Next navigate to the following registry subkey:
Modify the value of the NoDriveTypeAutoRun entry to 0xb5 value to turn off the AutoRun feature for CD-ROMs by right-click NoDriveTypeAutoRun and then click Modify to type B5 in the Value data box. Select Hexadecimal, and then click OK.
5. Quit Registry Editor.

6. Restart your computer.
Now time to remove it completely,
* Open you task manager by pressing Ctrl+Alt+Del

* Now go to processes tab and arrange the processes by users.

* Now look for svchost.exe run by User name “user” or “admin” or “your computer name”. Right click and end the svchost.exe processes where the User Name is not “SYSTEM” or “NETWORK SERVICE” or “LOCAL SERVICE”.
* Next Open you command prompt, Start > Run and then typing cmd in the text box and hit enter.

* In the dialogue window, type cd\ and press Enter
* It will change to C:\>

* Next, type " attrib -s -r -h heap41a /s /d and hit Enter.

* Then Open C: on My computer and delete the folder heap41a i.e., C:\heap41a
* Now remove C:\heap41a\svchost.exe shortcut from C:\Documents and Settings\USER\Start Menu\Programs\Startup (Or Start > All Programs >Startup)

Now you have deleted the virus. Whenever you insert a pen drive , try to delete the autorun.inf file in it and other hidden .exe files inside it which are shown with folder icon.

[P.S.: This post is also available on other websites also..]

Wednesday, August 20, 2008

Why application Pool crashes?

Why application Pool crashes for websites? I kept my promise to post about this issue. Quickest resolution for the application pool crash, may be the permission issue, which can be fixed easily, but if it fails then, Application pool crash may be the result of its actually crashed process or just got hang because of multiple queries.
Lets see the difference between a crash and a hang on the Windows Server .

A crash is the one who will remove out the host process; this will lead to stop the server side work and affect the output of that process been assigned. In old versions of IIS, whenever crash occurred, will go down and the browsers will display a disconnected connection and report some service disconnected or unknown error. In IIS6 Worker Process Isolation Mode, the HTTP.SYS holds the connections in kernel-mode, so even if user code running in w3wp.exe crashes, the connection remains connected and IIS takes care to start up a new process to handle further requests - so browsers like mozilla, IE will not see a disconnection for a crash. But the request in the crash process cannot be re-executed, [serious issue with any money transaction processes]. Now a hang, will keep its host process running but the it prevents to make any sort of changes in. Application code may be waiting for a lock that never gets released, may be because it was leaked or may be a logical deadlock or live lock, or may be infinite loop, etc. Any non processed response will never happen once the application code hang. From browser point of view, both the things, a crash and a hang on the server may prevent a complete HTTP response from being sent back, so may look quite similar. Now a crash is an unrecoverable event that may be resulted from some flaw/bug in the code that is executing. A bug is a logical flaw in the code that may result in some arbitrary set of inputs. so roughly you can say that bugs can cause crashes to the application... I want to make one point here, users attempt to resolve their crashes without diagnosing the cause. Like, most users just look at pattern matching problem symptoms and event log entries and applies presumed solutions and BLINDLY try them all, hoping that some of the solution may work... But its dangerous, leading to making it more complicated issue, than resolving in easy steps.

Now the scene arises that, if you do not know, which bug is causing this,
Now its time to look for debugging, so that NEXT crash can be avoided. you cannot do anything about the crash that has already occurred. You SHOULD NOT change any server settings to avoid it. You can set up debugging monitors like IIS State or DebugDiag for necessary processes running code those are crashing and then WAIT for the next crash. ;)

So whenever failure occurs, These debugging tools will record the event with the cause. After taking out the report from these tools, you will see, there is either only one culprit who is recursively causing it or there are multiple issues. So in initial stage, you can keep watch on the result and also get them fixed as soon as they occur.