CodeEase.com

Simply writing stored procedures isn’t enough to adequately secure your application. You should also consider the following potential security holes.     *      Grant EXECUTE permissions on the stored procedures for database roles you want to be able to access the data.    *      Revoke or deny all permissions to the underlying tables for all roles and [Read More ...]

Maybe you got error when you try to update your database SQL Server such as add a Non-Nullable field. One possible reason is because the data table has already been inserted data. and you are trying to add a not nullable column to this table. so this is why you got the error.