Hello,

Is there an easy way of copying all Stored Procedures from one database to another?

I have tried doing this through DTS by selecting only stored procedures and omitting all tables & data, but I find that all tables in the destination database are all blank after DTS has completed (thank God I backed it up!).

Can anyone help?