USP_SMARTQUERYINSTANCE_DELETEIDSET

        create procedure dbo.USP_SMARTQUERYINSTANCE_DELETEIDSET
            @SMARTQUERYINSTANCEID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null
        with execute as owner
        as
        declare @FUNCTIONNAME as nvarchar(128)
        declare @OBJID as integer

        -- drop existing tv function
        set @FUNCTIONNAME = dbo.UFN_SMARTQUERYINSTANCE_MAKEIDSETFUNCTIONNAME(@SMARTQUERYINSTANCEID)

        select @OBJID = id from dbo.sysobjects where id = object_id(N'[dbo].[' + @FUNCTIONNAME + ' ]') and type in (N'FN', N'if', N'TF', N'FS', N'FT')
        if not @OBJID is null
            exec ('DROP FUNCTION [dbo].[' + @FUNCTIONNAME + ']')


        -- remove from ID Set register
        exec USP_IDSETREGISTER_DELETEFORSMARTQUERYINSTANCE @SMARTQUERYINSTANCEID, @CHANGEAGENTID

        return 0