Also what about the Microsoft supplied tablediff! While BOL indicates this is a utility for comparing replicated tables it works quite nicely on any pair or table regardless of the...

One option you could consider if you have the transaction logs from the subscriber is a detailed analysis of these using a third party log reader or the undocumented function...

a touch overkill to get the hostname for sessions on your server perhaps?

select s.host_name

from sys.dm_exec_connections C

join sys.dm_exec_sessions S on S.session_id = C.session_ID

where...

Shinoj Ramanathan (8/10/2010)

---

My subsystem table has these value, seems high and I hardly have abt 10 publishers and about 20 subscribers. I wonder how I hit a limit

Snapshot -...

is this KB relevant http://support.microsoft.com/kb/910416

you may also see Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 00000020 at 0x0110B72B 2. int the error log

if so this is a known bug and there...

When I have seen this it was down to exceeding the number of worker threads configured in the various SQL Agent subsystems

To check this

on the distributor

select subsystem,max_worker_threads from ...

I would love the luxury of time to write an article. I work for a very busy online company, and most of the code and utilities I put together actually...

From post 2

There are always a million ways to do anything. It's quite possible that your idea is better, but this one works

from post 12

Error: System.Reflection.TargetInvocationException: Exception has been thrown...

If you can code something no matter how, then you can probably include it in the available event handlers. You have the ability to run just about anything you want...

Anything wrong with the event handlers already available within SSIS. It is very simple to set up an SSIS template with the event handlers coded to generate logging, thereafter use...

Everytime I have seen this it has been down to firewall rules which is possible in your case as well given that you are crossing domains. As requested confirm network...

Have you thought about the default trace as schema changes are already recorded there and easily available without the need for a ddl trigger. In fact Microsoft provides a schema...

I have to agree with some of the comments here particularly on the principal on version control however and at the risk or creating some controversy, I would question the...

Assumming that you have a single trigger on the table to handle inserts, updates and deletes there is a way to identify what caused the trigger to fire

Use the tables...

Try

select t2.ActualName as Name1,t3.Actualname as Name2

from TableA t1, TableB t2, TableB t3

where t2.Nameid = t1.Name

and t3.Nameid = t1.Name2