SQL Server 2000 - 'PROCESS_TAGS' job crashes SQL, gives error "General Network Error"
Posted on 2005-05-12
The ecommerce software that we run schedules a job to run at certain intervals (currently set at 5 mins) to send out email notifications for our new customers, and their orders through our website.
Yesterday, at 10:40 the job started failing, and each time it does, the SQL server reboots.
Here's the step of the job that causes the crash:
DECLARE @dbName varchar(255)
SET @dbName = db_name()
EXEC Master.dbo.XPE_PROCESS_TAGS @dbName
Here's the error it gives for the failure:
Executed as user: OURDOMAIN\Administrator. ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 4) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
The SQL server reboots after the failure, which happens very quickly, but I have 15 users that are constantly connected to the database, so they are getting errors when whatever they are doing happens exactly when SQL is restarting. Not to mention, none of our ecommerce emails are being sent out.
Any help is appreciated, this is a pretty urgent problem, so I am awarding 500 points.