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

In the VB.NET code I would still stick in SQLDMO to fetch any information.

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.