If you can't follow Chris Suggestions try to order the Cluster index in descending order like

Create clustered idx_name on interface (interfaceid desc) ...

I really would advice againt order by in...

you may want to have a look at sp_create_removable

hth

As you have discovered there is no GUI list interface to that info but you could write a query to extract it

Have a...

When these things happen to me is usually an indication of lack of Caffeine in my veins

I get a cup or two...

Look at your code:

DTSSource("Col011")\100

Is using integer division you should change it to Real Division  

DTSSource("Col011")/100

HTH

>>That would mean retyping the same chunk several times. Is there any other, more modular way?<<

Yes there is! Use a Subquery and you will be happy

Select 

        ExecCharge,

 NetBroker = (RateBroker...

You can wrap that logic in a custom resolver! use an stored procedure ans mark the article resolver to use that sp.

For more info look in BOL at

Custom Stored...

Charles,

The more I look to it the more it looks as a diskspace problem.

you said

>>Each time an affected table is removed, another one take's it's place, but always the same...

>>Check connectivity as well.<<

did you logged in with the SQL agent account and tested? and if so how did you?

There are other things you could change like "QueryTimeOut" in the...

can you manually bcp that table out?

You could but it makes it unportable and risky.

Is is better to Create an special DB just for those on your servers so that you are granted to have that...

Cheers!

Just for the fun of it allow me to introduce another point of view.

Yeah the case statement may be more performant that PWs but I would choose PW for superior...

why would you need to move the DBs if they are replicated ?

and what about changing snapshot to CHARACTER mode instead of native ?