Skip to main content

Posts

Showing posts from December, 2011

How to get all Store Procedure name through SQL or How to get all sp names through sql

Dear All here is a solution if you need to know overall sql procedure using under one database select ROUTINE_NAME from DatabaseName.information_schema.routines where routine_type = 'PROCEDURE' please change the "DatabaseName" with your database in the top line Regards Rashid Imran Bilgrami http://www.bestvisualization.com