Connection Broken - SQL 7.0 db migration to SQL 2000

Hi there,
I am trying to upgrade our sql server db from version 7.0
to version 2000. I was successly able to restore the sql
7.0 db into 2000 server. Everything seems to be working
fine except one important stored procedure.
When i execute this particular stored procedure,it works
fine for 2 attempts but crashes the server on the thrid
attempt. The error message i am getting is as follows:
[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
It will be great help if someone could shed some light on
this issue.
Thanks,
Savvy.Hi
Rebuild all your indexes. I have seen this when the statistics get out of
date and you upgrade your DB.
Regards
Mike
"Savvy" wrote:
> Hi there,
> I am trying to upgrade our sql server db from version 7.0
> to version 2000. I was successly able to restore the sql
> 7.0 db into 2000 server. Everything seems to be working
> fine except one important stored procedure.
> When i execute this particular stored procedure,it works
> fine for 2 attempts but crashes the server on the thrid
> attempt. The error message i am getting is as follows:
> [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
> It will be great help if someone could shed some light on
> this issue.
> Thanks,
> Savvy.
>