SQLServerCentral / Discuss Content Posted by Raj Vasant / Article Discussions / Article Discussions by Author / how to customize SMO script for ALTER or CREATE stored procedure / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:37:03 GMT20how to customize SMO script for ALTER or CREATE stored procedurehttp://www.sqlservercentral.com/Forums/Topic891156-227-1.aspxWhen I use SQL Server Management Studio I can define a script for creating a stored procedureEx:USE [RM_BILLING]GO/****** Object: StoredProcedure [dbo].[Insert_Affiliate_Info] Script Date: 03/26/2010 18:03:31 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===============================================-- !!! Auto-Generated - Do Not Modify Directly !!!-- Created date...: 2010-03-25 @ 10.20.35-- Description....: Insert Affiliate_Info record-- !!! !!! Use tool to regenerate !!! !!!-- ===============================================ALTER PROCEDURE [dbo].[Insert_Affiliate_Info]( @affID Int, @affName VarChar(100))ASBEGIN INSERT INTO Affiliate_Info ( Aff_ID, Aff_Name ) VALUES ( @affID, @affName )ENDFri, 26 Mar 2010 16:04:45 GMTdjmarcus