By Keith Chisarik - 1/23/2007
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?
|
By StrataFrame Team - 1/24/2007
When we create the package file, we generate that code... it should be removed when re-importing it back in. Thanks for the notice.
|
|