Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

print all store procedure syntax

Status
Not open for further replies.
adonet

adonet

MIS
May 4, 2004
312
US
Can someone show me how to print all store procedures' syntax in SQL server?
 
Sort by date Sort by votes
I think there are a couple of ways to accomplish... here's one...

select * from SysObjects where xtype='P'
 
Upvote 0 Downvote
This only list all SP name not syntax for each SP.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BunBo900
  • Locked
  • Question
Incorrect syntax on CType function
Replies
3
Views
280
jbenson001
jbenson001
dvannoy
  • Locked
  • Question
Print from asp.net
Replies
3
Views
182
jbenson001
jbenson001
primagic
  • Locked
  • Question
Binding a datalist with paging to Stored Procedure
Replies
3
Views
233
gk53
gk53
AndyInNC
  • Locked
  • Question
What is the syntax for ImageURL from another in-house server? 1
Replies
3
Views
218
jbenson001
jbenson001
shaunk
  • Locked
  • Question
LINQ - Selection Syntax issue
Replies
0
Views
149
shaunk
shaunk

Part and Inventory Search

Sponsor

Back
Top