cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1794
Views
0
Helpful
0
Comments
Jeson Chelleth
Beginner
Beginner

This was used for an issue with the eGain product. But I suppose it can be used for other applications that use SQL.

* As a best practice, you can stop Cisco Service first, wait for all the java/javaw processes to stop, then proceed as below.

1. Open SQL Management Studio
2. Go to the existing Stored Procedure (SP), find the exact one, and then right-click and select Modify (That will open a new query)
3. Rename the present SP. Example xxx_xx.OLD
4. Copy paste the contains of the SP obtained from dev team (eGain in this case) into the query window
5. Select All, and hit execute (now refresh the view and you should have the new SP created with name 'xxx_xx')
6. Start Cisco Service, and do the testing for the issue
7. If all ok, you can delete the OLD SP

Note: TAC does not do scripting.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers
Quick Links