есть запpос, выполнение в QA котоpого может yвенчаться yспехом, а может и дать
ошибкy:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

что это такое? в BOL не нашел...

сервер не падает. да,забыл, запрос может еще вернуть пустой резалтсет, хотя я точно знаю, что
он не должен быть пустой.

select distinct
v1.InvNum as [Инв.№],
itdgp.dbo.SerL2Naim(v1.SerCode) as [Серия],
v1.BoardNum as [Борт.№],
t1.TrOrdNum,
t1.SaidTrSpdDT as [Богд-ч],
t2.TrOrdNum,
t2.SaidTrSpdDT as [Исток],
t1.GrNum as [Граф.№],
itdgp.dbo.STAN2SNAZV(t1.OpStCode) as [Станция],
itdgp.dbo.OPKOD2SN(t1.OpCode) as [Опер.],
t1.OpTime
from
(T_SAID_TRAIN as t1
inner join T_SAID_VAGON as v1 on t1.SaidTrUniqueNum = v1.SaidTrUniqueNum)
left join
(T_SAID_TRAIN as t2
inner join T_SAID_VAGON as v2 on t2.SaidTrUniqueNum = v2.SaidTrUniqueNum)
on
(v2.InvNum = v1.InvNum) and
(t2.DevName = 'ISTOK_06') and
(DATEDIFF (hh, t1.SaidTrSpdDT, t2.SaidTrSpdDT) between 1 and 5)
where
t1.DevName = 'S_BGDA'
order by
t1.SaidTrSpdDT

вот подробности из EM -> Management -> Log :

language_exec: Process 59 generated an access violation. SQL Server is terminating this process..

Error: 0, Severity: 19, State: 0

