1

Resolved

sp_StandardCDC_enable_table. Datatype varchar in scdc tables not created with max_length correctly

description

Whilst the specification of varchar(max) is handled OK in sp_StandardCDC_enable_table for the dynamic SQL to create the audit table, any numerical length is falling through the case statement.
I've inserted an additional case line which seems to work, as follows;
WHEN TQ.dataTypeName IN('nvarchar', 'varchar', 'varbinary') AND TQ.max_length >= 1 THEN TQ.dataTypeName + '(' + CONVERT(varchar(10), TQ.max_length) + ')'
 
(It really is quiet in here)
 
Regards
 
Derek

comments

wmweaver wrote Aug 24, 2011 at 2:57 PM

Corrected in new release, V1.4

wrote Aug 24, 2011 at 3:19 PM

wrote Aug 24, 2011 at 3:20 PM

wrote Feb 14, 2013 at 1:59 AM

wrote May 16, 2013 at 7:29 AM

wrote May 16, 2013 at 7:29 AM

wrote Jun 14, 2013 at 7:42 AM