create procedure sys.sp_MScdccheck_ddladmin
as
begin
-- Do the sysadmin check first as it is 4 times more efficient
-- than is_member call and reduces performance overhead in case
-- the user has sysadmin privileges
if is_srvrolemember('sysadmin') = 1 or
is_member ('db_owner') = 1 or
is_member ('db_ddladmin') = 1
begin
return (0)
end
else
begin
raiserror(22914, 16, -1)
return (1)
end
end