"Cerora" <Cerora@discussions.microsoft.com> wrote in message
news:9CF6A4FE-F5B7-418E-B137-4362116FDA47@microsoft.com...
> Scenario:
> Windows Server 2003/SQL Server 2005 SP1 on publisher and subscriber.
> Transactional Replication (without Updateable subscriptions) with a PUSH
> publication from server A to server B.
> Replicate Schema changes are set to TRUE.
>
> Issue:
> We have a number of stored procedures with a length more than 815 lines as
> viewed in Management Studio (or 817 lines using sp_helptext , about 32,730
> characters),
> that compile and execute successfully on Server A and Server B. They are
> successfully included in the initial snapshot and replicated to Server B.
>
> However if one of these published stored procedures is edited using ALTER
> PROCEDURE from Management Studio, the ALTER fails.
> There is no error message the procedure sits and after 9 minutes the user
> terminates it rather than letting it time out.
> If the same procedure is edited - removing white space, valuable comments
> and layout to less than the threshold described above the ALTER PROCEDURE
> statement is successful
> and Replication Monitor can be used to see the detail line "A DDL change
> has
> been replicated".
>
> Is there a flag that can be set to increase this limit or is there
> something
> else that should be set in our publication that we have missed?
> Many thanks in advance for advice.