>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.