• for an instance you can do it other alternet way too use L:

    sp_helptext 'yrspname'  it will display the text / code of yr sp copy / save it to .txt file .

    HTH

    Regards.

     

    Hemantgiri S. Goswami | SQL Server Specialist & Consultant
    SQL Server Citation[/url] | Follow me on Twitter