How to take backup of Stored Procedures in SAP HANA and how to alter Stored Procedures in sap HANA
---------------------------This KB article is for only internal team use only..............................
Kindly follow the below steps--
1. Open SAP HANA -- > Select the Stored Procedures -- > Right Click -- > Click on open Definition
2. Click on Create Statement and copy the Stored Procedures.
3.Select the database and Click on Open sql console for selected system.
4.Paste the Stored Procedures which we copied
5.Change the Stored Procedures Name before taking backup and click on execute.
6. To alter the Stored Procedures kindly use ALTER instead of create in Stored Procedures and click on execute.
Related Articles
SAP Business One - iVend Retail Integration Points
Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...Unable to take Store DB Backup from Enterprise Management Console.
Product version: iVend 6.6 Patch 8346 Problem statement: When trying to take a backup of store DB from Enterprise Management Console. Below Error is is showing. "Method not found : Microsoft.sqlserver.management.common.serverconnection ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Consolidating Stock Take Counts
Consolidating Stock Take Counts (Done by multiple users happening at different Locations) iVend 6.5 introduced a new feature where the stock take count can be done with multiple users for the same or different locations at a time and thereafter all ...