>HI
>
>I want to document (briefly) some views in a database.
>
>I can't see any way to attach some description to the view.
>
>http://www.adivo.com/doc/database/SqlServer2005.html
>
>tells me if I right click on the view I should be able to select design and add a description.
>
>But I don't get a design option if I right click (I assume that may be part of SQL2008) .
>
>Anyone know the best way to document a SQL2005 view.


Open table for design and press F4 (or View->Properties Window). That will bring you Properties Window.