Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to view sp script?

Author  Topic 

shaik.zakeer
Posting Yak Master

117 Posts

Posted - 2008-09-04 : 01:20:34
Hello friends

I have created 50 stored procedures in a database.

I want to view all the stored procedure's script at one time without view the each and every sp script.

can i able to view all sp's script at one time?

Thanks in advance





Thanks

Zakeer Sk

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-04 : 01:32:36
you have look into syscomments system table.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-04 : 02:55:38
Make use of Generate SQL Script option from Management Studio

or script out to text file and see
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/13/script-out-procedures-and-functions-part-2.aspx


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -