588 results found

1. On shared mode, Source control sync delayed issue

   Shared mode is perfect for small team DEV environment, but status update delayed to sync is annoying....is there a way to config the sync frequency?

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Better Support for Shared Db Dev Model  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Why do you have to be in sysadmin-role to see who checked in changes?

   Ít would be nice, if you dont have to be in sysadmin-role to see wich user has made changes. thx.

   5 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  History/Log  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Accomodate for people with colour blindness

   One of my colleagues has colour blindness.

   The distinction between a non-reviewed database (the grey circle) and a database with outstanding changes (blue / white icon) is difficult to see because of the fact that the icons are so small (the less pixels to compare, the harder it is by all accounts) and often can be far away (i.e. if there are other non-source controlled database between them on the database tree in SSMS).

   It would be helpful to make a clear distinction between the icons - either make the grey icon a flat colour (i.e. remove the highlight within it) or to slightly change the shape of one the icons.

   One of my colleagues has colour blindness.

   The distinction between a non-reviewed database (the grey circle) and a database with outstanding changes (blue / white icon) is difficult to see because of the fact that the icons are so small (the less pixels to compare, the harder it is by all accounts) and often can be far away (i.e. if there are other non-source controlled database between them on the database tree in SSMS).

   It would be helpful to make a clear distinction between the icons - either make the grey icon a flat colour (i.e. remove the highlight within… more

   5 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Add button Stop/Start Checking for modifications

   Sometime I work with proxy of my customer and my DB, linked to source control, can't connect.
   Please, I need a Start-Stop button to stop the connection with the source control in this situation. Thank you.

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   5 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Add contained database support in SQL 2012

   Need to have better support for contained databases feature of SQL Server 2012. For example a new feature - user WITH PASSWORD is scripted as a user WITHOUT LOGIN.

   7 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. BUG(?): Rebuilding a table via migration script doesn't add the correct authorization commands

   When rebuilding a table via migration scripts, the ALTER AUTHORIZATION TO... commands are omitted on the replacement table when the migration script is created by SSC.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked

   BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. The toggle button functionality

   I have version 3.2.0.27. When you have conflicts, the toggle button at the top of commit and get latest won't uncheck items that SQL Source decides to check. I have to select all the items and then click a box to uncheck, then check the ones I want. If I don't want to resolve the conflict yet, it's not ideal.

   13 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Provide a way to post configurations that must be implemented as TO DO items

   I have a service broker application where some parts such as service routes etc must be defined per database configuration, thus certain components change per installation so it would be nice to tag such items as TO DO items, like wise once complete when comparing to latest or changes the item is not displayed as an object that has changed.

   Going further it might be nice to populate table data that also configures per installation as well

   perhaps use of extended properties, or a file present in source. I had taken the source code and placed a comment in it hoping it might at least show up during sql compare or getting latest code, didn't work on database level objects

   I have a service broker application where some parts such as service routes etc must be defined per database configuration, thus certain components change per installation so it would be nice to tag such items as TO DO items, like wise once complete when comparing to latest or changes the item is not displayed as an object that has changed.

   Going further it might be nice to populate table data that also configures per installation as well

   perhaps use of extended properties, or a file present in source. I had taken the source code and placed a comment in it… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Better Support for Shared Db Dev Model  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. SQL Source Control Configuring Data Compare Options

    Make it possible for us to configure how SQL Source Control does its data compare. There are some great settings that work within SQL Data Compare 10 that allow a user to configure how data in each table is compared between data sources. Currently the main feature I want is to allow the selection of table columns to actually compare (i.e. one column is an identity field which isn't always the same).

    34 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Static Data  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. object_schema_name

    Bug: the function objectschemaname is not recognized as a valid system function, and is wrapped in [] when committed to subversion backend. Scripts defining tables or stored procedures that use this function have to be edited to remove the [] before they can be successfully run. Please fix this, this is a function we put into almost every table as part of the default value in a "created by" field.

    17 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Use windows username instead of disaply name for linking to TFS 2012

    I am unable to link databases to TFS 2012 due to our parent company enforcing a Active Directory display name of "LastName, FirstName" which TFS claims is invalid due to the comma.

    It is a known issue with TFS (http://connect.microsoft.com/VisualStudio/feedback/details/768112/tfs-2012-build-failing-with-tf10158-user-name-contains-unsupported-characters)

    The workaround listed on Microsoft Connect is to use "domain\username" instead of display name when sending commands to TFS. Unfortunately, SQL Source Control doesn't expose a way to do this currently.

    8 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. This app to too chatty with the database! Turning polling off is not straightfoward to do like it should be and once you start Source Contro

    Turning off polling is not a straightforward task. And after I've used Source Control I have to exit SSMS and restart it in order to not have it generate a ridiculous about of traffic to my SQL Server 2012 SP1 instance. This has to be fixed or I'll find another tool.

    8 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. SQL Source Control 3.1.0.5208 Failed to commit changes

    System.IndexOutOfRangeException: UserName
    at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
    at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
    at System.Data.SqlClient.SqlDataReader.get_Item(String name)
    at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable1 , SqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection1 , SqlDateTime )
    at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#ny2b.#jiUc()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func1 func)
    at #GWeb.#WXM.#P6Uc(Func1 )
at #mlhb.#ny2b.#xFV()
at #mlhb.#ny2b.#aQU(ICollection1 #vfX, DatabaseObjectIdDictionary1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](Func2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
    at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
    at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
    at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
    at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation1.Invoke()
    at #eEc.#Qlg.Invoke()
    at #JLc.#PLc.#Jfb.#EJf()
    at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation1 , Object )

    System.IndexOutOfRangeException: UserName
    at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
    at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
    at System.Data.SqlClient.SqlDataReader.get_Item(String name)
    at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable1 , SqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection1 , SqlDateTime )
    at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#ny2b.#jiUc()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func1 func)
    at #GWeb.#WXM.#P6Uc(Func1 )
