Post reply

Copy Stored Procs

  • November 15, 2002 at 8:57 am

    #159197

    In our enviroment I write the stored proc's on the server and the developer have a copy of the database on their machines usually a lap top. Some of the stored procs I'm writing now call other stored procs, whats the best way to generate a script of the main

    stored procedure and its dependent stored procedure?

    cheers

    Randy

  • November 15, 2002 at 9:11 am

    #441494

    try sp_depends 'CallingProcedure'.

    It should give all the called procedure names.Once you get these names I think you can generate a script for all the stored procedurs which are called.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply