Posts

Showing posts with the label trigger

Sol Trigger ENGLISH PATCH V1 ISO Free Download

Image
Sol Trigger ENGLISH PATCH V1 ISO Free Download Screen Shots File Name: Sol Trigger   Developer: Image Epoch Genre: RPG Image Format:  File Size: 1.4 GB You may click the link below to download your file Download Instruction: Click  Download Now  button  and the file is in another website  G o o g l e   Drive   Link. Just click the download and the file will be download.  Sometimes the file goes to  ADS  website to get the exact downloading file back to clicking on  Download Now  Button and again repeat the instruction. For more info click this link  How to download 1.4 GB Sol Trigger ISO Please report us if the download link are not working download file now

SQL Disable Or Enable a Trigger

SQL Disable Or Enable a Trigger Triggers are enabled by default when they are created. Disabling a trigger does not drop it. The trigger still exists as an object in the current database. However, the trigger does not fire when any Transact-SQL statements on which it was programmed are executed. Triggers can be re-enabled by using ENABLE TRIGGER. DML triggers defined on tables can be also be disabled or enabled by using ALTER TABLE. Purpose of the following Trigger --------------------------------- --AVOIDE TO DROP TABLES FROM DATABASE USE Test_Manoj Go CREATE TRIGGER TRG_DB_SAFTY ON DATABASE FOR DROP_TABLE AS RAISERROR(DROP CANNOT POSSIBLE,PLEASE CONTACT ADMIN..,16,1) ROLLBACK ; After creation of trigger any point of time a trigger can be disable or enable by the user.For Disable a trigger(de-activate) DISABLE keyword is used as follows:- --Disable Trigger on Database USE Test_Manoj Go disable TRIGGER TRG_DB_SAFTY on database For Enable a trigger on Database,any other object we need E...