URGENT!! Strange problem with sp_updatestats

[DBFan]

sp_updatestats is running fine on query analyzer, but fails inside a job with 'General Network error' after running for few minutes and updating stats for few tables..anyone had similar problem? Everything is fie with sql agent acct etc.

[rmiao]

Go to client network utility on the server and choose another netlib as default one.

[DBFan]

I have changed it to TCP/IP from named pipes but still it's giving the same error..any idea?

[rmiao]

Changed on sql server box? Check sql agent error log to see if any message there.

[DBFan]

Yes, changed on sql server box. No error messages in agent log either. Any ideas? Some other jobs also are failing abruptly with same error.

[rmiao]

What's sql version and sp level? Any related error in windows event log? Possible to reboot server to see if still have same issue?

[DBFan]

sql server 2000 w/ sp3. These problems started when we moved server to a new box and windows 2003. Previously it was on windows 2000.

The closest issue we found from MS:

http://support.microsoft.com/default...&Product=sql2k

We might end up applying this hotfix.

Any more ideas?

[rmiao]

Try that, but I don't have this issue on my win2k3/sql2k servers.

[DBFan]

Any more thoughts on this?