Sorry if this evermore confusing. This particular Table(DECODED Table) has Decoded values(Descriptions) and there Codes are stored in another table(FLAT Tables) . Both these tables has Look up tables so...

I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values and...

Thanks for the reply. it looks to me there is no point in trying to squeeze COALESCE here. Do you see any other way to rewrite this in much shorter...

Thanks for all the Reply. I had tried the underline Job of this maintenance plan running with "sa" before I post it.

Even now I tried the same thing. it is...

I spoke to may manager about creating SSIS packages for handling this situation. His answer was why all other 50+ servers are working fine and not this one. He knows...

yeah this is now what we are keep doing everyday. the On-call DBA manually takes the backups of all the DBs (about 20). it is working without any issues.

Also the...

Thanks for you reply.

Yeah, we thought about adding the Scripts to a Job and run it. My Manager did not like that idea at all.

Also there is no...

Thanks all for you kind reply and spending time on this

1. I did create the Maintenance Plan multiple times without DBCC CHEKDB and also without maintenance cleanup task before I...

Here is the Maintenance plan and the Job running

Yes backups are working whenever they are taken manually. that is what our On-Call team member keep doing every single day ever since the job failed. there are over 20...

Thanks for the information. The maintenance plan worked perfectly and I have done the steps and followed the steps as mentioned. There must be an issue somewhere that I cannot...