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.
