Cannot view or edit header comments in Views upgraded from SQL 2000 to 2005
Posted on 2007-03-28
In SQL 2000, you could put a view into an edit window and add comments below the name. In SQL 2005 I am not finding a way to add comments to my View or change existing comments from Views upgraded from 2000. The only time I see the comments is when I script the view out. But if I change it there and then try to save it, I get a prompt to save a new project query. How can I see and modify header comments for views in 2005 similar to 2000?