Не могу понять причину подобного поведения SQL2000, например:

create table dbo.a1 (id int, c_id int)
create table dbo.a2 (id int, c_id int)
GO
create view v1 as
select
id,
c_id,
b_id=-1
from a1
union
select
id,
c_id,
b_id=c_id
from a2
GO
Select * From v1
Where b_id in (
1,2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,
111,112,113,114,115,116,117,118,119,21,21,22,23,24,
25,26,27,28,29,31,32,33,34,35,36,37,38,39)
GO


[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

Как с этим бороться, кто знает?

Вот вывод xp_msver

1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.608
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.0608.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2001 Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 39845888 NULL
15 WindowsVersion 143851525 5.0 (2195)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 255 255 (267874304)
20 Product ID NULL NULL

Спасибо, придется отложить переход, вечно они экономят там где не нужно :-((