Certain commands, when executed within a system proxy database, will be rejected with an error:
create procedure and drop procedure
create view and drop view
create trigger and drop trigger
create rule and drop rule
create default and drop default
The error generated in these cases is: Msg 12818, Severity 16: Cannot create an object of this type in system-created proxy database
