Hi,

thanks for your answer. Normally I modify stored procedure that may
be in use while I apply the ALTER clause. As I can't control whether it
is or not in use in that moment, I guess that the most conservative
approach is to shut down the database, login as SYSOP, apply the
metadata updates and then put the database online again.

Aldo

El 08/08/12 04:52, Sofija Blazevski escribió:

>
> Hi,
>
> it depends on what you are trying to do. If you are modifying metadata
> of objects that are in use, you wont be able to make changes.
> if you're adding new objects, you will not have a problem.
>
> - Sofija
>
> On 6.8.2012 14:16, Aldo Caruso wrote:
> >
> > Hi,
> >
> > Normally, when I make a modificacion to the metadata ( DDL ) I shut
> > down the database because it is not clear to me what happens if I alter
> > a table or a stored procedure while it is being used or invoked by
> > another user.
> > Is it actually necessary to shut down the database in order to do
> > metadata changes in a production environment ?
> >
> > Thanks in advance,
> > Aldo Caruso
> >
> >
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]