When we create the package file, we generate that code... it should be removed when re-importing it back in.  Thanks for the notice.

When importing a DDT project from a package file it seems that unwanted syntax is added to the CREATE PROCEDURE area.



It adds the following which I have had to delete from 50+ stored procs......am I missing something?



IF EXISTS(SELECT [name] FROM [sysobjects] WHERE [name] = 'aspnet_CheckSchemaVersion')

DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion]

GO

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO -----> already added in the 'Pre-Create/Environment Code area



CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion] ----> Added via the tool



It also throws up on the "IF EXISTS...." line, is this misplaced as well?




Keith Chisarik