Posted by SQL Menace on 06/21/06 18:48

right click the view-->modify

But if I was you I would use: right click the view-->Script View
as-->ALTER to-->New Query editor window instead
The designer doesn't support everything, for example CASE
Designers are great to learn but you should code everything yourself,
that way you have full control


Denis the SQL Menace
http://sqlservercode.blogspot.com/

CK wrote:
> Previously in Sql Server 2000, we would be in enterprise manager, you'd
> double click on a view, and a nice little dialog box opened with the t-sql
> statetments, there was also a check sql syntax and apply and cancel buttons.
> Not exactly query anaylizer, just a quick lightweight dialog box. Is this
> feature still around? Seems like I have to go into the query anaylizer like
> mode to edit a view now. I am a total newbie to version 2005. Are there any
> options I can set to make it behave the old way? All feedback is
> appreciated.
> TIA,
> ~CK

• Next in forum: Re: Ambiguous Column Names in Multi-Table Join
• Prev in forum: Sql Server 2005 questions regarding editing views
• Thread view: Re: Sql Server 2005 questions regarding editing views

[Reply to this message]