I have a scheduled SQL ETL job which has a stored procedure ,but it keeps on failing due to below error.
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.
can you please post your replication topology? is it using sql2000?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.