Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure Context

Status
Not open for further replies.
dcf1023

dcf1023

Programmer
Jun 5, 2003
5
US
I'm having trouble getting a command to run in a stored procedure to bring some databases online that had previously been restored with no recovery. In the stored procedure the code is:

CREATE Procedure sp_RecoverAllDatabases
BEGIN...

RESTORE DATABASE productinfo WITH RECOVERY
...

I get an error the following error:
Server: Msg 927, Level 14, State 2, Procedure sp_RecoverAllDatabases, Line 15
Database 'productinfo' cannot be opened. It is in the middle of a restore.

However, if I run the line "RESTORE DATABASE productinfo WITH RECOVERY" in query analyzer, it restores the database and brings it back on line. Any idea what the core issue is here?

Thanks in advance for any help.
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
192
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
86
Auguy
Auguy
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
83
fredericofonseca
fredericofonseca
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
96
pjw001
pjw001
AlphaMann
  • Locked
  • Question
Stored Procedure
Replies
1
Views
62
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top