{"id":27891,"date":"2023-08-28T05:14:00","date_gmt":"2023-08-28T03:14:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27891"},"modified":"2023-11-01T17:27:26","modified_gmt":"2023-11-01T16:27:26","slug":"list-all-sql-server-stored-procedures","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/","title":{"rendered":"How to list all SQL Server Stored Procedures?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introduction-to-sql-server-s-stored-procedures-listing-using-the-system-catalogs-and-views\"><em>Introduction to SQL Server&#8217;s Stored Procedures listing using the system catalogs and views.<\/em><\/h4>\n\n\n\n<p>This comprehensive tutorial will guide through the process of how to <strong>list all stored procedures in SQL server<\/strong> with increasing complexity as you read on. Stored procedures are paramount in SQL server as they help us execute a sequence of Transact-SQL statements in a single command. As a Microsoft database expert, learning and understanding how to <strong>view all SQL server procedures<\/strong> is extremely beneficial. <\/p>\n\n\n\n<p><strong><em>Get Started by Accessing SQL Server databases.<\/em><\/strong><\/p>\n\n\n\n<p>To start, remember a SQL Server Stored Procedure is a <a href=\"https:\/\/www.vocabulary.com\/dictionary\/procedure\" target=\"_blank\" rel=\"noreferrer noopener\">predefined sequence<\/a> of SQL statements stored on a database server, which can be invoked and executed as a single unit to perform a specific task.<\/p>\n\n\n\n<p>this tutorial, let&#8217;s begin with the simplest method of getting all stored procedures in a SQL server database. To connect to the SQL Server instance using <a href=\"https:\/\/expert-only.com\/en\/ssms\/download-ssms-18\/\"><strong>SQL Server Management S<\/strong><\/a><a href=\"https:\/\/expert-only.com\/en\/ssms\/\"><strong>tudio (SSMS)<\/strong><\/a>, follow these steps: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><em>Connect to the instance<\/em><\/strong><\/li>\n\n\n\n<li><strong><em>Expand the database<\/em><\/strong><\/li>\n\n\n\n<li>Then expand the <strong><em>Programmability<\/em><\/strong> folder<\/li>\n\n\n\n<li>Finally, expand the <strong><em>Stored Procedures <\/em><\/strong>folder to view all stored procedures.<\/li>\n<\/ol>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#1-understanding-sql-server-system-tables\" >1. Understanding SQL Server system tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#2-view-all-sql-server-procedures-using-information-schema\" >2. View All SQL Server Procedures Using Information Schema<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#3-explore-t-sql-procedures-with-object-definitions\" >3. Explore T-SQL Procedures with Object Definitions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#4-leverage-dynamic-sql-to-get-all-sql-procedures-names\" >4. Leverage Dynamic SQL to get all SQL Procedures names<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-understanding-sql-server-system-tables\"><span class=\"ez-toc-section\" id=\"1-understanding-sql-server-system-tables\"><\/span>1. Understanding SQL Server system tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we&#8217;ve got the basics, let&#8217;s dive deeper. By using the sys.procedures catalog view, we can retrieve more detailed information about the stored procedures in our database. Below, an example of how to use the sys.procedures catalog view.  It will return all the properties of each stored procedure in the database. It retrieves information such as: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>name<\/li>\n\n\n\n<li>object_id<\/li>\n\n\n\n<li>schema_id<\/li>\n\n\n\n<li>type<\/li>\n\n\n\n<li>type_desc<\/li>\n\n\n\n<li>create_date<\/li>\n\n\n\n<li>modify_date<\/li>\n\n\n\n<li>and many others.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM sys.procedures;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-view-all-sql-server-procedures-using-information-schema\"><span class=\"ez-toc-section\" id=\"2-view-all-sql-server-procedures-using-information-schema\"><\/span>2. View All SQL Server Procedures Using Information Schema<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For a more user-friendly approach to display the name of the SQL server procedures, we can utilize the INFORMATION_SCHEMA.ROUTINES view. This time, the query returns the name of each stored procedure (ROUTINE_NAME) and the SQL statement that defines the stored procedure (ROUTINE_DEFINITION). <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT    ROUTINE_NAME, ROUTINE_DEFINITION\n   FROM   INFORMATION_SCHEMA.ROUTINES\n   WHERE  ROUTINE_TYPE='PROCEDURE';\n<\/pre>\n\n\n\n<p>In SQL Server Management Studio, it gives a list of the names and their definition. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/08\/sql-server-list-all-stored-procedure.jpg\" alt=\"T-SQL query to list all the SQL Server Stored Procedures in a database\" class=\"wp-image-27899\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/08\/sql-server-list-all-stored-procedure.jpg 800w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/08\/sql-server-list-all-stored-procedure-300x218.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/08\/sql-server-list-all-stored-procedure-768x557.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><em>T-SQL query to list all the SQL Server Stored Procedures in a database<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-explore-t-sql-procedures-with-object-definitions\"><span class=\"ez-toc-section\" id=\"3-explore-t-sql-procedures-with-object-definitions\"><\/span>3. Explore T-SQL Procedures with Object Definitions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Another way to list all stored procedures in SQL server is by <strong>using the OBJECT_DEFINITION function<\/strong> along with the sys.procedures view. This function is helpful as it allows us to see the text of the SQL Server stored procedures. Here&#8217;s how to do it:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT pr.name, OBJECT_DEFINITION(pr.object_id)\nFROM sys.procedures pr;\n\n<\/pre>\n\n\n\n<p>The <a href=\"https:\/\/expert-only.com\/en\/sql-server-online-course\/\"><strong>T-SQL<\/strong><\/a> query provided above query will return the name of the stored procedure and its definition.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-leverage-dynamic-sql-to-get-all-sql-procedures-names\"><span class=\"ez-toc-section\" id=\"4-leverage-dynamic-sql-to-get-all-sql-procedures-names\"><\/span>4. Leverage Dynamic SQL to get all SQL Procedures names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dynamic SQL is a powerful feature in MS SQL databases that allows us to construct SQL statements dynamically at runtime. We can <strong>use dynamic T-SQL to create a stored procedure that will list all stored procedures<\/strong> in a SQL server database. Check out the following example:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE PROCEDURE ListAllStoredProcedures\nAS\nBEGIN\n\n   DECLARE @SQL NVARCHAR(MAX)\n   SET @SQL = N'SELECT name FROM sys.procedures'\n   EXEC sp_executeSQL @SQL\n\nEND;\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion-about-sql-server-stored-procedures-listing\">Conclusion about SQL Server Stored Procedures listing<\/h3>\n\n\n\n<p>In conclusion, the ability to <strong>view all SQL server procedures<\/strong> is a fundamental concept in SQL database management which significantly improves efficiency. The methods provided in this tutorial range from simple to complex to cater to both beginners and advanced SQL users.<\/p>\n\n\n\n<p>Whether you choose to use Management Studio, catalog views, INFORMATION_SCHEMA, OBJECT_DEFINITION, or dynamic SQL, you can effectively list all stored procedures in SQL server. <\/p>\n\n\n\n<p>For further learning, you can check out the official Microsoft documentation on <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/stored-procedures\/view-the-definition-of-a-stored-procedure?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Viewing a Stored Procedure<\/a> and <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-stored-procedures\/sql-server-system-stored-procedures\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SQL Server System Stored Procedures<\/a>.<\/p>\n\n\n\n<p><strong><em>You can also check of course our other tutorials on SQL Server procedures<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-stored-procedures-examples\/\">SQL Server Stored Procedure Examples<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/t-sql\/insert-data-from-a-sql-server-procedure\/\">Insert data using a SQL Server stored procedure<\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/en\/t-sql\/execute-sql-procedures-with-parameters\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Introduction to SQL Server&#8217;s Stored Procedures listing using the system catalogs and views. This comprehensive tutorial will guide through the process of how to list all stored procedures in SQL server with increasing complexity as you read on. Stored <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\" title=\"How to list all SQL Server Stored Procedures?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-27891","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to list all SQL Server Stored Procedures? T-SQL<\/title>\n<meta name=\"description\" content=\"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to list all SQL Server Stored Procedures?\" \/>\n<meta property=\"og:description\" content=\"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-28T03:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-01T16:27:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to list all SQL Server Stored Procedures?\",\"datePublished\":\"2023-08-28T03:14:00+00:00\",\"dateModified\":\"2023-11-01T16:27:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\"},\"wordCount\":604,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\",\"name\":\"How to list all SQL Server Stored Procedures? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"datePublished\":\"2023-08-28T03:14:00+00:00\",\"dateModified\":\"2023-11-01T16:27:26+00:00\",\"description\":\"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to list all SQL Server Stored Procedures?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to list all SQL Server Stored Procedures? T-SQL","description":"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/","og_locale":"en_US","og_type":"article","og_title":"How to list all SQL Server Stored Procedures?","og_description":"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-28T03:14:00+00:00","article_modified_time":"2023-11-01T16:27:26+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to list all SQL Server Stored Procedures?","datePublished":"2023-08-28T03:14:00+00:00","dateModified":"2023-11-01T16:27:26+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/"},"wordCount":604,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/","url":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/","name":"How to list all SQL Server Stored Procedures? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","datePublished":"2023-08-28T03:14:00+00:00","dateModified":"2023-11-01T16:27:26+00:00","description":"Multiple T-SQL queries and options to list all SQL Server Stored Procedures in a database, using system views and catalogs, and dynamic SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/list-all-sql-server-stored-procedures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to list all SQL Server Stored Procedures?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=27891"}],"version-history":[{"count":8,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27891\/revisions"}],"predecessor-version":[{"id":27904,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/27891\/revisions\/27904"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10874"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=27891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=27891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=27891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}