{"id":232,"date":"2019-04-03T15:55:36","date_gmt":"2019-04-03T15:55:36","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=232"},"modified":"2025-02-04T21:13:15","modified_gmt":"2025-02-04T21:13:15","slug":"sql-stone-edge-enterprise-procedures","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/","title":{"rendered":"SQL Stored Procedures for Stone Edge Enterprise Edition"},"content":{"rendered":"<h2>Overview<\/h2>\n<ul>\n<li>The\u00a0SEOM\u00a0Enterprise Edition uses several SQL scripts to obtain data for the purpose of auto-generating purchase orders sent to a supplier(s) to replenish a merchant\u2019s inventory<\/li>\n<li>The scripts are located in a folder named\u00a0SQL\u00a0in the program installation directory\n<ul>\n<li>Typically\u00a0c:\\StoneEdge<\/li>\n<\/ul>\n<\/li>\n<li>These scripts become stored procedures in\u00a0SEOM\u2018s SQL store data file as part of upgrading the application, or when converting an MS Access store file to an SQL database\n<ul>\n<li>If the scripts are not stored successfully -&gt; user will need to manually install the scripts as stored procedures.<\/li>\n<\/ul>\n<\/li>\n<li>The individual performing this operation should be assigned the db_owner role on the\u00a0SEOM\u00a0database\n<ul>\n<li>Database Owner is an SQL \u201csysadmin\u201d Logon ID, rather than a domain Login ID<\/li>\n<\/ul>\n<\/li>\n<li>NOTE: If performing an archive, delete the existing scripts before installing as they have been updated in more recent Stone Edge versions<\/li>\n<li>Archiving Orders scripts:\n<ul>\n<li>omsp_ArchiveCreateArchiveDB.sql<\/li>\n<li>omsp_ArchiveDeleteFromLive.sql<\/li>\n<li>omsp_ArchiveUpdateArchive.sql<\/li>\n<\/ul>\n<\/li>\n<li>Archiving POs scripts:\n<ul>\n<li>omsp_ArchiveCreateArchiveDB_PO.sql<\/li>\n<li>omsp_ArchiveDeleteFromLive_PO.sql<\/li>\n<li>omsp_ArchiveUpdateArchive_PO.sql<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>How to Manually Install the SQL Server Scripts as Stored Procedures<\/h2>\n<ol>\n<li>Open the SQL Server Management Studio (SSMS) software\n<ol type=\"a\">\n<li>Connect to Database Engine if not automatically connected<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>In Object Explorer\n<ol type=\"a\">\n<li>Click + next to \u201cDatabases\u201d<\/li>\n<li>Click database to select it (example in article will use DBTest)<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p class=\"Image\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3484 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer.png\" alt=\"\" width=\"252\" height=\"352\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer.png 252w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer-215x300.png 215w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer-36x50.png 36w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer-43x60.png 43w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer-72x100.png 72w\" sizes=\"(max-width: 252px) 100vw, 252px\" \/><\/p>\n<ol start=\"3\">\n<li>Click File -&gt; Open -&gt; File in top-left corner (or CTRL + O)<\/li>\n<\/ol>\n<p class=\"Image\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3485 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file.png\" alt=\"\" width=\"2153\" height=\"1227\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file.png 2153w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-300x171.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-1024x584.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-768x438.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-50x28.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-1536x875.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-2048x1167.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-60x34.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file-100x57.png 100w\" sizes=\"(max-width: 2153px) 100vw, 2153px\" \/><\/p>\n<ol start=\"4\">\n<li>Navigate to sql folder in Stone Edge directory (typically C:\\StoneEdge\\sql)<\/li>\n<\/ol>\n<p class=\"Image\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3486 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path.png\" alt=\"\" width=\"2152\" height=\"1218\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path.png 2152w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-300x170.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-1024x580.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-768x435.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-50x28.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-1536x869.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-2048x1159.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-60x34.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_file_path-100x57.png 100w\" sizes=\"(max-width: 2152px) 100vw, 2152px\" \/><\/p>\n<ol start=\"5\">\n<li>Click script to select and click \u201cOpen\u201d<\/li>\n<li>Script will open in SSMS<\/li>\n<li>Confirm correct database is selected in top ribbon\n<ol type=\"a\">\n<li>If wrong database is selected, use dropdown to change selection<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3492\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection.png\" alt=\"\" width=\"400\" height=\"209\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection.png 1386w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-300x156.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-1024x534.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-768x401.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-50x26.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-60x31.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_DB_selection-100x52.png 100w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/p>\n<ol start=\"8\">\n<li>Click\u00a0\u201cExecute\u201d to run script<\/li>\n<\/ol>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3487 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute.png\" alt=\"\" width=\"2153\" height=\"158\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute.png 2153w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-300x22.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-1024x75.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-768x56.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-50x4.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-1536x113.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-2048x150.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-60x4.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_execute-100x7.png 100w\" sizes=\"(max-width: 2153px) 100vw, 2153px\" \/><\/p>\n<ol start=\"9\">\n<li>Message at bottom will appear\n<ol type=\"a\">\n<li>If successful import, message will say:<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p class=\"Image\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3489 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success.png\" alt=\"\" width=\"319\" height=\"95\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success.png 319w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success-300x89.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success-50x15.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success-60x18.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_success-100x30.png 100w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol start=\"2\" type=\"a\">\n<li>If script already exists in Stone Edge, message will say:<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3490 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist.png\" alt=\"\" width=\"2131\" height=\"382\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist.png 2131w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-300x54.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-1024x184.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-768x138.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-50x9.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-1536x275.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-2048x367.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-60x11.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_already_exist-100x18.png 100w\" sizes=\"(max-width: 2131px) 100vw, 2131px\" \/><\/p>\n<ol start=\"10\">\n<li>Repeat steps 3-8 for all scripts in SQL folder<\/li>\n<li>Exit SSMS when done<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Overview The\u00a0SEOM\u00a0Enterprise Edition uses several SQL scripts to obtain data for the purpose of auto-generating purchase orders sent to a supplier(s) to replenish a merchant\u2019s inventory The scripts are located in a folder named\u00a0SQL\u00a0in the program installation directory Typically\u00a0c:\\StoneEdge These scripts become stored procedures in\u00a0SEOM\u2018s SQL store data file as&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[19],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Stored Procedures for Stone Edge Enterprise Edition<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Stored Procedures for Stone Edge Enterprise Edition\" \/>\n<meta property=\"og:description\" content=\"Overview The\u00a0SEOM\u00a0Enterprise Edition uses several SQL scripts to obtain data for the purpose of auto-generating purchase orders sent to a supplier(s) to replenish a merchant\u2019s inventory The scripts are located in a folder named\u00a0SQL\u00a0in the program installation directory Typically\u00a0c:StoneEdge These scripts become stored procedures in\u00a0SEOM\u2018s SQL store data file as...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-04T21:13:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/\",\"name\":\"SQL Stored Procedures for Stone Edge Enterprise Edition\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2019-04-03T15:55:36+00:00\",\"dateModified\":\"2025-02-04T21:13:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Stored Procedures for Stone Edge Enterprise Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Stored Procedures for Stone Edge Enterprise Edition","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:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/","og_locale":"en_US","og_type":"article","og_title":"SQL Stored Procedures for Stone Edge Enterprise Edition","og_description":"Overview The\u00a0SEOM\u00a0Enterprise Edition uses several SQL scripts to obtain data for the purpose of auto-generating purchase orders sent to a supplier(s) to replenish a merchant\u2019s inventory The scripts are located in a folder named\u00a0SQL\u00a0in the program installation directory Typically\u00a0c:StoneEdge These scripts become stored procedures in\u00a0SEOM\u2018s SQL store data file as...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2025-02-04T21:13:15+00:00","og_image":[{"url":"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/SQL_procedure_object_explorer.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/","url":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/","name":"SQL Stored Procedures for Stone Edge Enterprise Edition","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2019-04-03T15:55:36+00:00","dateModified":"2025-02-04T21:13:15+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/sql-stone-edge-enterprise-procedures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"SQL Stored Procedures for Stone Edge Enterprise Edition"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/232"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=232"}],"version-history":[{"count":5,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/232\/revisions"}],"predecessor-version":[{"id":3599,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/232\/revisions\/3599"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=232"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=232"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}