USP_SCHEMA_DB_SETDBREVKEY_FOR_SCHEMA

            create procedure dbo.USP_SCHEMA_DB_SETDBREVKEY_FOR_SCHEMA

            @SCHEMANAME AS NVARCHAR(128),
            @DBREVKEY nvarchar(500)


            as

            declare @value sql_variant;

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

            if @SCHEMANAME is null
            begin
            RAISERROR('dbo.USP_SCHEMA_DB_SETDBREVKEY_FOR_SCHEMA cannot be called when the @SCHEMANAME is null',16,10);
            return 6;
            end

            declare @propname nvarchar(150);
            set @propname=N'DBREVKEY_' + @SCHEMANAME;

            select @value = value from sys.fn_listextendedproperty(@propname , default,default, default, default, default, default);

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