After a bit more digging around i did come across from Dave Pinal. Looks like what i need to do i think but i can choose to script the schema...

I have eventually ran this:

-- disable referential integrity

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

GO

EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'

go

EXEC sp_MSForEachTable 'delete from ?'

GO

...

Yes you make some valid points re the security of the data and also the possibility of running things against the wrong data set! I think I could do something...

OK thanks for the quick reply.

Rather than do it on the MSX i have logged onto the new target server, right licked the agent - multiserver admin- and then added...

so am I following the correct process as outlined in my post ? Or is there a better way ? As i mentioned it looks like if I right click...

ah ok then - that answers my question. I was concerned the index was not getting rebuilt properly but obviously from what you say, because the job completes, the indexes...

Gail

I didnt copy the whole of the error log as i thought it would look clutered. I just showed what I thought people might need to see. Below is an...

what do you mean by 'truncated output' ? Where am i looking for that ?

Thanks

Thanks guys.

Yeah i have seen that script and i have a copy of it ready to go but i dont want to implement it just yet. This is something I...

yeah i can post code without a problem using that method - as i did in this very post. But how do i post the results of the code that...

Yeah sorry about the messy query results. I did preview it and it looked ok but when i posted it got out of line.

Incidentally how do you copy a result...

Thank you that query has worked and your explanation makes perfect sense!!!

🙂

Thanks for the quick reply, but its now back to showing 0% for rows that have some data and 100% for the field that is fully populated.

Example there are 5000...

Tried that and it it returns 100% for all 3 columns....i need it to reflect the correct percentage ?

Any other ideas ?

Thanks for all your help.

I can now look at the package in BIDS !!

Brilliant - thanks:-)