how to customize SMO script for ALTER or CREATE stored procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Raj Vasant » how to customize SMO script for ALTER or...

how to customize SMO script for ALTER or CREATE stored procedure

Rate Topic

Display Mode

Topic Options

Author

Message

djmarcus

Posted Friday, March 26, 2010 4:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 26, 2010 7:43 PM
Points: 2, Visits: 2

When I use SQL Server Management Studio I can define a script for creating a stored procedure
Ex:

USE [RM_BILLING]
GO
/****** Object: StoredProcedure [dbo].[Insert_Affiliate_Info] Script Date: 03/26/2010 18:03:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ===============================================
-- !!! 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)
)
AS
BEGIN
INSERT INTO Affiliate_Info
(
Aff_ID,
Aff_Name
)
VALUES
(
@affID,
@affName
)
END

Post #891156

« Prev Topic | Next Topic »

Permissions