Our backup job of all the system databases in a sql server 2005 maintenance plan stopped working without giving any explicit or detailed error message except "failed to execute package".
We noticed we had neglected to turn "show advanced features" config option back to 0.
The jobs worked fine again when we set the option to 0.
Is this a bug, or planned?
Does anyone know of any other things that won't work while the option is on/set to 1?
Is it the same in more recent versions of sql server?
If it's a bug, is it fixed in any newer versions?
Any information you could supply would be much appreciated.