Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / November 2008

Tip: Looking for answers? Try searching our database.

Errors using DEFAULT constraints

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 21 Nov 2008 17:04 GMT
We have an application (Desktop) that has been using SSCE for quite some
time (Since version 2.1, but we upgraded to 3.5/SP1). Up until yeserday,
I had never encountered this particular problem. I have to say I'm
completely baffled by what this error tells me. I have specified a
constraint name for the default, but it appears it is attempting to
generate a new one and use that instead, except that the name it is
generating is apparently already in use.
Here is the error:
Error executing SQL: alter table ReserveTrades add column
ManuallyCreated bit not null constraint DF_ReserveTrades_ManuallyCreated
 default 1 ---> Constraint already exists. [
DF__ReserveTrades__000000000000099C ]

I would provide the stack trace, but it does not provide any insight.
Has anyone encountered this type of error before? Is it a known bug? Any
info at all would be helpful. Thank you.

Chris
ErikEJ - 23 Nov 2008 18:53 GMT
Could this be related:
http://blogs.msdn.com/sqlservercompact/archive/2008/04/03/dropping-defaults.aspx

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> We have an application (Desktop) that has been using SSCE for quite some
> time (Since version 2.1, but we upgraded to 3.5/SP1). Up until yeserday, I
[quoted text clipped - 13 lines]
>
> Chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.