UFN_SMARTQUERY_AVAILABLE

            create function dbo.UFN_SMARTQUERY_AVAILABLE(

            )
            returns bit
            with execute as caller
            as begin

        declare @retval bit = 0;

        if exists(select top 1 ID from dbo.SMARTQUERYCATALOG
                        where dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
                                    (
                                        SMARTQUERYCATALOG.[SMARTQUERYSPEC].query
                                            (
                                                'declare namespace common="bb_appfx_commontypes";
                                                /*/common:InstalledProductList'
                                            )
                                    ) = 1
        )
          set @retval = 1;

        return @retval;

            end