A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace
When a column has a default value constraint that calls a scalar function that looks like this
the word default is stripped and yhis gets committed
System then shows the table as having changes that are not commited.
work around is to write the constraint as
Dennis E Evans
- Posts: 1
- Joined: Tue Nov 23, 2010 11:14 pm
Thanks for your post.
I've recreated this, and it seems that we're not expecting the DEFAULT keyword to be supplied as a parameter, and are ignoring it.
I have logged this as a bug with SQL Source Control (SOC-1873)
Thanks for taking the time to report this.
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Return to SQL Source Control 1
Who is online
Users browsing this forum: No registered users and 0 guests