at #mlhb.#ny2b.#xFV()
at #mlhb.#ny2b.#aQU(ICollection1 #vfX, DatabaseObjectIdDictionary1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](Func2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
    at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
    at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
    at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
    at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation… more

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. SQL Source Control 3.1.0.5208 Failure to load Add-on to SQL Server 2008 R2

    This is actually a defect in the product. After upgrading to 3.1.0.5208 of the SQL Source Control, the Add-On for SQL Server 2008 R2 no longer loads. I had to revert to using 3.0.13.4214

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    11 comments  ·  Initial Setup  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. show migration scripts in the history window

    History window should indicate the fact that some of the changes are covered by the migration scripts and provide the ability to view these scripts

    10 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  History/Log  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    started  ·  AdminStephanie (Product Manager, Redgate) responded

    We have been working on v2 of Migrations, which stores migrations scripts in a table valued function within the database. This table valued function appears in the history. An Early Access Release of SQL Source Control is now available and can be downloaded from http://documentation.red-gate.com/display/MV2.

    NOTE: This is an Early Access Release and is not fully tested or functionally complete yet. It would be great if you could try it in a test environment and let us know about your experiences so we can fix any issues and try to make any updates you need before the full release.

    Thank you!
    Stephanie Herr :-)
    SQL Source Control Product Manager

