Thanks for the help worked like a charm!

Ok so I got the logging sorted out. I got a useful log that tells me what the issue is. But Im not sure how to fix it.

Here is the...

Thanks I will give that a try. Hopefully the extended info will show me whats failing.

Sorry Jeffrey if my SQL skills are not up to par with yours. We all have to start somewhere. I don't make changes...

Gail,

Many thanks for your help. I dropped the SP, and recreated it and the DB now passes a checkdb.

Would you have any idea what might cause this type of thing?...

Sorry if I sound like an idiot here.

I noticed that the first object referenced is a SP (990678627), there is another object referenced "859202161" which is a view. I'm not...

updateusage completed with no errors, a re-run of checkdb still threw the errors. I looked up the Odject_id, and it is a SP. I contacted the DB owner and he...

Thanks for the responses. I will give the suggestions a try and report back. I'm a very green SQL admin but I have to learn somewhere.

The DB in questions was...