Stored procedures are one of the most powerful tools that SQL Server provides you. Understanding them well and using them wisely will result in robust, secure, and well-performing databases. Stored procedures give you a security layer, encapsulation, reduction in network traffic, reuse of execution plans, and much more. SQL Server 2005 introduces the ability to develop CLR routines, eliminating the need to develop extended stored procedures and enhancing the functionality of your database.