Review any options, preferences, or startup portion to see if you can change it. Once done, check it out. If nothing seems to address the issue, look at the MSCONFIG file.
Goto->start->run->type in MSCONFIG->click startup button->uncheck Lightroom2->save or apply and exit out.
You may have to reboot and try it. If none of this works, uninstall Lightroom2 entirely. Make note where you installed 1st(directory) and totally delete it once the uninstall procedure has been done. Reboot and then re-install Lightroom2, if it requires some preference then, make note of it. Here you can now change how you want it to load.
tada -----Willy 
When ever i plug in my external hard drive or a usb stick it always loads lightroom 2. im sure at some point i must have told it to do this but how do i change it back to when just a small window loads up asking me what i want to do with it.
All help greatly appreciated
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic