This is great tip, very useful, but what provides the greatest benefit would be accomplishing this without manual intervention. I would like the table to be populated automatically. What's the best way to accomplish this, using triggers, stored procedures, etc... I'm not quite a newbie, but have only used stored procedures and manual import/exports.
Keep Up with TechRepublic