Thanks for you're input guys. In a nutshell, a Company may have 1 or many Addresses. For example, the first AddressType may be a Street Address, the second may be...

Try using a UNC path to Server2. Instead of "c:\temp\zz_region3.txt"

try \\Server2\c$\temp\zz_region3.txt

Do you have a feeling of de ja vu PW?

Looks like there is no option but to create a Calendar Table. I do like the idea of the bit columns IsWeekend and IsHoliday.

Thanks.

When I tackle a problem in T-SQL, I kind of deal with portions of it at at a time, cause if I think of it as a whole I get confused....

The following link http://www.sqlservercentral.com/columnists/sjones/businessdays.asp

has a brilliant article on how to calculate the number of business days between 2 dates. This is not what I'm trying to do.

In my...

Have a look in the MSDB Database. Tables such as sysjobs, sysjobhistory etc.

PW,

Sensational! Thank you, that's exactly what I wanted.

Ok. Thanks. I'll have a look.

You could try interogating the SYSCOMMENTS System Table for the Stored Proc Name to see if it exists!

How big is the Tables/Database you are trying to replicate?

Is the entire SQL Server hanging? or is just the Replication process?

Is this occurring when you are perfroming the INITIAL...

SkAudi,

Lets be more specific here, ofcource replication can be done via the Internet, but you have mentioned (Email). Huh? Please elaborate!

It sounds like the Subscriptions have expired because there was no data to replicate within the specified period of the Distributor setting.

What is the setting for your Distributor on when...

If you do not need the Triggers on the Subscribers, then go into each Trigger and use the option "NOT FOR REPLICATION". This requires a recompile. Look in BOL for...

If the RAISERROR Function is a performance degrader, then so is all types error trapping in your code! As Mark Manis has stated, try it and see for yourself and...