Get the creation code of procedures

Question

0.00/5 (No votes)

See more:

Hello people....!!!

So, I´d like to know if there is some way to create a procedure and it get the creation code of all procedures at my base....

example: I´ve the procedures x,y,z, already created at my base......so, there is some way to get the creation code of them x,y,z....

that´s the code what I want ----> (create procedure x(@param)....)

There´s some way to do that ????

So, I only got the procedure names through sys.procedures....

Sorry if this question already exists here.....however I did search and didn´t found anything like.....

Since then, thank you.....and sorry about my english.....

[]´s

Posted 17-Sep-11 8:19am

gollum85

Add a Solution

Comments

Herman<T>.Instance 17-Sep-11 14:20pm

well....what is your exact problem?
Do you use Sql Server management studio?

gollum85 20-Sep-11 10:19am

so man, I know that it can be easy through the Sql Server management studio
but I need to do it through the application understand ???
anyway thanks

3 solutions

Solution 3

Check this if it works for you.

SQL

select ROUTINE_NAME , ROUTINE_TYPE, ROUTINE_DEFINITION  from INFORMATION_SCHEMA.ROUTINES

Posted 18-Sep-11 19:01pm

sachin10d

Comments

gollum85 20-Sep-11 10:26am

so, I don´t understand how to use it.....but thanks man

Solution 1

If you use SQL Server Management studio, it's pretty easy:
1) Right click the database you are interested in.
2) Select "Tasks...Generate Scripts" from the context menu.
3) In the resulting dialog, press "Next" until you get to the "Choose Objects" screen.
4) Click the "Select Specific database objects" Radio button.
5) Put a tick in the "Stored Procedures" check box.
6) Press "Next" and set your destination.
7) Press "Next" twice, and the file will be created.
8) Press "Finish" to close.

Posted 17-Sep-11 21:24pm

OriginalGriff

Comments

gollum85 18-Sep-11 11:03am

thank you for try to help me OriginalGriff, so I have already know, but it does not work for me, because I have to do that through the application.....anyway thanks....!!!

Agecanonix 18-Sep-11 12:23pm

@gollum85: Then have a look at SQL Server Management Objects (SMO): http://msdn.microsoft.com/en-us/library/ms162169.aspx There are several ways to script database objects. See this for instance: http://msdn.microsoft.com/en-us/library/ms211012.aspx

gollum85 20-Sep-11 10:20am

so man, i looked there but got nothing.....anyway thanks

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MaulikDusara · Accepted Answer · 2011-09-18T19:30:00

Solution 4

Hi,

http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated[^]

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.script.aspx[^]

http://www.sqlservercentral.com/articles/SMO/scriptdatabaseobjectswithsmo/2342/[^]

Posted 18-Sep-11 19:30pm

MaulikDusara

Comments

gollum85 20-Sep-11 10:29am

so man, thank u, in one of this link that u gave me, I found something that worked for me....
and if interests to somebody, so I used the follow expression

EXEC sp_helptext ‘objectName’....

thank u man....!!

[no name] 20-Sep-11 11:24am

welcome