{"id":1016,"date":"2011-09-28T21:08:15","date_gmt":"2011-09-29T04:08:15","guid":{"rendered":"http:\/\/truelogic.org\/wordpress\/?p=1016"},"modified":"2011-09-28T21:08:15","modified_gmt":"2011-09-29T04:08:15","slug":"get-list-of-last-changed-stored-procs-in-sql-server","status":"publish","type":"post","link":"https:\/\/truelogic.org\/wordpress\/2011\/09\/28\/get-list-of-last-changed-stored-procs-in-sql-server\/","title":{"rendered":"Get List of Last Changed Stored Procs in SQL Server"},"content":{"rendered":"<p>Sometimes when you have created\/updated several stored procs in your database in SQL Server and you only need to transfer the changed ones to another copy of the database, then the best way is to get a listing of the stored procs by date.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>select name, modify_date from sys.procedures order by modify_date desc<\/strong><\/h3>\n<p>This saves you the whole trouble of remembering which stored procs were added or updated of late.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Sometimes when you have created\/updated several stored procs in your database in SQL Server and you only need to transfer the changed ones to another <a class=\"mh-excerpt-more\" href=\"https:\/\/truelogic.org\/wordpress\/2011\/09\/28\/get-list-of-last-changed-stored-procs-in-sql-server\/\" title=\"Get List of Last Changed Stored Procs in SQL Server\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[36,61,165,186,212,233,242,243],"class_list":["post-1016","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-amit","tag-change","tag-last","tag-mysql","tag-procs","tag-server","tag-sql","tag-storeed"],"_links":{"self":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/1016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/comments?post=1016"}],"version-history":[{"count":0,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/1016\/revisions"}],"wp:attachment":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/media?parent=1016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/categories?post=1016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/tags?post=1016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}