<div>
When I am trying to open a table I am getting this message: <br />
<br />
Data base is in transition .<br />
<br />
Does that help?
</div>


When I am trying to open a table I am getting this message:

Data base is in transition .

Does that help?

<div>
Sorry, forgot to tell you that after I stoped the deleted script, I tried to take the database offilne, but I canceled it also.
</div>


Sorry, forgot to tell you that after I stoped the deleted script, I tried to take the database offilne, but I canceled it also.

<div>
Thank you,<br />
<br />
I have deatached the DB files and attached them again, and found that now single row was deleted !
</div>


Thank you,

I have deatached the DB files and attached them again, and found that now single row was deleted !

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
In a SQL 2005 database, I have run this script by mistake:<br />
<br />
Delete from table1<br />
Delete from table2<br />
Delete from table3<br />
<br />
And after 4 seconds, and while script was still running, I clicked the red sqaure (Stop).<br />
<br />
Now the database is inaccessible, I will not make any other action untill I will receive your comment.<br />
<br />
Is it possible to recover the deleted rows? Can I make Rollback as in Oracle?<br />
<br />
My database is working in the Simple recovery mode.
</div>
</div>


Hello experts,

In a SQL 2005 database, I have run this script by mistake:

Delete from table1
Delete from table2
Delete from table3

And after 4 seconds, and while script was still running, I clicked the red sqaure (Stop).

Now the database is inaccessible, I will not make any other action untill I will receive your comment.

Is it possible to recover the deleted rows? Can I make Rollback as in Oracle?

My database is working in the Simple recovery mode.

Urgent: deleted rows recovery

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.