1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Building and Optimizing Triggers in SQL Server
Connected

अभ्यास

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.

निर्देश

100 XP
  • Create a new trigger called PreventDatabaseDelete.
  • Attach the trigger at the server level.