Actually it is a distributed query. I wrote an AFTER TRIGGER that will fetch information from six tables that will be SMS content and insert into a remote database's VIEW. In addition to, I formatted the SMS body as business requirements from the database information.
then you would be experiencing performance issues soon .
your AFTER trigger approach(Working on 6 table) will be synchronous approach to play with data (plus remote database migration too), i will say to manage the load , you need to go with asynchronous approach like Service Broker
. sooner or later you wil find it beneficial .
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)