Member Avatar for Eyo

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

  • 2 Contributors
  • 2 Replies
  • 77 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Eyo
Member Avatar for Teme64

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

Member Avatar for Eyo

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.