Importing from a package file

Keith Chisarik — Wed, 24 Jan 2007 09:45:58 GMT

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
[b]set ANSI_NULLS ON[/b]
[b]set QUOTED_IDENTIFIER ON[/b]
[b]GO[/b] -----> already added in the 'Pre-Create/Environment Code area

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

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

RE: Importing from a package file

StrataFrame Team — Wed, 24 Jan 2007 09:45:58 GMT

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

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Importing from a package file

Importing from a package file

RE: Importing from a package file