create TRIGGER [dbo].[TR_ADHOCQUERY_DELETE_IDSET] on dbo.ADHOCQUERY with execute as owner AFTER DELETE as
set nocount on
declare @AdHocQueryID uniqueidentifier
declare @Format smallint
-- declare a cursor that returns all of the deleted queries
declare deleted_query_cursor cursor local FAST_FORWARD for
select ID from deleted
OPEN deleted_query_cursor
FETCH NEXT from deleted_query_cursor
into @AdHocQueryID
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
begin
-- delete related table-value function
exec USP_ADHOCQUERY_DELETEIDSET @AdHocQueryID
-- for static queries, delete the related static table
exec USP_ADHOCQUERY_DELETESTATICTABLE @AdHocQueryID
FETCH NEXT from deleted_query_cursor into @AdHocQueryID
end
CLOSE deleted_query_cursor
DEALLOCATE deleted_query_cursor
|
Trigger Definition
