I have a SQL Server 2008 stored procedure that works fine, it uses
Change Data Tracking to find some inserted rows and does stuff.

I used a Visual Studio 2008 Schema Compare operation to populate my
Database Project with the databse configuration. The schema compare
successfully writes to the project.

The project does not build with these kinds of errors:

Error 2 TSD03006: Column: [xxx].[xxxID] has an unresolved
reference to object [Cdc].[Fn_Cdc_Get_All_Changes_dbo_xxx].[xxxID].
C:\src\test\solutn\dev\Data\PpcCap\Schema
Objects\Schemas\dbo\Programmability\Stored
Procedures\cdcupdate.proc.sql

It looks like the sproc is failing the build because the CDC objects
are not in the database project.

I would like to let the project just ignore TSD03006 errors, or
convert them to warnings so my build can proceed. In the project
properties I updated the Properties\Database.sqldeployment, I checked
"TreatVerificationErrorsAsWarnings" and unchecked "VerifyDeployment"
but it still blows up.

How can I get this to work?

Thanks.

SnapDive (SnapDive (AT) community (DOT) nospam) writes:
No idea, but I would suggest that it may be better to try this in forum
devoted to Visual Studio, preferrably one that is specialised in
DataDude.

Keep in mind, though, that VS2008 shipped before SQL 2008, so it may
simply be the case that it is not able to handle CDC. I believe VS2010
is out; it may do it better.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx