December 10, 2010 at 2:01 pm
We are using Visual Studio database project for database development. We recently enabled CDC on couple of tables in our database, and now we can't deploy any changes to those tables from Visual Studio, following error is thrown at the time of deploy from Visual Studio.
"{Database Namespace}.dbschema(0,0): Error TSD00565: [dbo].[TableOne] is under change data capture control and cannot be modified"
I can make any schema changes from SSMS, and they will execute with no problems. Any recommendations/suggestions as to why this is happeneing?
Thanks,
Randy
December 10, 2010 at 2:15 pm
Are you using a GUI table designer in VS?
If so, the way most of those work is by creating a temp table, loading all the data from the table into it, then dropping the table, creating a new table with the changes made to it, and then reloading the data back into it from the temp table.
If you issue an "alter table" command, it won't do that.
The error is probably because of the drop-recreate, and the lack of error in the other is probably from a simple alter table.
I've seen this before with tables marked for replication. It's probably the same issue.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply