Post reply

When replicating, the table length exceeds 128 max when sp_MSins is added to the table name

  • April 16, 2012 at 4:33 am

    #272601

    Hi,

    I have searched the forums looking for this scenario and cannot find anything.

    This is a push subscription, and after the snapshot is taken and the reader agent begins to process the snapshot on the subscriber an error occurs and the snapshot creation stops.

    The identifier that starts with 'sp_MSins_dboT_DATABASEASSOCIATION_INTERBRANCHSTOCKTRANSFERDELIVERYWORKFLOWSTATUS_INTERBRANCHSTOCKTRANSFERDELIVERYWORKFLOWSTATUS_' is too long. Maximum length is 128. (Source: MSSQLServer, Error number: 103)

    While the Table name is well below the Max of 128 - the 'sp_MSins_dbo' part is pushing it over the 128.

    There are only about 5 tables in the DB that are of similar length, but changing the names of them would be a huge task.

    Ay ideas would be much appreciated.

    Thanks in Advance

    JL

  • April 23, 2012 at 1:48 pm

    #1477787

    You can change the name of the stored procedure in the properties for the publication. Once you have the properties of the publication open select that article and change the name of the stored procedure. You can also modify the name by scripting the publication.

  • April 25, 2012 at 3:50 am

    #1478813

    Thank you for your reply, however, when I go to view the stored procedures on the publictaion, they do not represent the ones that are causing the errors:

    'sp_MSins_dboT_DATABASEASSOCIATION_INTERBRANCHSTOCKTRANSFERDELIVERYWORKFLOWSTATUS_INTERBRANCHSTOCKTRANSFERDELIVERYWORKFLOWSTATUS_' is too long. Maximum length is 128

    These are the SPs in the articles are only 2 in number

    iqfn_incrementsequencenumber

    &

    usp_AsyncSeq

    It appears that sp_MSins_ are the ones generated by the replication?

    Thanks for your help

    J

  • April 25, 2012 at 5:37 am

    #1478874

    Not the stored procedures for the publication but the stored procedures that are being used for the table inserts. Highlight the article in the articles window of the publication properties and choose article properties for the highlighted table article. If you scroll down to Statement Delivery section there you will see the INSERT stored procedure name and update stored procedure name.

  • May 2, 2012 at 2:32 am

    #1482230

    Sherwin, apologies for my tardiness in responding but thank you, the mdofication to the naming used by the SPs worked.

    Thanks again

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply