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

13y

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?

Leaderboard

View all

Rohit Gupta

Saravanan Ganesan

Raveena Attri

View all

Yesterday's leader

Rohit Gupta

Web3, Project Management, Software Architecture, Problem Solving

Ghaziabad (India)

3.1m

28.6k

100

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

188

287k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.8k

58k

Upcoming events

View all

Suggested for you

View all

Jay Krishna Reddy

Dijid Maddumakumara

Sarathlal Saseendran

Pushpendra Shukla

Bikesh Srivastava

Forum Statistics

Please welcome our newest member Tony Ruiz.
3,076,657 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 6 new threads, 22 new posts, and 215 new users.
In last week, the most popular thread is 'Delta lake vs Lakehouse in Fabric?'.