Monthly Archives: January 2012

The INSERT permission was denied on the object ‘X’, database ‘Y’, schema ‘Y’.

Can be caused by overzealous addition of permissions. Make sure the Role Members ‘db_denydatawriter’ and ‘deny_datareader’ are unchecked.

Posted in Programming | Tagged | 2 Comments