No comments allowed when creating a View?

I have a fairly complex view that I would like to annotate with some
comments. It seems that whenever I save the view, the comments are
stripped out. I find this rather annoying. Don't suppose there is
anyway around this?
Thanks,
Marcus
I assume you are using a designer to create the view? Instead, create the
view directly using a Query Analyzer or SQL Serve Management Studio query
window.
Hope this helps.
Dan Guzman
SQL Server MVP
"Marcus" <holysmokes99@.hotmail.com> wrote in message
news:1183656714.354511.114570@.g37g2000prf.googlegr oups.com...
>I have a fairly complex view that I would like to annotate with some
> comments. It seems that whenever I save the view, the comments are
> stripped out. I find this rather annoying. Don't suppose there is
> anyway around this?
> Thanks,
> Marcus
>
|||On Jul 5, 10:37 am, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> I assume you are using a designer to create the view? Instead, create the
> view directly using a Query Analyzer or SQL Serve Management Studio query
> window.
> --
> Hope this helps.
Thanks, Dan. I see now. If I right click on the view in SQL Server
Management Studio and then select "modify", it brings up the designer
which strips out the comments. However, if I right click on the view
and select "script view as-->alter to--> new query editor window"
then the comments are there. Don't really care for these extra steps,
but can live with that.
Cheers,
Marcus
[vbcol=seagreen]
> Dan Guzman
> SQL Server MVP
> "Marcus" <holysmoke...@.hotmail.com> wrote in message
> news:1183656714.354511.114570@.g37g2000prf.googlegr oups.com...
>
sql