SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 418 Page Views: 

The table was deleted. Now is there any way to get it back?



Posted By: Avi Date: 1 October 2010 12:02:08 PM
 Answer:

Yes, the logs can be used to fetch the deleted table.For this one has to use some some external tools.


Posted By: avibtech


Date: 1 October 2010 12:02:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image FbuKx8
Related Questions
SQL Server : What  is SQL Job and what are its uses?

What is SQL Job and what are its uses?

SQL Job is set of specified operations set on server to be performed sequentially and automatically.....
Category: SQL Server Date: 10/1/2010 11:45:07 AM
SQL Server : Is it possible to create a Primary Key and Unique Key on Computed columns?

Is it possible to create a Primary Key and Unique Key on Computed columns?

Yes, it is possible to create a Primary ke and unique key on computed columns. In case of Unique key....
Category: SQL Server Date: 10/1/2010 11:44:07 AM
SQL Server : What is the basic concept of Serialization?

What is the basic concept of Serialization?

Serialization is the highest level of isolation. When Serialization is implemented then there will b....
Category: SQL Server Date: 10/1/2010 11:43:07 AM
SQL Server : Write the query to Select the name of the product whose total sales is 20 form the following table named sales:-
PID    Pname      Sale
1        Soap         5
2        Brush       10
3        Tea          8
1        Soap        12
2        Brush       5

Write the query to Select the name of the product whose total sales is 20 form the following table n....

select Pname from sales group by PID having sum(sale)=130
Category: SQL Server Date: 10/1/2010 11:42:07 AM
SQL Server : What will be returned with @@identity T-Sql?

What will be returned with @@identity T-Sql?

It will return the last inserted identity value. It will return a numeric value. So whenever a row ....
Category: SQL Server Date: 10/1/2010 11:41:07 AM