Generator for sp_StandardCDC_enable_table

As it gets a bit tedious to manually write all sp_StandardCDC_enable_table invocations, I wrote some sql to autogenerate this. This generates input for all columns for all regular tables in the cur...

Id #13420 | Release: None | Updated: Sep 23, 2015 at 8:35 PM by _stianb_ | Created: Sep 23, 2015 at 8:33 PM by _stianb_

Issue - Handle Table Names with Spaces

Hi, In order to handle tables with spaces in their names, a few changes are required. ( I dont have rights to change the database naming convention as its a 3rd party DB.) In a few places we ne...

Id #13137 | Release: None | Updated: Jan 27, 2014 at 12:36 PM by Styvie | Created: Jan 27, 2014 at 12:36 PM by Styvie

sp_standardCDC_enable_table Error when table has more than one indexes

Error on line 1: Column names in each table must be unique.When the table that the sp_standardCDC_enable_table is running for, has more than one indexes (including pk's clustered index), it multipl...

Id #12636 | Release: None | Updated: Sep 23, 2015 at 8:38 PM by _stianb_ | Created: Dec 6, 2012 at 3:55 PM by pantelis_ch

Error with CaptureUser option of sp_StandardCDC_enable_table

If passing @CaptureUser = 1 to sp_StandardCDC_enable_table, it fails with an error of invalid column name.   The part of the procedure that creates the tracking table creates a column called AuditU...

Id #12451 | Release: None | Updated: Feb 14, 2013 at 1:59 AM by Sequin | Created: Aug 22, 2012 at 2:06 PM by Sequin

Error with FK & database trigger

I was inserting a column via table design in SSMS and upon tryign to save I got "Unable to create relationship <fk name>. Target string size is too small to represent the XML instance" where <fk_n...

Id #11233 | Release: None | Updated: Feb 14, 2013 at 1:59 AM by Robinson_Derek | Created: Aug 26, 2011 at 2:13 PM by Robinson_Derek

Enable/Disable all/one scdc trigger(s)

I felt the need to be able to turn on/off the standardCDC triggers either singularly or en mass and the need to share it. In order to loop through the tables with CDC triggers applied without using...

Id #11230 | Release: None | Updated: Feb 14, 2013 at 1:59 AM by Robinson_Derek | Created: Aug 25, 2011 at 1:20 PM by Robinson_Derek

Error detection in sp_StandardCDC_enable_table

It would be useful for first time users & evaluators if sp_StandardCDC_enable_table reported that a primary key had not been specified in the @CapturedColumnList parameter and that this was a requi...

Id #11220 | Release: StandardCDC V1.4 | Updated: Jun 14, 2013 at 7:42 AM by Robinson_Derek | Created: Aug 23, 2011 at 12:01 PM by Robinson_Derek

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

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...

Id #11219 | Release: StandardCDC V1.4 | Updated: Jun 14, 2013 at 7:42 AM by wmweaver | Created: Aug 23, 2011 at 11:56 AM by Robinson_Derek

  • 1-8 of 8 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • All
    • Work Items