Debugging SP Killed SQL Server

Hi,
I've just been trying to debug an SP on SQL server 2000 using QA when
users started reporting that the server was inaccessible.
This is a 2 server failover cluster so luckily the second server took
over. Just wondering if anyone has seen this issue before and how to
stop it.
The SP is doing nothing spectacular just inserts and updates wrapped
in a transaction, if i execute the SP it seems fine.
Any help anyone can give would be greatly appreciated.
Cheers
Wes
wesley.potter@.bss.org wrote:
> Hi,
> I've just been trying to debug an SP on SQL server 2000 using QA when
> users started reporting that the server was inaccessible.
> This is a 2 server failover cluster so luckily the second server took
> over. Just wondering if anyone has seen this issue before and how to
> stop it.
> The SP is doing nothing spectacular just inserts and updates wrapped
> in a transaction, if i execute the SP it seems fine.
> Any help anyone can give would be greatly appreciated.
> Cheers
> Wes
http://support.microsoft.com/default.aspx/kb/899431
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||On Tue, 21 Nov 2006 11:41:33 -0600, Tracy McKibben
<tracy@.realsqlguy.com> wrote:

>http://support.microsoft.com/default.aspx/kb/899431
Thanks Tracy, Spot on!!!