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....
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
Last Comment
Anuj
ASKER CERTIFIED SOLUTION
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.
did you check my post?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
ASKER
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 ..
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.
The ETL logic is in the form of a stored procedure which is scheduled to run every hour..