Home > Archive > MS SQL Data Warehousing > February 2006 > Problem in "correcting minior problems in indexes"









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Problem in "correcting minior problems in indexes"
M_Tarvirdi

2006-02-01, 3:23 am

I have a light database with some tables. I created a maintenance plan and
want to check index integrity. And also solve minor problems. but when it
runs I get bellow error
"Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). The step failed."
when I uncheck "solve minor problems" I don't get any problem. to find
problem I delete my tables one by one and try again but get same error. at
last I deleted all tables but error remains!!!!
what is the problem?
Thanks
Tarvirdi


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com