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 derfloh 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
Joined
May 4, 2004
Messages
312
Location
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 Question
Incorrect syntax on CType function
Replies
3
Views
398
jbenson001
jbenson001
dvannoy
  • Locked
  • Question Question
Print from asp.net
Replies
3
Views
264
jbenson001
jbenson001
primagic
  • Locked
  • Question Question
Binding a datalist with paging to Stored Procedure
Replies
3
Views
288
gk53
gk53
AndyInNC
  • Locked
  • Question Question
What is the syntax for ImageURL from another in-house server?
Replies
3
Views
309
jbenson001
jbenson001
shaunk
  • Locked
  • Question Question
LINQ - Selection Syntax issue
Replies
0
Views
197
shaunk
shaunk

Part and Inventory Search

Sponsor

Back
Top