No comments allowed where 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
Right views don't allow comments, I don't think there is a work around for
that.
But in 2005, you can add extended property to the view, and store all the
documentation for the view in that property. Hopefully that gives you some
ideas.
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Marcus" wrote:

> 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
>
|||Thanks, Mohit. I reposted this thread as I misspelled the title (tried
to delete the post but guess it didn't work). Apparently comments are
allowed. See Dan Guzman's response to my repost.
Marcus
On Jul 5, 10:42 am, Mohit K. Gupta <mohitkgu...@.msn.com> wrote:[vbcol=seagreen]
> Right views don't allow comments, I don't think there is a work around for
> that.
> But in 2005, you can add extended property to the view, and store all the
> documentation for the view in that property. Hopefully that gives you some
> ideas.
> Thanks!
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
> "Marcus" wrote: