Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

Replacing a stored procedure in SQL

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.

Version history
Revision #:
1 of 1
Last update:
‎11-23-2010 06:25 AM
Updated by:
 
Labels (1)
Everyone's tags (4)