Thank You!

I will try and let you know how it does....

Thanks Again..... SQL2DAY

John--

Lets see if I can recall from memory--

Select Data_ID, DateTime and Batt_Vltg from tableName where DateTime = Max(DateTime) which would be the current day and additionally where the time =...

Thanks for the help--I'll attempt again....

So if I put the database backup file (C.BAK) in the MSSQL\BACKUP Directory and change the physical path to point to this, it should restore the new database?

Does the logical filename and the physical filename have to be the same?

I am familar with EM.  I did try this and I kept getting errors.  For some reason this should be striaghtforward.  Hoever its giving me a fit.  THe file was ftpd...

Sorry--I see I posted to SQL-2005 group.  I'll go to SQL-2000.....

I have a new database that a developer sent from a backup he performed at their site called C.BAK.  I would like to load to my backup server.  What is the...

Would I select all DateTime records that are midnight then update with dateadd function?

Would I query for all DateTimes that are blank and then update with function?

Thank You all for your responses.

My production table is DCPData_Basic_2006.  It has almost 8000 duplicate enteries.  The primary key was set on the first field ID.  Which from reading above...

Yes it sounds like your heading in the right direction from all you have read.  The fact that you're upgrading from 32  to 64 bit may or may not have issues...

Steve--

I am in process of doing the same but from SQL-2000 to SQL 2005 32 bit version.  You can probally copy the database over with DTS from what I've read...

Thank You--

1st attempt:  I tried upgrading an SQL-2000 instances in place.  Result: It failed due to password policy.

2nd attempt:  I copied production database files and attached to SQL-2005 instance.  All worked...

Thank You--

I tried this and it worked great.  What is ddl?

SQL2DAY