>
> Is there a way to recreate a view/ StoredProc without dropping
> all other vies/SPs that refer it?
>
> Thanks,
> Nick
>
>

some tools will create drop and create scripts for the views and SPs which
depend on it. If the dependiency chain is not too long and you do not hit a
spot where data loss is required, then they offer a clean way to create an
update script.
Alan