sql - Is there any way to recover a stored procedure overwritten with an ALTER statement? -

sql - Is there any way to recover a stored procedure overwritten with an ALTER statement? -

i have altered stored procedure error , have no backup of database. there way of recovering work ?

try running this. gets list of queries in plan cache, may buried in there.

select execquery.last_execution_time [date time], execsql.text [script] sys.dm_exec_query_stats execquery cross apply sys.dm_exec_sql_text(execquery.sql_handle) execsql order execquery.last_execution_time desc

sql sql-server database sql-server-2008