OK, that was my thought, I just wasn't sure because I figured either way if you made a change to the underlying table you would have to then touch the view. It seems that if you do SELECT * then you could just write a script to step thru dbs and run sp_refreshview, but again I don't know if there are other reasons aside from just bad practice (that I thought I remembered hearing sometime in the past) to not do that...