Viewing 4 posts - 1 through 4 (of 4 total)
Thank you! It was indeed the "case" of the database name in the job step versus the name in the instance. If the database name's case matched the...
January 15, 2013 at 1:03 pm
Again, my thanks! I will download your suggested scripts and see about installing them.
In the meantime, I found a fix (work-around) to the sp_defragment_indexes script in another older posting:
"The...
October 17, 2012 at 8:44 am
You found the issue. The SP was using a call to user_name(so.uid) to set the object's schema name in the dbcc command, where the uid is the value from...
October 16, 2012 at 2:43 pm
Thanks. I did have the wrong owner (it is "Adage"). Running the showcontig with that dbo works.
That solves that mystery. However, the error remains :-(.
I also just...
October 16, 2012 at 2:04 pm
Viewing 4 posts - 1 through 4 (of 4 total)