>Hi,
>
>I have a notebook running Windows 7 Pro 64-bit. I need to do a very long process (converting data from VFP to SQL Server). This process takes many hours. So in order to make sure that the computer does not go to "sleep" I set the Power Options as following:
>
>Turn Off Display - Never
>Put the computer to sleep - Never
>Dim the display - 15 minutes.
>
>Yet I see the second day in the row that the computer (after several hours) goes into the "sleep" mode. The connection to SQL Server is broken and my process stops. I have to tap on the Power button to "wake up" the notebook.
>
>Is this the problem with my notebook or Windows 7? Or do I misunderstand the Power Options? I would appreciate any suggestions. TIA.

Be sure to go into "Change advanced power settings". You will probably want to turn off Hibernate, in the Sleep section. Also, look at any other settings that may turn off power e.g. to network adapters. If you have a wired Ethernet adapter, go into Device Manager, the properties of the adapter, and un-check "Allow the computer to turn off this device to save power".

Another thing to consider would be to temporarily select the "High performance" power profile while your job is running.

Also, some notebooks have power management utilities provided by the maker, that may override Windows settings. You might want to check if any are present on your computer.