UFN_SCHEMA_DB_GETDBREVKEY

CREATE function dbo.UFN_SCHEMA_DB_GETDBREVKEY() returns nvarchar(500)

with execute as owner
--need to execute as owner for web service to get a value.
as

begin

    declare @value nvarchar(500);

    select @value = COALESCE( cast(value as nvarchar(500)),'') from sys.extended_properties as p where p.class=0 and p.name=N'DBREVKEY';

    if @value is null set @value='';

    return @value;

end