Hi

I had some problem in my SQL Server few weeks back. I have installed Service Pack 3 in the Server. Herewith I have enclosed my stored procedure and Error messages. While I run the stored procedure SQL Server initiates a Shutdown. Please let me know if any body come across the same problem.

Here is the Error Message

SQL Server Assertion: File: <proc.c>, line=1931
Failed Assertion = &#39;m_activeSdesList.Head () == NULL&#39;.
Dump thread - spid = 11, PSS = 0x4aaad100, EC = 0x23304084
Stack Dump being sent to c:MSSQL7logSQL0001.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 03/09/01 12:32:18 spid 11
*
* Input Buffer 84 bytes -
* E x e c T e s t P r o c &#39; 2 / 1 / 0 1 &#39; , &#39; 2 /
* 2 8 / 0 1 &#39;
*
************************************************** ****************************

CREATE Procedure test(
@Frdt varchar(10),
@Todt varchar(10)
)AS

CREATE TABLE #test1(
f1 Datetime,
f2 Varchar(5),
f3 Char(3),
f4 Varchar(8),
f5 Varchar(8),
f6 Varchar(4),
f7 Float(15),
f8 Varchar(4),
f9 Datetime,
fa Datetime)

Insert Into #test1(f1, f2, f3, f4, f5, f6, f7, f8, f9, fa)

(Select t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t1.f6, t2.f1, Sum(isnull(t1.f8,0)),
h.f9, h.fa From Table1 t1 INNER JOIN Table2 t2 ON t2.f1 = t1.f1
Where h.f1 <= Convert(Datetime,@Todt) AND h.f1 between &#34;10001&#34; AND &#34;30000&#34;
Group by t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t2.f1, t1.f6)

UNION ALL

(Select t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t1.f6, t2.f1, Sum(isnull(t1.f8,0)),
h.f9, h.fa From Table1 t1 INNER JOIN Table2 t2 ON t2.f1 = t1.f1
Where h.f1 <= between Convert(Datetime,@Frdt) AND Convert(Datetime,@Todt) AND h.f1 between &#34;40001&#34; AND &#34;50001&#34;
Group by t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t2.f1, t1.f6)

--Step2

CREATE TABLE #test2(
f1 Datetime,
f2 Varchar(5),
f3 Char(3),
f4 Varchar(8),
f5 Varchar(8),
f6 Varchar(4),
f7 Float(15),
f8 Varchar(4),
f9 Datetime,
fa Datetime)

Insert Into #test2(f1, f2, f3, f4, f5, f6, f7, f8, f9, fa)

(Select t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t1.f6, t2.f1, Sum(isnull(t1.f8,0)),
h.f9, h.fa From Table3 t1 INNER JOIN Table4 t2 ON t2.f1 = t1.f1
Where h.f1 <= Convert(Datetime,@Todt) AND h.f1 between &#34;00003&#34; AND &#34;00006&#34; AND t1.f3 IN(&#34;AA&#34;, &#34;AS&#34 AND t1.f5= &#34;0009&#34;
Group by t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t2.f1, t1.f6)

UNION ALL

(Select t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t1.f6, t2.f1, Sum(isnull(t1.f8,0)),
h.f9, h.fa From Table3 t1 INNER JOIN Table4 t2 ON t2.f1 = t1.f1
Where h.f1 <= between Convert(Datetime,@Frdt) AND Convert(Datetime,@Todt) AND h.f1 between &#34;00006&#34; AND &#34;00008&#34; AND t1.f3 IN(&#34;AA&#34;, &#34;AS&#34 AND t1.f5= &#34;0009&#34;
Group by t1.f1, t1.f2, t1.f3, t1.f4, t1.f5, t2.f1, t1.f6)


(Select * From #test1
Where (f1=&#34;fdg&#34; AND f2 IN(&#34;01&#34;,&#34;41&#34)
OR (f1=&#34;wer&#34; AND f2 IN(&#34;00&#34;,&#34;40&#34;,&#34;43&#34;,&#34;90& #34)
UNION ALL
(Select * From #test2)

Regards
Bob