SQL Server Reboots unexpectedly
Posted on 2006-05-31
Don't know if this is a SQL or VB question. I have written a VB6 program which uses ADO 2.7 to produce a report. When the report is run the server reboots(Win Server 2003). The point in the report at which it reboots varies. It seems to be somewhere between 500 and 800 records. The report is executed from a workstation. An XP Pro SP1 workstation always completes the report without crashing the server. The other workstation which is a Win XP pro SP2 causes the server to reboot most of the time(9 out of 10 times). The report is unremarkable. I have much more complex reports running successfully on both of these workstations. I am thinking I should create a profile to see what is happening but I do not have the experitise to write one directed at this problem.
Can anyone offer a direction to go in an effort to solve this problem.