>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.

You should probably create your views in the order you want to see them. That way there is no need to SET ORDER. You can create indexes on views if you need to, though, but that will have to be done after the view is opened.