Browse by Tags

How to find subscriber is not getting upto date data?

Published 14 December 7 7:18 PM | SSQA.net

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more...

Filed under: sql server, data, replication, error, subscriptions

Annoying x80040E21 & x80040E24 errors

Published 25 May 7 4:41 AM | SSQA.net

If you are performing a simple process to import a data using a DTS package in SQL 2000 or an SSIS package in SQL 2005, you might be very familiar with errors such as "x80040E21 & x80040E24". To put more in the sense of real error it will...

Filed under: data, ssis, error, jet, component, oledb, mdac, dts, odbc