Does this script work for anyone? I get a zero result set when I know that I am using a table with assummed but not materialized foriegn key relationships by...

Do you have the exact execution command?

One primary key based on the DOcument Identifier which is a GUID.

A primary key by default is a clustered index. You may want to make this a simple unique...

When you look at the execution plan take note of any book mark look ups and plan your indexes around them.. The optimal solution here would be a clustered index...

Locks are another issue if the system is highly transactional you want to take transaction log snapshots during the day and diffs or fulls at night. The drive performance will...

The above comment is correct you need to include a logical else and tell it what to do if it finds a null.

Three Reasons for DTS over Linked Server:

1: The DTS Data pump Item will allow you to set commit batch size per transaction which will improve overall performance and reduce the...

There isnt any way really to optimize the BCP portion of snapshot reintialization. I would suggest unfortunately to eliminate the network as the others have suggested and burn to DVD.

How big are your snapshots?? in MB just a ballpark

These stored procs will remove lingering replication systems settings on both the subscriber and the publisher's sides of replication.

Run on Subscriber Server.

   Run sp_RemoveDBReplication "[Subscriber Database Name]"

Run on Publisher Server.

  ...

Which server is enabled as a distributor? aka. Has the distribution database on it.

Is the replication within your LAN or are you trying to replicate out over a T1 or Something? Also are the Snapshots being generated local to the distributor or on a...

 SELECT

         column_name name,

                constraint_name name

 FROM   

  '+@destination_DatabaseName+'.information_schema.key_column_usage

 WHERE

  constraint_catalog='''+@destination_DatabaseName +'''

                and table_name = '''+@destination_TableName+'''

 ORDER BY

                constraint_name, ordinal_position