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