denydatawriter does not work in SQL Server I have a couple of admin roles in a SQL Server 2012. 



To prevent myself from changing data in one database, I added my login as a member of denydatawriter role to that database. 

It seems does not work, still able to insert



Did I miss anything?
Because you're also a member of sysadmin, all security checks are skipped.