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....
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft Development

Avatar of undefined
Last Comment
Anuj

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
EugeneZ

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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..
EugeneZ

did you check my post?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
SP_2018 .

ASKER
Compatibilty level is 100 both on publisher and subscriber end
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
EugeneZ

ok - it is time to post the code\ changes are you doing to this table
as you should know --replicated tables have some limitations ..
Anuj

Did you made any schema changes at the subscriber? the changes at subscriber could cause replication to fail.