This is a good illustration of why you should never edit stored procedures in Enterprise Manager. Always do stored procedure work from a script in Query Analyzer.
If you don’t have the script used to create the procedure, you can recover the old version by restoring your most recent database backup to a new database, scripting out the procedure, and applying that script to your current database.
Strored procedure contents deleted
Posted - 07/11/2007 : 11:01:03
