Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this guide explains how to take full advantage of stored procedures: operations that are stored with the database server, allowing access to all clients.The book covers the design of stored procedures in both T-SQL and CLR languages such as C# and Visual Basic .NET and readers will learn to develop programmable database objects and scalable Web-based applications.