Hi all,

I have a stored procedure, which calls a lot of stored procedures from it.
But when i tried to execute this in my backup server
it gives the error "SQL Server Terminates the process" and terminates the
process. I tried restoring the database again and again but it gives the
same error. But it works fine in the Production. When i dropped and
recreated the procedure, it works fine.

Can any one tell me why is this happening???

Thanks in advance.


Error Log:
========

02:00000:00009:2000/11/28 22:21:26.90 kernel SQL Server system exception
(0xc0000005) generated by a storage access violation.
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x6309b5 qremap__tree+
0x105 (0x2, 0x1e1fb10, 0x213ca8c0, 0x260ee244)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x6309b5 qremap__tree+
0x105 (0x260ee294, 0x1e1fb10, 0x213ca8c0, 0x260ef07c)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x630c3d qremap__tree+
0x38d (0x260ee200, 0x1e1fb10, 0x213ca8c0, 0x21fdf0b8)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x62eb5d qremap_seqnode+
0x30d (0x1e1fb10, 0x1, 0x213ca8c0, 0x21fdf0b8)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x62e776 qremap_prochdr+
0x396 (0x260ef000, 0x213ca8c0, 0x260c1000, 0x1)
02:00000:00009:2000/11/28 22:21:28.98 kernel [Handler pc: 0x633720
qremap__err installed by the following function:-]
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x62e338 qremap_compress+
0xf8 (0x21fdf0b8, 0x260c1000, 0x213ca8c0, 0x25d9bc18)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x640dd3 s_recrtproc+ 0x83
(0x260c1000, 0x260ef000, 0x6, 0x6)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x640d24 s_renormalize+
0x164 (0x6, 0x213ca8c0, 0x81a, 0x25d9bc18)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x640b9a s_recompile+
0x40a (0x260c1000, 0x213ca8c0, 0x20010a20, 0x0)
02:00000:00009:2000/11/28 22:21:28.98 kernel [Handler pc: 0x6412a0 s_handle
installed by the following function:-]
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x63e443 sequencer+ 0x443
(0x25d9bba0, 0x25d9bc18, 0x0, 0x0)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x6629e1 execproc+ 0x2d1
(0x213ca8c0, 0x213ca8c0, 0x213ca8c0, 0x21344570)
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x65d00a s_execute+ 0x234a
(0x25ec6800, 0x213ca8c0, 0x21, 0x213ca8c0)
02:00000:00009:2000/11/28 22:21:28.98 kernel [Handler pc: 0x6412a0 s_handle
installed by the following function:-]
02:00000:00009:2000/11/28 22:21:28.98 kernel pc: 0x63e15f sequencer+ 0x15f
(0x0, 0x2001b094, 0x190019, 0x20019f84)
02:00000:00009:2000/11/28 22:21:29.00 kernel pc: 0x4375d1 tdsrecv_language+
0xc1 (0x2, 0x4000, 0x2001b094, 0x190019)
02:00000:00009:2000/11/28 22:21:29.00 kernel [Handler pc: 0x453240
hdl_backout installed by the following function:-]
02:00000:00009:2000/11/28 22:21:29.00 kernel [Handler pc: 0x5c6b00
ut_handle installed by the following function:-]
02:00000:00009:2000/11/28 22:21:29.00 kernel [Handler pc: 0x5c6b00
ut_handle installed by the following function:-]
02:00000:00009:2000/11/28 22:21:29.00 kernel pc: 0x40c32c conn_hdlr+ 0xbac
(0x2001b094, 0x20019f84, 0x190019, 0x2001b094)
02:00000:00009:2000/11/28 22:21:29.00 kernel pc: 0x86c756 kpntwrapper+ 0x96
(0x0, 0x0, 0x0, 0x0)
02:00000:00009:2000/11/28 22:21:29.00 kernel pc: 0x77f04ede KERNEL32.dll
(0x1, 0x25d9bba0, 0x25d9bc18, 0x0)
02:00000:00009:2000/11/28 22:21:29.00 kernel end of stack trace, spid 9,
kpid 1703962, suid 64
02:00000:00009:2000/11/28 22:21:29.00 kernel
************************************
02:00000:00009:2000/11/28 22:21:29.00 kernel SQL causing error : execute
SP_blg_billpost_main
02:00000:00009:2000/11/28 22:21:29.01 kernel
************************************
02:00000:00009:2000/11/28 22:21:29.01 server SQL Text: execute
SP_blg_billpost_main
02:00000:00009:2000/11/28 22:21:29.01 kernel curdb = 5 pstat = 0x10000
lasterror = 0
02:00000:00009:2000/11/28 22:21:29.01 kernel preverror = 0 transtate = 1
02:00000:00009:2000/11/28 22:21:29.01 kernel curcmd = 224 program = - Bill
Generation
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x8b56a7
os_get_cur_stk_desc+ 0x57 (0x1e1eeb8, 0x1a001a, 0x1e1eeb8, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x8b56a7
os_get_cur_stk_desc+ 0x57 (0x1e1eeb8, 0x1e1f40c, 0x270f, 0x2)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x895104 pcstkwalk+ 0x224
(0x1a001a, 0x2, 0x270f, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x894c9e ucstkgentrace+
0x1ce (0x1a001a, 0x1, 0xc0000005, 0x213ca8c0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x8735e4 ucbacktrace+ 0x84
(0x1a001a, 0xffffffff, 0x1110, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x405f91
terminate_process+ 0x591 (0xc0000005, 0x7800885f, 0x1e1f800, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x86bb6e kiexception+
0x1ee (0x2001b094, 0x20019f84, 0x190019, 0x2001b094)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x86c7cd kpntwrapper+
0x10d (0x0, 0x0, 0x0, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel pc: 0x77f04ede KERNEL32.dll
(0x1, 0x25d9bba0, 0x25d9bc18, 0x0)
02:00000:00009:2000/11/28 22:21:29.01 kernel end of stack trace, spid 9,
kpid 1703962, suid 64