|
|
Posted by CK on 06/21/06 19:34
Ok so it no longer exists. Yes I code this way, but my boss prefers the
deprecated method.
"SQL Menace" <denis.gobo@gmail.com> wrote in message
news:1150915692.806340.124510@r2g2000cwb.googlegroups.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
>
Navigation:
[Reply to this message]
|