StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Importing from a package fileExpand / Collapse
Author
Message
Posted 01/23/2007 9:39:03 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 7:48:41 AM
Posts: 658, Visits: 26,206
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?

Post #6135
Posted 01/24/2007 9:45:58 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 10/21/2008 9:20:58 AM
Posts: 2,685, Visits: 1,887
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
Post #6149
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:10am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.