Just experimenting with replication at the moment, and after trying to set a table as read only using the following:
ADD CONSTRAINT chk_read_only
CHECK ( 1 = 0
(yes - I know now, that won't work) - I removed the constraint within managment studio, and subsequently mucked up the syncing.
The whole thing is running on sql server 2005, publicher and subscribers all on the same box for the moment)
2 of the 4 subscriptions give the 2147201016 error, - complaining about a missing stored procedure - if I look in the stored procedures for the subscribed tables - it seems that all the dbo.msmerge procedures
have gone bye bye!
also - the other 2 tables give another error:
The schema script 'if object_id(N'[dbo].[ALBANKHOL]') is not null exec('ALTER TABLE [dbo].[ALBANKHOL] WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK( 1 = 0 )
')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
(yes - table "albankhol" is the one I created the read only constraint on.
as mentioned, all subscribers and publisher are on the one database - so I don't think it;s a timeout issue
View Complete Post