Most Wireless providers IMHO are hiding a lot of fees and it is very difficult to get any reimbursment for their mistakes. I wish not 1000 but 1000000 were calling...

And if you are not DROPing the destination objects bcp generates the files in native mode . That is why the types must be IDENTICAL.

>>>>>>>I have not tried this <<<<<<

Because you can Backup AND restore that database you could doit following these steps:

1. Stop ALL log readers

2. Stop ALL distribution Agents

3. Backup distribution database

4....

there is just on catch with that script. If sql server logins are generated and you use CHECK_POLICY you will have to modify it a bit

Otherwise the script works like a champ

Or any other JOB/Script doing it ?

for the record SQL 2005 *can* read "opened" tracefiles.

Most of the time you can get away by restoring only user databases and scripting logins and any other custom user procedures/function stored on master.

do NOT shrink the log file EVER. Back it up instead

what type of replication ?

By the way, with Transactional I do it all the time

This is hilarious

to perform DDL operations like the ones you posted (truncate tables) dynamic sql does *not* matter in terms of performance because it won't be dominated by the query but by...

OPENROWSET and any rowset in general can have "side effects", be careful with those

in 2005 you can get it from

SELECT

[name]

,modify_date

,create_date

FROM

sys.procedures

Because of "new" internal mechanisms...