sp_scriptpublicationcustomprocs truncation of scripts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Doyle - 29 Aug 2006 12:46 GMT

Is there any way of preventing this stored procedure from truncating the
final scripts it produces (for sp_MSins_*, sp_MSUpd_* and sp_MSDel_*) if a
large number of columns are used in the replication model?

Thanks

Signature

Peter Doyle

Reply to this Message

Paul Ibison - 29 Aug 2006 13:13 GMT

Peter - are you sure this isn't a facet of your Query Analyser? In Tools,
Options, Results you can increase the max characters per column and see if
this is large enough.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message

Peter Doyle - 29 Aug 2006 13:34 GMT

Paul

You are absolutely right. Thanks

Peter

Signature

Peter Doyle

> Peter - are you sure this isn't a facet of your Query Analyser? In Tools,
> Options, Results you can increase the max characters per column and see if
> this is large enough.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message