Creating, Altering, and Removing Stored Procedures

In SQL Server Management Objects (SMO), stored procedures are represented by the StoredProcedure object.

Creating a StoredProcedure object in SMO requires setting the TextBody property to the Transact-SQL script that defines the stored procedure. Parameters require the @ prefix and must be created individually by using StoredProcedureParameter objects and adding to the StoredProcedureParameter collection of the StoredProcedure object.

See Also

Tasks

How to: Create, Alter, and Remove a Stored Procedure in Visual Basic .NET

Reference

StoredProcedure

Other Resources

Stored Procedure Basics

Help and Information

Getting SQL Server 2005 Assistance