Comments
6 comments
-
Hi, thank you for your forum post.
From your post I can see that the default value is missing from the DDL.
I assume the database you are baselining includes the default values, can you please provide details of what the default values should be?
What edition and version number of SQL Change Automation are you using? For example SQL Change Automation Visual Studio extension release V3.3.19225.9927 or using the PowerShell module V3.3.19225.
Many Thanks
Eddie
-
SQL Change Automation -- 3.3.19197.9405
SQL Change Automation PowerShell -- 3.3.19197.9413Visual Studio 2017 SQL Change Automation Core Extension -- 3.3.19225.9927
Here are the default values
AUDIT_USER_ID = ('-1')
AUDIT_DATE = (getdate())
-
Any advice please?
-
Hi, thank you for your replies.
Using V3.3.19233.10102 of SCA VS (SQL Change Automation Visual Studio extension), I am unable to replicate the fault symptoms.
Would it be possible to obtain a copy of your Visual Studio Project to see if I can replicate the problem?
Many thanks
Eddie -
I can send you the project but you would need DB as well...if I am not wrong....I am afraid I cannot share the DB as it is classified as sensitive DB and cannot be shared.
-
Hi, thank you for your reply.
A support ticket has been created for you and I have replied to you via the support ticket with a further request.
Many Thanks
Eddie
Add comment
Please sign in to leave a comment.
CREATE TABLE [DCST].[XREF_REL_SETTLEMENT_COMPLAINT]
(
[SETTLEMENT_KEY] [int] NOT NULL,
[COMPLAINT_KEY] [int] NOT NULL,
[AUDIT_USER_ID] [varchar] (60) NOT NULL CONSTRAINT [DF__XREF_REL___AUDIT__4AF81212] DEFAULT -- No text is available,
[AUDIT_DATE] [datetime] NOT NULL CONSTRAINT [DF__XREF_REL___AUDIT__4BEC364B] DEFAULT -- No text is available
)
It is not able to generate the DEFAULT value, instead it geneated a text saying " No text is available"