к сожалению, не могу отправить дамп на мелкософт (там серийный номер надо указывать) ...
посмотрел, вроде прj такой сбой нет информации _нигде_ (( далее привожу дамп, на всякий случай...

Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00026.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/21/02 08:49:11 spid 59
*
* Exception Address = 004181B4 (FastDBCSToUnicode + 00000061 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000135BA
* Input Buffer 1556 bytes -
* select distinct v1.InvNum as [И в.№], itdgp.dbo.SerL2Naim(v1.SerCo
* de) as [Се ], v1.BoardNum as [Б .№], t1.TrOrdNum, t1.SaidTr
* SpdDT as [Б гд- ], t2.TrOrdNum, t2.SaidTrSpdDT as [И ], t1.G
* rNum as [Г а .№], itdgp.dbo.STAN2SNAZV(t1.OpStCode) as [С а ],
* itdgp.dbo.OPKOD2SN(t1.OpCode) as [О е .], t1.OpTime from (T_SAID_
* TRAIN as t1 inner join T_SAID_VAGON as v1 on t1.SaidTrUniqueNum =
* v1.SaidTrUniqueNum) left join (T_SAID_TRAIN as t2 inner
* join T_SAID_VAGON as v2 on t2.SaidTrUniqueNum = v2.SaidTrUniqueNum) o
* n (v2.InvNum = v1.InvNum) and (t2.DevName = 'ISTOK_06') and
* (DATEDIFF (hh, t1.SaidTrSpdDT, t2.SaidTrSpdDT) between 1 and 5) wher
* e t1.DevName = 'S_BGDA' order by t1.SaidTrSpdDT
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 77E80000 77F34FFF 000b5000
* ADVAPI32 77DB0000 77E0AFFF 0005b000
* RPCRT4 77D40000 77DABFFF 0006c000
* USER32 77E10000 77E73FFF 00064000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78045FFF 00046000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 75170000 751BEFFF 0004f000
* SECUR32 77BE0000 77BEEFFF 0000f000
* NETRAP 751C0000 751C5FFF 00006000
* SAMLIB 75150000 7515FFFF 00010000
* WS2_32 75030000 75042FFF 00013000
* WS2HELP 75020000 75027FFF 00008000
* WLDAP32 77950000 77978FFF 00029000
* DNSAPI 77980000 779A3FFF 00024000
* WSOCK32 75050000 75057FFF 00008000
* wmi 76110000 76113FFF 00004000
* ole32 77A50000 77B39FFF 000ea000
* XOLEHLP 65450000 65457FFF 00008000
* MSDTCPRX 68C60000 68D0EFFF 000af000
* MTXCLU 6A7A0000 6A7AFFFF 00010000
* VERSION 77820000 77826FFF 00007000
* LZ32 759B0000 759B5FFF 00006000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 77C10000 77C6CFFF 0005d000
* rnr20 785C0000 785CBFFF 0000c000
* iphlpapi 77340000 77352FFF 00013000
* ICMP 77520000 77524FFF 00005000
* MPRAPI 77320000 77336FFF 00017000
* OLEAUT32 779B0000 77A4AFFF 0009b000
* ACTIVEDS 773B0000 773DDFFF 0002e000
* ADSLDPC 77380000 773A1FFF 00022000
* RTUTILS 77830000 7783DFFF 0000e000
* SETUPAPI 77880000 7790CFFF 0008d000
* RASAPI32 774E0000 77511FFF 00032000
* RASMAN 774C0000 774D0FFF 00011000
* TAPI32 77530000 77551FFF 00022000
* COMCTL32 77B50000 77BD8FFF 00089000
* SHLWAPI 77C70000 77CB9FFF 0004a000
* DHCPCSVC 77360000 77378FFF 00019000
* CLBCATQ 775A0000 77624FFF 00085000
* winrnr 777E0000 777E7FFF 00008000
* rasadhlp 777F0000 777F4FFF 00005000
* SSNETLIB 42CF0000 42D05FFF 00016000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 75500000 75503FFF 00004000
* msafd 74FD0000 74FEEFFF 0001f000
* wshtcpip 75010000 75016FFF 00007000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 77BF0000 77C00FFF 00011000
* rsabase 7CA00000 7CA21FFF 00022000
* CRYPT32 77440000 774B4FFF 00075000
* MSASN1 77430000 7743FFFF 00010000
* sqloledb 75370000 753E8FFF 00079000
* MSDART 3ABD0000 3ABF2FFF 00023000
* comdlg32 76B30000 76B6DFFF 0003e000
* SHELL32 782F0000 78531FFF 00242000
* MSDATL3 3AC00000 3AC15FFF 00016000
* oledb32 3AEA0000 3AF0EFFF 0006f000
* OLEDB32R 3AF10000 3AF20FFF 00011000
* xp_bnotif 3AF30000 3AF46FFF 00017000
* SQLFTQRY 41020000 41051FFF 00032000
* msv1_0 782D0000 782EDFFF 0001e000
* xpsqlbot 42F00000 42F05FFF 00006000
* xpstar 410F0000 41135FFF 00046000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 42C40000 42C56FFF 00017000
* ODBC32 3B3E0000 3B414FFF 00035000
* odbcbcp 41150000 41156FFF 00007000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* WINSPOOL 77800000 7781CFFF 0001d000
* SHFOLDER 75AA0000 75AA7FFF 00008000
* odbcint 3B520000 3B535FFF 00016000
* NDDEAPI 769A0000 769A6FFF 00007000
* SQLSVC 43970000 43975FFF 00006000
* xpstar 439E0000 439E8FFF 00009000
* adsldp 74D90000 74DB0FFF 00021000
* xplog70 42EA0000 42EB1FFF 00012000
* xplog70 439D0000 439D3FFF 00004000
* dbghelp 72A00000 72A2CFFF 0002d000
*
* Edi: 00000003:
* Esi: 000135BA:
* Eax: 00000001:
* Ebx: 0000000F:
* Ecx: 0000000F:
* Edx: 3B1DBED0: 2109ED40 00000000 00000001 2109F228 3B1DBF74 3B1DBF00
* Eip: 004181B4: C1F70E8B 80808080 00C8850F C18B0000 0025D98B 8300007F
* Ebp: 3B1DBE9C: 3B1DBF00 00597725 0000000F 3B1DBED0 0000000F 3B1DBF2C
* SegCs: 0000001B:
* EFlags: 00010207: 43003B00 5C003A00 49005700 4E004E00 3B005400 3A004300
* Esp: 3B1DBE88: 0000001E 3B1DBED0 0000000F 00000000 000135BA 3B1DBF00
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 004181B4 Module(sqlservr+000181B4) (FastDBCSToUnicode+00000061)
* 00597725 Module(sqlservr+00197725) (CbTranslate+00000079)
* 006A1F24 Module(sqlservr+002A1F24) (CXVariant::StrConvertFromStr+00000099)
* 004357B2 Module(sqlservr+000357B2) (CXVariant::PerformConvertToStr+000004E5)
* 0043260D Module(sqlservr+0003260D) (CXVariant::ConvertToTi+000004FB)
* 004FFEA9 Module(sqlservr+000FFEA9) (CScaOp_Convert::CalcSelectivity+000000E3)
* 004462B6 Module(sqlservr+000462B6) (CScaOp_Intrinsic::CalcSelectivity+000000FF)
* 00550E50 Module(sqlservr+00150E50) (CLogOp_Project::DeriveGroupProperties+0000052
* 00540BC2 Module(sqlservr+00140BC2) (COpArg::DeriveNormalizedGroupProperties+0000001B)
* 00540B4E Module(sqlservr+00140B4E) (COptExpr::DeriveGroupProperties+000000B3)
* 0054C7A5 Module(sqlservr+0014C7A5) (CCvtTree::PexprFromTree+0000032D)
* 0054C465 Module(sqlservr+0014C465) (CCvtTree::PqryFromTree+0000024C)
* 0054C230 Module(sqlservr+0014C230) (BuildQueryFromTree+00000046)
* 0054C19D Module(sqlservr+0014C19D) (CStmtQuery::InitQuery+0000013E)
* 004547A8 Module(sqlservr+000547A (CStmtAssignWithQuery::Init+00000043)
* 005353AC Module(sqlservr+001353AC) (CCompPlan::FCompileStep+000009C1)
* 0053BD8F Module(sqlservr+0013BD8F) (CProchdr::FCompile+00000D23)
* 004106AD Module(sqlservr+000106AD) (CSQLSource::FTransform+0000034C)
* 0043035E Module(sqlservr+0003035E) (CSQLObject::FTransform2+000004D9)
* 0046B878 Module(sqlservr+0006B87 (CSQLObject::FGetFromDisk+0000085B)
* 0042FC3F Module(sqlservr+0002FC3F) (CSQLObject::FTransform+0000035B)
* 00410092 Module(sqlservr+00010092) (CSQLSource::Execute+0000015B)
* 005E7F40 Module(sqlservr+001E7F40) (CSQLObject::ExecuteFunction+0000014A)
* 005BD55C Module(sqlservr+001BD55C) (UDFInvoke+0000019B)
* 00419CFF Module(sqlservr+00019CFF) (CEs::GeneralEval4+00000075)
* 005285CE Module(sqlservr+001285CE) (CQScanSort::BuildSortTable+00000065)
* 00528560 Module(sqlservr+00128560) (CQScanSort::Open+00000032)
* 0041D92F Module(sqlservr+0001D92F) (CQueryScan::Startup+0000010D)
* 0041925F Module(sqlservr+0001925F) (CStmtQuery::ErsqExecuteQuery+0000026B)
* 00432F55 Module(sqlservr+00032F55) (CStmtSelect::XretExecute+00000229)
* 0040F403 Module(sqlservr+0000F403) (CMsqlExecContext::ExecuteStmts+000002D9)
* 0040EA95 Module(sqlservr+0000EA95) (CMsqlExecContext::Execute+000001B6)
* 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
* 0053C498 Module(sqlservr+0013C49 (language_exec+000003E1)
* 00411099 Module(sqlservr+00011099) (process_commands+000000EC)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800A27B Module(MSVCRT+0000A27B) (beginthread+000000CE)
* 77E8758A Module(KERNEL32+0000758A) (SetFilePointer+0000018A)
* -------------------------------------------------------------------------------

1. pogues:

>У нас была аналогичная ошибка при обработке больших объемов данных. Причем странно (примерно
> так)
>Помого SP2

SP2 состоит из:
- SQL2KSP2.exe (Database Components SP2)
- SQL2KASP2.exe (Analysis Services SP2)
- SQL2KDeskSP2.exe (Desktop Engine SP2)

мы ставили только SQL2KSP2. надо ли ставить остальные (вы ставили) ?

2. Макс:

да, запрос сложный, но дело в том, что это неоперативный запрос, и он не заточен под
какое-либо приложение. я не намерен его оптимизировать, главное - работает. и потом,
разве я нарушил какие-либо требования для составления запроса?

Дед Маздай:
>Описанная Вами ситуация соответствует Q299575:

да, почитал http://support.microsoft.com/default.aspx?scid=kb;en-us;Q299575
но, однако, в списке "List of Fixes in Microsoft SQL Server 2000 SP2" ссылки на этот Q нет, да и в постфиксе 8.00.0608_SQL2K_sp2_x86_enu.exe - тоже. сейчас скачал постфикс, установил - пока ошибок не возникало, может и действительно пофиксили.