This can happen if you have active connections and they have been or are
using the SP. Are you sure you dont have views or computed fields using
SPs ?



Gianni Rossi wrote:

>Hi,
>
>I'm try to alter/drop a stored procedure but every time I try I get the
>message :
>
>"Error at line 1 - unsuccessful metadata update
>cannot delete
>COLUMN NREFERENCIA
>there are 1 dependencies"
>
>I have removed ALL stored procedures that call this procedure, looked
>everywhere in the metadata and there are NO places where this procedure
>and coloumns are mentioned...
>
>Gianni
>
>