<div>
What version of SQL Server, what service pack?<br />
Any relevant entries in the Windows NT Eventlog?<br />
Any relevant entries in the SQL Server ERRORLOG file?
</div>


What version of SQL Server, what service pack?
Any relevant entries in the Windows NT Eventlog?
Any relevant entries in the SQL Server ERRORLOG file?

<div>
Turned out that this was the issue. This query caused both processors to exceed 90% and there was an error in the event log about power. HP replaced the backplane and Powersupply. <br />
Thanks,<br />
pat
</div>


Turned out that this was the issue. This query caused both processors to exceed 90% and there was an error in the event log about power. HP replaced the backplane and Powersupply.
Thanks,
pat

<div>
<div class="content wysiwyg-content">
Hi,<br />
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. <br />
Can anyone offer a direction to go in an effort to solve this problem.<br />
<br />
thanks,<br />
pat
</div>
</div>


Hi,
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.

thanks,
pat

SQL Server Reboots unexpectedly

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.