SQL 2005 Find and replace

30 Jun 2006 4:18 PM

DWalker

When I am in the Management Studio, and editing a view (using Modify View),
Find and Replace doesn't let me change things in the SQL part of the view
definition. Is this by design?

When editing a view, Quick Find and Quick Replace are grayed out. Why?

Using Replace in Files, whe I try to replace some word or text that appears
in the SQL pane of a view definition, I'm told that the specified text was
not found.

It doesn't matter what I use for "Look In".

Is this working as designed?

Thanks.

David Walker

6 Jul 2006 10:40 PM

Keith Kratochvil

It seems as though that part of the tool (SSMS) does not support find and
replace. Can I suggest that you store the source code for your views,
functions, stored procedures and so on in text files that you can check into
your source code repository? When you need to make a change you can go to
your source code, grab the script that contains the object that you want to
modify, make the changes, and then check the item back in to source control.

--
Keith Kratochvil

Show quote

"DWalker" <n***@none.com> wrote in message
news:%23aWzdDGnGHA.4856@TK2MSFTNGP05.phx.gbl...
> When I am in the Management Studio, and editing a view (using Modify
> View),
> Find and Replace doesn't let me change things in the SQL part of the view
> definition. Is this by design?
>
> When editing a view, Quick Find and Quick Replace are grayed out. Why?
>
> Using Replace in Files, whe I try to replace some word or text that
> appears
> in the SQL pane of a view definition, I'm told that the specified text was
> not found.
>
> It doesn't matter what I use for "Look In".
>
> Is this working as designed?
>
> Thanks.
>
> David Walker