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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_MSforeach_storedprocedure? 1

Status
Not open for further replies.
redlam

redlam

MIS
Jun 28, 2000
218
US
I know there is a system stored procedure sp_MSforeachtable but is there one for stored procedures?
 
Sort by date Sort by votes
Feeling adventurous?
Why not write your own? X-)

sp_MSForEachTable opens a cursor with info from sysobjects so if you change that you might be able to create your own

GOOD LUCK!!
 
Upvote 0 Downvote
Ya know what ColinM? That's actually a really good idea. Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top