{"id":1249,"date":"2009-12-14T15:51:09","date_gmt":"2009-12-14T21:51:09","guid":{"rendered":"http:\/\/gregsowell.com\/?p=1249"},"modified":"2009-12-14T15:51:09","modified_gmt":"2009-12-14T21:51:09","slug":"list-stored-procedures-from-query-analyzer-in-sql-2000","status":"publish","type":"post","link":"https:\/\/gregsowell.com\/?p=1249","title":{"rendered":"List Stored Procedures From Query Analyzer in SQL 2000"},"content":{"rendered":"<p>I know not too many of you will need this, but I&#8217;ll have to look this back up at some point \ud83d\ude09<\/p>\n<pre class=\"gs-code\"><code class=\"language-plaintext\">    USE databasename\r\n\r\n    SET NOCOUNT ON \r\n    SELECT \r\n        ROUTINE_NAME \r\n    FROM \r\n        INFORMATION_SCHEMA.ROUTINES \r\n    WHERE \r\n        ROUTINE_TYPE = &#039;PROCEDURE&#039; \r\n        AND OBJECTPROPERTY \r\n        ( \r\n            OBJECT_ID(ROUTINE_NAME), \r\n            &#039;IsMsShipped&#039; \r\n        ) = 0 \r\n    ORDER BY \r\n        ROUTINE_NAME<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>I know not too many of you will need this, but I&#8217;ll have to look this back up at some point \ud83d\ude09 USE databasename\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,13,15],"tags":[],"class_list":["post-1249","post","type-post","status-publish","format-standard","hentry","category-callmanager","category-server","category-windows"],"_links":{"self":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/1249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1249"}],"version-history":[{"count":1,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/1249\/revisions"}],"predecessor-version":[{"id":1250,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/1249\/revisions\/1250"}],"wp:attachment":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}