How-to create SQL-script?

Question

I use MSSQL Management Studio 2005 Express Edition, and I have more than 100 stored procedures. How create sql-script which contain only stored procedures? Thanks.

right click on your database name and then select task -> Generate Script -> and check stored procedures in it and the finish i hope this will do the work for you. — Karan Shah
– Karan Shah, Commented Sep 26, 2011 at 12:24

CharithJ · Accepted Answer · 2011-09-26 12:22:10Z

5

Right click on the database -> Tasks -> Generate Scripts -> Go through the steps -> There are check boxes to select Tables, SPs, UDFs and Users. Select only SPs and create the script.

Here is the starting point.

enter image description here

answered Sep 26, 2011 at 12:22

CharithJ

47.8k20 gold badges126 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jags Over a year ago

just a minor correction: Right click on the database -> Tasks -> Generate Scripts -> ...

Raj More · Accepted Answer · 2011-09-26 12:27:50Z

2

If you do exec SP_HelpText StoredProcedureNameGoesHere, you will get the full script of that procedure.

Do this to get 5 procedures (you get the picture)

exec SP_HelpText StoredProcedure01
exec SP_HelpText StoredProcedure02
exec SP_HelpText StoredProcedure03
exec SP_HelpText StoredProcedure04
exec SP_HelpText StoredProcedure05

Here's a script to generate the script for all procedures in your db.

SELECT 'Exec sp_Helptext ' + SPECIFIC_NAME
FROM INFORMATION_SCHEMA.Routines

edited Sep 26, 2011 at 12:27

answered Sep 26, 2011 at 12:22

Raj More

48.2k34 gold badges139 silver badges199 bronze badges

Comments

Karan Shah · Accepted Answer · 2011-09-26 12:29:53Z

1

Right click on ur database name -> Select Task -> Generate Script -> Next -> Next -> Select things to be scripted ->next - > Select All -> Finish

i have posted an image for help.

Generating script from existing stored procedures

answered Sep 26, 2011 at 12:29

Karan Shah

7525 silver badges15 bronze badges

Comments

Upendra Chaudhari · Accepted Answer · 2011-09-26 12:58:41Z

1

Open Databases >> DBName >> Programability >> Stored Procedures in Object Explorer Details and then select all procedures except "System Stored Procedures" folder and right click on it and select "Script Stored Procedures as >> Create To >>" option.

enter image description here

edited Sep 26, 2011 at 12:58

answered Sep 26, 2011 at 12:21

Upendra Chaudhari

6,5515 gold badges28 silver badges44 bronze badges

9 Comments

tom redfern Over a year ago

The OP did not ask how to script out a stored procedure. But how to script only the stored procedures in his database.

Upendra Chaudhari Over a year ago

@hughjadick : jadick This will shows only SPs, not another tables or functions.

tom redfern Over a year ago

If you read the original question the author is asking for ALL stored procedures. Not ONE stored procedure.

Upendra Chaudhari Over a year ago

@hughjadick : If you check my answer I written to select all stored procedures and then right click. In screenshot I have one SP so.

tom redfern Over a year ago

it is impossible to select more than one stored procedures in SQL Server Management Studio.

|

Collectives™ on Stack Overflow

How-to create SQL-script?

4 Answers 4

1 Comment

Comments

Comments

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related