DataBase Project create Inline function before Table

DataBase Project create Inline function before Table by Vitaliy Voloshchuk

Closed

as Fixed

Type:	Bug
ID:	288678
Opened:	7/23/2007 8:19:08 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Our company have a large project. We used our own Database project for creating DB for our program. Now we want to use Team Edition for DB Proffesionals, but a problem is occured.
When there are two related inline functions in the project, they cannot be deployed.

Details (expand)

English

Visual Studio 2005 (All Products and Editions) Service Pack 1

Windows Server 2003

English

1. There are two related inline functions in the project
2. 2nd function depends on 1st function
3. 1st function selects from the table

Afer rebuild project, Visual Studio makes sql script.
This script has statements in the following order
1. create function
2. create table
so deploy failed

expected order is
1. create table
2. create function
deploy succedeed :)))

Posted by Vitaliy Voloshchuk on 8/17/2007 at 12:21 AM

Thanks, but we are interested in Visual Studio 2005. Will be there any SPs of HotFixes wich fix this bug?

Posted by Vitaliy Voloshchuk on 8/17/2007 at 12:19 AM

Thanks. Will be there some SP on the Visual Studio 2005, wich fixes this bug?

Posted by Microsoft on 8/15/2007 at 3:16 PM

We have found the problem and the fix will be included in Visual Studio 2008.

Team System Data Team

Posted by Microsoft on 7/24/2007 at 3:10 AM

Thanks for your feedback. We have reproduced this bug on Visual Studio 2005 SP1, and we are sending this bug to the appropriate group within the VisualStudio Product Team for triage and resolution.

Thank you,
Visual Studio Product Team.

Posted by Microsoft on 7/23/2007 at 5:29 PM

Thank you for your feedback. We are currently investigating. If this issue is urgent, please call support directly (see http://support.microsoft.com). Thank you, Visual Studio Product Team.