copying stored procedures

Hi All,
I have a small problem...
I need to replace stored procedures in an SQL database with ones from
another database without touching any of the tables or data is there a way I
can do this?
Any help would be great
Thanks
GavYou can generate an SQL script of the "new" storred procedures, then drop
the old ones (if your script does not contain the drop statement, or if you
changed the stored procedure names), and run your script from query
analyzer.
Francesco Anti
"Gav" <spam@.spam.com> wrote in message
news:%238WdCQFPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I have a small problem...
> I need to replace stored procedures in an SQL database with ones from
> another database without touching any of the tables or data is there a way
> I can do this?
> Any help would be great
> Thanks
> Gav
>|||Use QA (in case you have both dbs in the same server.), edit the sp, change
the database in the comobobox and execute the alter statement in the second
db. If the db are in diff servers, generate the script, go to the second db,
drop the sp and execute the create procedure script.
AMB
"Gav" wrote:

> Hi All,
> I have a small problem...
> I need to replace stored procedures in an SQL database with ones from
> another database without touching any of the tables or data is there a way
I
> can do this?
> Any help would be great
> Thanks
> Gav
>
>