Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029

Author  Topic 

ygeorge
Yak Posting Veteran

68 Posts

Posted - 2003-07-15 : 12:58:02
I created a Maintenance Plan for a database on my SQL 2000 server. The maintenance plan does nothing but update the statistics used by query optimizer. Owner of the job is 'sa'. I got the following error when executing the job -

Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Then I checked the Server Logs. Here is the message on the server log -

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

I use 'sa' to login in the Registration Properties. I also tried to registered with both 'local' and 'servername', always got this error message. Another maintenance plan is setup exactly as this one, but on another database, it succeeded every time when it's executed.

Any idea why is that?

Thanks,

George

nr
SQLTeam MVY

12543 Posts

Posted - 2003-07-15 : 13:56:54
No idea why but the easy soluthion is to not use maint.exe.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-15 : 14:46:18
What service pack are you running? We need to install service pack 3a to fix an access violation in SQL Mail. Service pack 3a might fix your problem too.

Tara
Go to Top of Page

ygeorge
Yak Posting Veteran

68 Posts

Posted - 2003-07-15 : 15:19:42
The @@version is 8.00.760, so I guess it's service pack 3a.

George

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-15 : 15:22:08
Are you able to update the statistics in Query Analyzer without getting an access violation?

Tara
Go to Top of Page

ygeorge
Yak Posting Veteran

68 Posts

Posted - 2003-07-15 : 15:54:31
Good suggestion! I just ran sp_updatestats on the database and got error message on only one table -

ODBC: Msg 0, Level 19, State 1

It's a dimension table in our data warehouse database. Maybe something wrong with this table. I guess it's not difficult to figure it out.

Thanks,

George

Go to Top of Page
   

- Advertisement -