| | | 
Advanced StrataFrame User
       
Group: StrataFrame Users Last Login: Today @ 7:49:39 AM Posts: 658, Visits: 27,038 |
| 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?
|
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: Yesterday @ 1:09:23 PM Posts: 2,686, Visits: 1,888 |
| When we create the package file, we generate that code... it should be removed when re-importing it back in. Thanks for the notice.
www.bungie.net |
| |
|
|