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]