To protect integrity of database using Stored Procedures
Have you ever used a stored procedure to run few integrity checks or to protect such integrity on the database.
I always use the stored procedure as it will come handy when there is any such need, Erland Sommarskog has written great article on how Stored Procedures can be used to limit access to underlying database objects and help protect the integrity of the database. The article can be viewed from here.