Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Careless delete all SP
Message
From
02/05/2005 06:58:08
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Careless delete all SP
Miscellaneous
Thread ID:
01010096
Message ID:
01010096
Views:
86
I really want to cry and don't know how to do now.
Origianll, I choose all SP and generate a SQL script , I copy the script
into SQL Analzyer , and run it
I press 'stop' carelessly, then I found all the SP are dropped already.

Then I am so stupid that close the SQL analzyer, and reopen it.
NOW, I LOST everything, I check that there is a log in
G:\Program Files\Microsoft SQL Server\MSSQL\Data\myDataBase_Log

is That I can use it recover it ????????
Please help ~~~~
Next
Reply
Map
View

Click here to load this message in the networking platform