2005 Management Studio -- Reformats my source!

9 Nov 2005 7:16 PM

ZippyThePinhead

Minor issues that are driving me crazy about this tool:

1. I type in a new view and format it the way it makes sense to me. I hit
the Save button, and SqlMS decides it wants to format it a completely
different way. How can I turn this feature off, or tell the program how I
want it to format my code? Older versions of EM did not reformat the code.

2. When I create a new view, the Diagram, Results and Criteria panes
automatically display. I have to click the buttons to hide them each time.
I don't need them or want them taking up editing space. How can I make the
program remember that I don't want it to display these "helpful" windows
each time?

Please advise

14 Nov 2005 5:01 PM

ZippyThePinhead

no help or resolution here?

Show quote

"ZippyThePinhead" wrote:

> Minor issues that are driving me crazy about this tool:
>
> 1. I type in a new view and format it the way it makes sense to me. I hit
> the Save button, and SqlMS decides it wants to format it a completely
> different way. How can I turn this feature off, or tell the program how I
> want it to format my code? Older versions of EM did not reformat the code.
>
> 2. When I create a new view, the Diagram, Results and Criteria panes
> automatically display. I have to click the buttons to hide them each time.
> I don't need them or want them taking up editing space. How can I make the
> program remember that I don't want it to display these "helpful" windows
> each time?
>
> Please advise
>
>

25 Nov 2005 7:20 PM

Peter A. Schott

Why not create the view as a CREATE VIEW statement inside of a Query window? I
don't seem to have any issues when I do that. Of course, you will need to
choose ALTER - Script to New Window/Clipboard in order to modify the code
instead of choosing Modify as Modify defaults to that view.

-Pete Schott

ZippyThePinhead <ZippyThePinh***@discussions.microsoft.com> wrote:

Show quote

> no help or resolution here?
>
> "ZippyThePinhead" wrote:
>
> > Minor issues that are driving me crazy about this tool:
> >
> > 1. I type in a new view and format it the way it makes sense to me. I hit
> > the Save button, and SqlMS decides it wants to format it a completely
> > different way. How can I turn this feature off, or tell the program how I
> > want it to format my code? Older versions of EM did not reformat the code.
> >
> > 2. When I create a new view, the Diagram, Results and Criteria panes
> > automatically display. I have to click the buttons to hide them each time.
> > I don't need them or want them taking up editing space. How can I make the
> > program remember that I don't want it to display these "helpful" windows
> > each time?
> >
> > Please advise
> >
> >

1 Dec 2005 7:32 PM

Jim

Thanks Peter -- yes that certainly does work, but it's a pain in the rear to
have to manage this myself..which is what I have been doing lately.

There simply needs to be some options available in the program to stop the
auto-formatting of our code. I've noticed that sometimes it even messes
things up by adding "as exp1" expressions on columns the parser thinks are
misnamed!

Show quote

"Peter A. Schott" wrote:

> Why not create the view as a CREATE VIEW statement inside of a Query window? I
> don't seem to have any issues when I do that. Of course, you will need to
> choose ALTER - Script to New Window/Clipboard in order to modify the code
> instead of choosing Modify as Modify defaults to that view.
>
> -Pete Schott
>
> ZippyThePinhead <ZippyThePinh***@discussions.microsoft.com> wrote:
>
> > no help or resolution here?
> >
> > "ZippyThePinhead" wrote:
> >
> > > Minor issues that are driving me crazy about this tool:
> > >
> > > 1. I type in a new view and format it the way it makes sense to me. I hit
> > > the Save button, and SqlMS decides it wants to format it a completely
> > > different way. How can I turn this feature off, or tell the program how I
> > > want it to format my code? Older versions of EM did not reformat the code.
> > >
> > > 2. When I create a new view, the Diagram, Results and Criteria panes
> > > automatically display. I have to click the buttons to hide them each time.
> > > I don't need them or want them taking up editing space. How can I make the
> > > program remember that I don't want it to display these "helpful" windows
> > > each time?
> > >
> > > Please advise
> > >
> > >
>