USP_SCHEMA_DB_SETDBREVKEY

create procedure dbo.USP_SCHEMA_DB_SETDBREVKEY

@DBREVKEY nvarchar(500)

as

    declare @value sql_variant;

    if @DBREVKEY is null
        begin
        RAISERROR('USP_SCHEMA_DB_SETDBREVKEY cannot be called when the @DBREVKEY is null',16,10); 
        return 5;
        end

    select @value = value from sys.fn_listextendedproperty(N'DBREVKEY', default,default, default, default, default, default);

    if @value is null
        -- property doesn't exist, so add it
        exec sys.sp_addextendedproperty @name=N'DBREVKEY', @value=@DBREVKEY;
    else
        -- property already exists, so update it
        exec sys.sp_updateextendedproperty @name=N'DBREVKEY', @value=@DBREVKEY;