Rick Debay wrote:

>> I hope that "practically impossible" doesn't indicate that you're
> trying to this change while the database is online.
>
> Practically impossible means that the field is referenced in dozens of
> views and stored procedures, which then seem to be referenced
> themselves. Each of these little fleas have lesser fleas, and so ad
> infinitum, and each is biting (to butcher Augustus de Morgan).
>

Happened to me sometimes. What I generally do is extract *all* metadata
in a script. Search and replace with a nice editor and then create a new
database, lastly pump the data into the "new" DB and bring it online.
This is in the (rare) cases when I judge that it's too painful to do it
"manually".

HTH,

/Dany