Hi all I am working this week at TechEd in Dallas helping to setup and run CommNet the
MyMsEvents.com website. That is the web site that lets attendees setup a calendar and lets the managers of the event do session management we also do the on site server setup and maintenance and kiosk software installation. This is an incredible thing we basically setup a large corporate intranet and rip it down in a two week period.
I have had some good lessens learned:
For SQL Server replication... Make sure the two SQL Serves are at the same sp level
Test for curricular references in triggers