Hello ,
I have a database SQL server 2008 database.
What are the SQL queries that I could use in the SQL server management studio to retrieve the following information:
1. all stored procedures.
2. all functions.
Thank u
Eyo
0
Newbie Poster
Recommended Answers
Jump to PostIn the VB.NET code I would still stick in SQLDMO to fetch any information.
All 2 Replies
Teme64
215
Veteran Poster
In the VB.NET code I would still stick in SQLDMO to fetch any information.
Eyo
0
Newbie Poster
I found the solution
The solution is by creating queries that reads directly from SYS tables in sql server
and it works ; i got the information i need
Thank u
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.