Copying Stored Procedures from one Server to Another

• Vasant Raj

  SSCommitted

  Points: 1835

  More actions

  May 22, 2005 at 11:31 pm

  #164409

  I have about 15-16 to stored procedures. I need to copy all of them to another server (to different database).

  I can do that by passing the whole procedure as commandstring.

  But it is not a proper way.

  Any suggestions???

   

• ajay_k73

  SSC Veteran

  Points: 217

  More actions

  May 22, 2005 at 11:59 pm

  #560429

  You generate the script of Stored procedure. and execute this script using Query analyser on New Server. I think this is the best option.