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