Sunday, 8 July 2018

SQL Server : To List all Store Procedures in all Databases

Hello Everyone, In this blog, I am telling you to List all Stored Procedures in all Databases (including master, msdb). There may be a situation arise when you are new to some project and there are multiple databases and you have to find a single store procedure. There are many ways but I feel this one is Optimum.

Here is the Script:


Happy Coding !!!

No comments:

Post a Comment

SQL Audits

1. sys.server_audits What it is: Lists all server-level audit objects . An audit is the top-level object that defines: Where to wri...