| Name the table and query and store procedure which is used to hold the stored procedure scripts?
TableName is Sys.SQL_Modules which is used to store the script of store procedure. And name of the store procedure which is saved in the table is called Sys.Procedures. And below is the query to get all store procedure script:-
| | |