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,
MarcusRight 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 som
e
> ideas.
> Thanks!
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
> "Marcus" wrote:
>

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,
MarcusRight 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:
> 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

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:

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

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,
MarcusI 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.googlegroups.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
> Dan Guzman
> SQL Server MVP
> "Marcus" <holysmoke...@.hotmail.com> wrote in message
> news:1183656714.354511.114570@.g37g2000prf.googlegroups.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

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,
MarcusI 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.googlegroups.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.googlegroups.com...
>
>