BizTalk Server General - SQL Adapter and Delete Stored Procedure

Author

SQL Adapter and Delete Stored Procedure

Bryan Freeman

2004-07-30, 5:49 pm

I would like to use the following stored procedure with the SQL Adapter. I don't want to use an updategram for deletes. How do I need to modify it to get the adapter to generate my schema?

CREATE PROCEDURE [dbo].[EPGReports_Delete_ByDataSourceID]
@EPGDataSourceID int
AS
SET NOCOUNT ON

DELETE FROM
[EPGReports]
WHERE
EPGDataSourceID = @EPGDataSourceID
GO

--
Bryan Freeman
Consultant
Ascentium Corp.