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 upd
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
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