>Hi All,
>
>We have an app. developed in VFP 6 and we are using terminal server to run the application. We have a batch update utility to update the required masters. Till date this form for update was running perfectly fine without any problems. Lately whenever we are running this form it restarts the server without any message or any error message. This happens even if we r running compiled exe version or from VFP command window level. When we tried to debug it we found that we have issued an sql command e.g.
>
>The whole code is as below :
>
>

>Sele Mastertable
>Go top
>
>Scan
>   sele * from abc where abc.mastercode = Mastertable.code into curs xyz
>
>   Select Xyz
>
>   ** Do updation procedure
>   Sele Mastertable
>Endscan
>

>
>Now the problem is the moment we issue Select xyz the machine seems to restart and this happens only after executing certain records from mastertable. E.g. if mastertable has more than 1000 records then it works fine till 800 or 820 records and then when we issue Select xyz table the machine restarts.

1. It sounds like the server is actually going through a "bugcheck". Check the server's Event Logs for clues.

2. It should be impossible for a user-mode application like VFP to cause the entire server to restart. If, for example you have a corrupted index on "abc" then the worst that should happen would be a C5 error, where Windows kills your application but Windows itself remains running. The things that might cause a restart could include:

- Poor quality electrical power, or an undersized or failing power supply in the computer. Make sure that all fans in the computer (power supply, case fan(s), CPU, Northbridge/Southbridge if applicable, video card if applicable) are running. Be sure to use a UPS if power quality is poor
- Failure to apply service packs and patches to the server
- Incorrect or buggy hardware driver(s) e.g. video. Make sure the drivers are exactly correct for the hardware and check for updates from the manufacturers
- Other hardware problem e.g. RAM chips. On a W2K3 server running lots of processes plus TS it's unlikely that a small VFP query would exercise RAM chips that hadn't already been used before but you never know.