• If you are looking to do this in a PRODUCTION environment, I REALLY REALLY REALLY encourage you to rethink your notions. Or at least get some professional guidance in determining why/if you need it at all, planning, implementation, monitoring, etc. You have very little hope of being successful with this based on the questions you asked here. It is a COMPLEX subsystem with LOTS of caveats, provisos, limitations, gotchas, etc.!!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service