CODEWITHSUNDEEP
stored-proceduressql-server-2000
Buggieboy
Buggieboy

Reputation: 4696

Script to write out stored procedures

I am looking for a script that will write out all the sprocs in a SQL Server 2000 database to a textfile, preferably as a series of "CREATE PROCEDURE" statements.

Upvotes: 0

Views: 274

Answers (1)

3Dave
3Dave

Reputation: 29041

Enterprise manager provides the ability to script any and all objects in the database. I'm using Sql 05, but I seem to remember the method being:

  1. In the details/summary view, select all of the procedures that you want to script.
  2. Right-click.
  3. Select tasks-script... or whatever is similar.

Unfortunately I don't have SQL 2000 Enterprise Manager available in front of me, but there is an option in the context menu to script any objects you desire.

Upvotes: 1

Related Questions