Preventing server changes
The company is also asking you to find a method to prevent databases from being mistakenly deleted by employees.
After a detailed analysis, you decide to use a trigger to fulfill the request.
The trigger will roll back any attempts to delete databases.
この演習はコースの一部です
Building and Optimizing Triggers in SQL Server
演習の手順
- Create a new trigger called
PreventDatabaseDelete. - Attach the trigger at the server level.
実践的なインタラクティブ演習
このサンプルコードを完成させて、この演習に挑戦してみましょう。
-- Create a trigger to prevent database deletion
CREATE TRIGGER ___
-- Attach the trigger at the server level
ON ___ ___
FOR DROP_DATABASE
AS
PRINT 'You are not allowed to remove existing databases.';
ROLLBACK;