see shalini its very simple. 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.

Answer

how to execute a procedure,once any database is restored on the database server?

Shalini Juneja

14y

2.2k

SQL QUESTION

Answers (1)

Next Recommended Forum

Fetching Records with Date Comparision

How do i grant a database role execute permission on a schema?

Forum Statistics

Please welcome our newest member Kyle Tamayo.
3,091,521 users have contributed to 147,405 threads and 483,601
In the past 24 hours, we have 2 new threads, 6 new posts, and 75 new users.
In last week, the most popular thread is 'Fail to pass OrderId to the receipt'.

Upcoming Events

View all

Streamlined Purchase Order Approval for Finance Teams: Automate Your Business Processes - Ep.7
Github Copilot Global Bootcamp - 2025
Vibe Coding Bootcamp