Scripting out Stored Procs

[jshurst]

I would like to be able to script out all stored procs in a given database. Basically I want to do this for backup purposes. I just execute a script and it writes out all my SP's to a file on the server.

I don't want to use Mangement Studio I want it automated from a SQL script. And I don't really want an entire DB backup.

Can someone tell me how to do this?

Thanks in advance,

J

 

[simian336]

I recently tried something similar with views mine was more for documentation purposes.

http://tek-tips.com/viewthread.cfm?qid=1578937&page=1

You can play with

-- View a list of stored procedures
SELECT *
from sys.objects
where type='p'

-- view the sp definition
-- change object_id with the actual number
SELECT OBJECT_DEFINITION (object_id)

Simi

 

[markros]

Here is a blog post showing several different techniques:
How to script all SPs in the database

PluralSight Learning Library