Link to home
Start Free TrialLog in
Avatar of SP_2018 .
SP_2018 .Flag for United States of America

asked on

Replication error

Hi,


I have a scheduled SQL ETL job which has a stored procedure ,but it keeps on failing due to below error.

Message
Executed as user: domain/user. Schema change failed on object '[dbo].[tablename]'. Possibly due to active snapshot or other schema change activity. [SQLSTATE 42000] (Error 21386).  The step failed.

This table is also getting replicated(transactional replication) to our reporting server.

Please advise....
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SP_2018 .

ASKER

The replication is between two  servers on SQL 2008 .
The ETL logic is in the form of a stored procedure which is scheduled to run every hour..
did you check my post?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
Compatibilty level is 100 both on publisher and subscriber end
ok - it is time to post the code\ changes are you doing to this table
as you should know --replicated tables have some limitations ..
Did you made any schema changes at the subscriber? the changes at subscriber could cause replication to fail.