17. Still having to manually apply indexes to tempdb to prevent timeouts

    I had to apply this index to tempdb (created by my missing index script).

    CREATE INDEX [missingindex2019RG_AllObjects] ON [tempdb].[dbo].[RG_AllObjects] ([Expired]) INCLUDE ([DatabaseID], [ObjectType], [ObjectID])

    This is a work-around until the DB service gets re-started and then I have to re-execute the statement because tempdb gets re-built.

    Also, there is no way that I know of to disable Sql Prompt which was blocking the create index statement. The only way I got the index applied was to hop to another computer without Sql Prompt.

    Index management in tempdb needs to be managed better.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Better Support for Shared Db Dev Model  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Very frequent disk activity

    When I have SSMS open with a DB linked to TFS I hear a burst of disk activity every 4 seconds. It's driving me to distraction. What can I do, other than unlike the DB whenever I'm not actually doing an update?

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. BUG in Commit Changes with a calculated xml column.

    When you have a table with a calculated xml column and you commit changes then the table stays changed as edit.
    example
    CREATE TABLE [dbo].[UtblLoonmotorMotorRechtzettingenHistoriekRechtzettingOverschrijvingen]
    (
    [BetalingsOpdrachtGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DFUtblLoonmotorMotorRechtzettingenHistoriekOverschrijvingenBetalingsOpdrachtGuid] DEFAULT (newid()),
    [RechtzettingsGuid] [uniqueidentifier] NOT NULL,
    [BetalingsopdrachtenbestandGuid] [uniqueidentifier] NULL,
    [FinancieleRekeningGuid] [uniqueidentifier] NULL,
    [Bedrag] [numeric] (10, 2) NOT NULL,
    [Mededeling] [varchar] (100) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL,
    [StandaardBankrekeningnummer] [varchar] (14) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [StandaardPostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardLokaliteit] [varchar] (36) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardCountryCode] [char] (2) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAddressLine1StraatNummer] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAddressLine2PostNummerStad] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeBegunstigdeInformatie] [varchar] (1) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL,
    [AfwijkendeBankrekeningnummer] [varchar] (14) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [AfwijkendePostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeLokaliteit] [varchar] (36) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeCountryCode] [char] (2) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAddressLine1StraatNummer] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAddressLine2PostNummerStad] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [Bankrekeningnummer] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardBankrekeningnummer] else [AfwijkendeBankrekeningnummer] end),
    [Titularis] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardTitularis] else [AfwijkendeTitularis] end),
    [Account] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAccount] else [AfwijkendeAccount] end),
    [Postkode] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardPostkode] else [AfwijkendePostkode] end),
    [Lokaliteit] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardLokaliteit] else [AfwijkendeLokaliteit] end),
    [CountryCode] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardCountryCode] else [AfwijkendeCountryCode] end),
    [AddressLine1StraatNummer] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAddressLine1StraatNummer] else [AfwijkendeAddressLine1StraatNummer] end),
    [AddressLine2PostNummerStad] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAddressLine2PostNummerStad] else [AfwijkendeAddressLine2PostNummerStad] end),
    [AccountType] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [dbo].[UFXMLBepaalAccount]([StandaardAccount]) else [dbo].[UFXMLBepaalAccount]([AfwijkendeAccount]) end)
    ) ON [PRIMARY] TEXTIMAGEON [PRIMARY]

    When you have a table with a calculated xml column and you commit changes then the table stays changed as edit.
    example
    CREATE TABLE [dbo].[UtblLoonmotorMotorRechtzettingenHistoriekRechtzettingOverschrijvingen]
    (
    [BetalingsOpdrachtGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DFUtblLoonmotorMotorRechtzettingenHistoriekOverschrijvingenBetalingsOpdrachtGuid] DEFAULT (newid()),
    [RechtzettingsGuid] [uniqueidentifier] NOT NULL,
    [BetalingsopdrachtenbestandGuid] [uniqueidentifier] NULL,
    [FinancieleRekeningGuid] [uniqueidentifier] NULL,
    [Bedrag] [numeric] (10, 2) NOT NULL,
    [Mededeling] [varchar] (100) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL,
    [StandaardBankrekeningnummer] [varchar] (14) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [StandaardPostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CI… more

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. BUG: User Defined Table Types with Defaults show as different when they are not.

    All of our User Defined Table Types with declared Defaults show up as different and needing to be committed when there are no differences. Then during the commit process it shows an error saying "Nothing to commit"

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close