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 |
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-04-03 : 03:57:54
|
I am trying to schedule a SISS package by creating a new job but it is giving me error when the job executes.the error i find when i checked the error log it was the following error Unable to find index entry in index ID 1, of table 2073058421, in database 'msdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (ConnExecuteCachableOp)Any help would be appriciated |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-03 : 09:48:29
|
Kirun,Did you try fixing the index issue that the error message is referring to? |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-04-07 : 01:28:19
|
I really dont know how to fix it .. can any body help |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-04-09 : 02:47:55
|
I figured it out .. i tried and execute this and error was goneUse msdbGosp_dboption 'msdb', 'single_user', 'true'GODBCC CHECKDB('msdb', REPAIR_REBUILD) Explaination for dboption single user : I was getting this error "Msg 7919, Level 16, State 3, Line 1 Repair statement not processed. Database needs to be in single user mode." thats why i had to used the single user. |
|
|
|
|
|