Thank You

I will try this with @Execute = 0

Thus database is big old and ugly

Thanks again

Thanks do you use this how long does it take to run(how many tables do you run it on) and do you run it while users on on the database.

I created another table that look like these

SETIDINV_ITEM_IDMFG_IDMFG_ITM_IDPREFERRED_MFG

CORP100318002810031Y

CORP10031TM8002810031TMY

CORP100328002810032Y

CORP100518002810051Y

CORP10051SP8002810051SPY

CORP100528002810052Y

CORP100618002810061Y

CORP100628002810062Y

CORP100718002810071Y

CORP100728002810072Y

It has 3000 rows and I want to update it's sister table but only where the inv_item_id is in the master_item_tbl...

the 3000 rows are in an excel spreadsheet that I was emailed to insert in to my two tables(3000 for each table 6000 total)

I will copy these into studio and...

That worked thanks

This is my whole statement the convert I use gets me an error of

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime...

2008-07-02 17:31:12.000

the overall database size is 300gig and I fear that maintenance of any kind has not been run on it since 2008

backups take 15 hours.

Thanks Guys I did the Select INTO which worked much better than the EXPORT and I deleted 1000 rows at a time with a delay in between and had maybe...

Worked perfectly with no trouble at all thanks

Thanks You very much

I will try this tonight.

Thanks You very much

I will try this tonight.

If I run it on the production database I wont to remove the extra logfile from I get.

status =0 on all????

FileId FileSize ...

if I DBCC loginfo from the master I get

FileIdFileSz Start FSeqNoStatusParityCreateLSN

2253952 8192 27923 01280

2262144 262144 ...

the detach sounds like it my cause a lot of problems I have a very small windows to do this move in as we run 24/7 I need it...

then I would set the database off line and copy to the new location and bring online? If copy fails then I could just reset sql back to old location.