Thanks, that helps!

The one question I had though was about Views and indexes. My app opens tables and sets indexes. Can I just replace all my references to tables (USE MyTable) with Views (USE MyView) ?

If so, how do I allow my app to set indexes on Views ? (SET ORDER TO TAG..)

Or is this the totally wrong way to do it ?

I probably should have originally designed the app with views, but at that point SQL Server was something I had no designs on tackling.