After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback )
- 3 Answers
- 11642 Views
- CarrizalSoft Technologies, iGate, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
When we delete the records using triggers only the deleted
records will be stored in deleted table.
But if we do delete using begin transaction, the deleted
records will be stored in transaction log file. We cannot
see it visually.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a livelock?
What is difference between primary key and foreign key?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How many replicas are maintained for each sql azure db?
What is service broker? : sql server database administration
Can an automatic recovery be initiated by a user?
Explain external key management in sql server 2008
How to set database to be single_user in ms sql server?
What is difference between materialized view and view?
How do I open a .db file?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is Service Broker in sql server 2012?
Explain log shipping and mention its advantages.
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Which are the olap features?
