how to execute a procedure,once any database is restored on the database server?
SQL QUESTION
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Dinkar ChavhanPosted Apr 22, 2011, 7:56 AM
first tell me what u want to do with Stored procedure after excuting?.
1)first restored database in u r sqlserver alongwith stored procedure.ok
now go stored procedure------select particular stored procedure which you want-----right click----select ExcuteStoredprocedure.
if this is not run then used this one
2)go to modify and select from alter to last one and excute.
if it is also not run used this one.
3)right click----scriptstoredprocedureas----create to or alter to and select from alter to last one and excute.