UFN_EMAILALERTSETTINGS_ISHOSTED

Determines if the system is in a hosted environment.

Return

Return Type
bit

Definition

Copy



CREATE function dbo.UFN_EMAILALERTSETTINGS_ISHOSTED()
returns bit
with execute as owner
as
begin
    declare @HOSTING_ID nvarchar(36);
    select @HOSTING_ID = cast(value as nvarchar(36)) from sys.fn_listextendedproperty(N'Hosting_DatabaseID', default, default, default, default, default, default);

    if @HOSTING_ID is null
        return 0;

    return 1;
end