Hi Apat, I dont know if I understand well, but You said you can not use bulk insert because you dont have access to the server. I belive you said...

Hi , thanks for your reply..

i change to

cast(replace(x.text,'''','') as xml)

and works fine now !!!

Thanks a lot

Hi..i found..column iscomputed sys.columns

Thanks all

Well, If nobody in here can help me...i think i have a big problem...

Thanks a lot Gail..

I will implement your sugestions....

You are completely correct.

I dont find anything about IO susbsystem problem...I look at Event Viwer, SQL Log..nothing....i dont know why yet...but the infra guy in the customer is searching...

You think it´s god i...

Thanks for your time and help Gail.

We solve the problem creating a new database and runing the scripts ..so i drop de corrput database...Also, in the customer i did the...

Yes Gila..I dont have clean database...

Well... i cannot say in all customers because we just put in one new customer....with the old we send scripts only...but in this new customer the error goes to

I´m sorry,...

Hi Gila, thanks for your help´...

Like I said, this database does not contains data (only a few lines in this tables), because this database goes to customers in new instalations...

Hi, thanks for help..

This machine is our and Sata local disk. This machine we use to do our scripts and backup and restore in new customers.

But yesterday this backup was...

Yes..GSquared. Good idea...i think will be better work with XML..

Thanks a lot

Thanks Bob and Gsquared..Row_Number() help a lot ...

Thanks !!!

Thanks a lot Gail..

So I think in my case, 194 GB. it will be log duration ok ?..

I have a windows somenthing like 10:00 PM and 6:00 AM.. with you experience...i can do...