• OH!  You can script a view, and get the source columns/tables that way.  In Enterprise Manager, right click, all tasks, generate SQL script.  Click "Show All", select your view from the list and click Add.  Then click Preview to see the script. 

    Or in Query Analyzer Object Browser, right click and script to new window. 

    Steve

    edit...

    Oh wait.  You said script.  Back to the drawing board.