Hi New_DBA,
see how to edit tasks https://technet.microsoft.com/en-US/library/ms190914%28v=SQL.105%29.aspx
Open maintenance Plans->Right click Modify. Select the task(Update statistics)->right click ->Edit. Make necessary changes. Once done Click save and you are done
I did try that but i am not able to edit.
We have both tables and view
We have both tables and views for update statistics. But i cant remove one view from the script.
I can only edit either table or view. But, we have both.
i.e Table A, B ,C and View D,E and F.
I would like to remove only View D from above MP.
And then when you try so, what happens?
I got your concern and I think this link answers that,,
https://www.simple-talk.com/sql/database-administration/rebuilding-indexes-using-the-ssms-database-maintenance-wizard/
Also as a suggestion inorder to achieve what you looking for you would need top create multiple update statisitcs task and then add tables first select required ones and then vies in another task and choose desired ones. But the best option will be to script out tsql and create it as a sql agent job and schedule as required.
https://msdn.microsoft.com/en-us/library/ms187348.aspx
I would like to remove only View D from above MP.
Why only just one view? In such a standard maintenance task you can not select single object; all or nothing. Create your individual Job to achieve you requirements.