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!

List SP's in a DB from VB

Status
Not open for further replies.
pokermat

pokermat

Programmer
Jan 17, 2002
44
GB
Hi all

I need to display a list of stored procedures in a sql server db.

I am using Data Environment and when you insert an SP you get a list of all SPs for that connection - that is the list I am after in code.

Any ideas? Thanks.

VB6 - XP Pro.
 
Sort by date Sort by votes


An xtype of "P" returns stored procedures, "V" returns views...

select name from sysobjects where xtype = 'P'

Mark
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
309
strongm
strongm
Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
264
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
get value from html page 1
Replies
7
Views
408
strongm
strongm
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
227
sal21
sal21
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
488
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top