When we keep all
our stored procedures creation script in a file and want to run that whole script.
It always complains about already existing stored procedure having same name.
It is better
before running your Stored Proc creation script, your creation script should be
smart enough that always checks the presence of same name stored procedure before.
Following piece
of SQL Script checks the stored procedure presence. If it finds, it delets the
old one and create a new one having same name (of course most of the time, the
new one would be modified)
When we keep all
our stored procedures creation script in a file and want to run that whole script.
It always complains about already existing stored procedure having same name.
It is better
before running your Stored Proc creation script, your creation script should be
smart enough that always checks the presence of same name stored procedure before.
Following piece
of SQL Script checks the stored procedure presence. If it finds, it delets the
old one and create a new one having same name (of course most of the time, the
new one would be modified)