Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Unable ALTER Stored Proc if SP is Replicated

Author  Topic 

pradeepb
Starting Member

1 Post

Posted - 2008-04-12 : 10:43:41
HI,

My Stored Proc is Replicated to other DB Server, When iam trying to ALTER my modified SP in Publisher DB, ALTER statement not working, even it's not throwing any errors also.

My SP has very simple logic [Just for get data from DB] , no of lines 680, no of chars 32000 [Approx].

If i decrease the length of SP, it's working fine.


Can anybody help on this?

Thanks in advance..

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-12 : 12:34:33
Show us the structure of your SP so we can help.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 19:15:30
>> ALTER statement not working, even it's not throwing any errors also.

How do you know not working without any error?
Go to Top of Page
   

- Advertisement -