Example 1 Drops all resource limits for all users of the payroll application during the tu_wed_7_10 time range:
sp_drop_resource_limit NULL, payroll, tu_wed_7_10, elapsed_time
Example 2 Is similar to the preceding example, but drops only the resource limit that governs elapsed time for all users of the payroll application during the tu_wed_7_10 time range:
sp_drop_resource_limit NULL, payroll, tu_wed_7_10
Example 3 Drops all resource limits for “joe_user” from the payroll application:
sp_drop_resource_limit joe_user, payroll
