Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when a Rollback statement is executed inside a trigger?
- 1 Answers
- 1971 Views
- Flextronics, Hexaware, I also Faced
- E-Mail Answers
Answer Posted / pramod singh
Adaptive Server aborts the currently executing command and halts execution of the rest of the trigger
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why I am getting this error when renaming a database in ms sql server?
how you can deploy an ssrs report?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Is truncate autocommit?
What is normalization? Explain different forms of normalization?
How to find related tables in sql server?
optimization techinques
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to find the second highest salary of an employee?
How to identify current user in ssrs report?
How can a user-defined datatype be created?
Does server sql treat char as a variable-length or fixed-length column?
How would you choose between a clustered and a non-clustered index?
What do you mean by a Composite primary key?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
