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.
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. |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 1It'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 |
|
|
|
|
|