• Jennifer Noelle Dunklin (9/22/2007)


    I figured it out. The column was too narrow to capture the complete script that was generated by the store procedure sp_scriptpublicationcustomprocs. I went into Tools, Options, Results in enterprise manger and increase the column width from 256 to 5000. The excuted the script again. The resulting scripts worked perfectly. Thanks

    I'm having the same issue in 2014.

    I followed the steps that you took but I did not find a results option?:unsure:

    Could not delete Publication. Could not find stored procedure Error: 2812

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/