Below is the code and te error message I receive. The query works when you make the string shorter, otherwise the error occurs. More info: SQL 2000, SP2, 2gig mb. This query works on two other SQL2000 servers.

SELECT TOP 200 td.ParentID, td.ChildID, td.ContentID, td.ContentTypeID, td.Title, td.Content, td.Author, td.LastModifiedOn, td.Dir, td.isleaf FROM vw_Search td WHERE ( parentID IN (9,774,73,85,61,97,103,115,127,36,798,59,788,46,58 ,51,770,63,794,37,62,777,65,53,781,57,109,79,67,55 ,91,66,54,121,64,802,56))|
Microsoft OLE DB Provider for SQL Server error '80040e14'

SqlDumpExceptionHandler: Process 67 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

/, line 97