Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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