{"id":1885,"date":"2014-04-23T07:28:43","date_gmt":"2014-04-23T07:28:43","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=1885"},"modified":"2014-04-23T14:51:00","modified_gmt":"2014-04-23T14:51:00","slug":"could-not-find-stored-procedure-usp_getdatabaseid","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/could-not-find-stored-procedure-usp_getdatabaseid\/","title":{"rendered":"Could not find stored procedure &#8216;USP_GetDataBaseID&#8217;."},"content":{"rendered":"<p><strong>Error:<\/strong><\/p>\n<p>Could not find stored procedure &#8216;USP_GetDataBaseID&#8217;.<\/p>\n<p><strong>Snapshot:<\/strong><\/p>\n<p><strong>\u00a0<\/strong> <a href=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2014\/04\/could-not-find-stored-procedure1.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1886\" title=\"could not find stored procedure\" src=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2014\/04\/could-not-find-stored-procedure1.jpg\" alt=\"\" width=\"283\" height=\"129\" \/><\/a><\/p>\n<p><strong>Workaround 1:<\/strong><\/p>\n<p><strong>Note: <\/strong>Close Saral Accounts\\Billing\\Professional application, before executing the below steps.<\/p>\n<p>1. Open Query Express.<\/p>\n<p>2. Execute the below query.<\/p>\n<h4>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Use master .<\/h4>\n<h4>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Drop Database RelProduct.<\/h4>\n<p>3. Navigate to application path find RelProduct.sql, select open with notepad and copy the complete query and paste the same to Query Express editor, and execute.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: Could not find stored procedure &#8216;USP_GetDataBaseID&#8217;. Snapshot: \u00a0 Workaround 1: Note: Close Saral Accounts\\Billing\\Professional application, before executing the below steps. 1. Open Query Express. 2. Execute the below query. \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Use master . \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Drop Database [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1885"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=1885"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1885\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=1885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=1885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=1885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}