Sql Server 2005 questions regarding editing views

[CK]

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

[SQL Menace]

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

[CK]

Ok so it no longer exists. Yes I code this way, but my boss prefers the
deprecated method.

"SQL Menace" <de********@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.com...

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