Update view using derived key in Database
The with some modification the view should be updateable, but not in its current form.
https://msdn.microsoft.com/en-au/library/ms187956.aspx gives the rules for Partitioned Views

Some things you would need to change: 


MessageTech column would need to be part of the underlying tables
MessageTech needs to be part of the primary key of each underlying table
MessageTech needs to have constraints on it in each table such that a given value could not possibly refer to more than one table e.g.




ALTER TABLE MessageCentre Add 
    MessageTech char(1) Not Null Default 'S',
    Constraint chk_MessageTechIs_S Check (MessageTech = 'S');


There are some other conditions too, which you can read about in that link, but those are the obvious changes that would need to occur.