What will happen when a Rollback statement is executed inside a trigger?

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


Please Help Members By Posting Answers For Below Questions

What it means to be triggered?

496


What is system stored procedures?

579


what protocol both networks use? : Sql server database administration

534


What is the difference between writing data to mirrored drives versus raid5 drives

505


How to search for a string in all stored procedure in sql server?

530






How to disable triggers using "disable trigger"?

553


How do database indexes work?

542


As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

615


ow to bring suspect mode datbase online from scratch

1397


Do you know what is bit data type and whats the information that can be stored inside a bit column?

546


Differentiate between mongodb vs. Sql server?

572


What is report snapshot in ssrs?

161


What is ems sql management studio? : sql server management studio

583


What is filestream?

554


What is data compression? : sql server database administration

543