>>Has anyone experienced connection problems when dealing with views pointed at large Sybase tables on Win2K servers? (like 7-8 figure record counts)
>
>Is it possible a view or cursor is hitting the 2GB limit? If so, I don't know if NODATA will help you or not.

No they never exceed the limit. If it did I would have more than a broken connection problem. The issue only happened once but we would like to know why for future reference. Thanks.