Thanx Sounds good Im gona try that...

Thanx,

This is obvisaly a cant do then...I apricate all the reply's...Its alredy a job that runs every night but the problem is it runs forever and I cant let it...

I agree the bcp will be n good way to do this but when I bcp all the data out , the data that is left still has Foreign key...

The bcp will work but with the size of the data this will take just as long? This will be a daily process aswell

Hi thanks for the reply

Cant truncate Foreign key constraints and I am not sure but Disabling the constraints has passed my mind but it just does'nt seem right..They are there...

Yes the recovery model is on simple, but the problem here is thee amount of data there is a text field coulumn that is kinda big wich I think is...