Showing results for 
Search instead for 
Did you mean: 

Cisco Community Designated VIP Class of 2020

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.

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here