But Manual is not good if the box reboots in the middle of the night and when it comes back the services are not started.

-> SQL Server 2000 Enterprise Edition that is, on Windows 2000 Advanced Server with 2Gb RAM.

read it.

But unsure how this will affect my SQL Server, other Apps.

I was wonerding how this would affect SQL Server 2000 in general since the default is to have "Automatic ANSI to OEM Conversion" option checked/enabled.

it is in the Logs but I have them re-cycling daily to keep them small. Thus no records > 7 days past.

any other ideas ?

the date of the last time the database was restored.

that is the last time a specific database has been restored from a full backup file.

I want the last "Restore" time for a database.

"Mostly adds system objects that only exist in 2000"

Can anyone expand on this ?

Also,

Books Online:

"sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation".

Do you guys do this or just shut down...

what happens to the structure of the .MDF when you do the Restore method of upgrading ?

"it does upgrade to SQL2K the internals".

do you know exactly what happens here ?

sweet.

Also, does the 7.0 database get "upgraded" in the process.(i.e. does SQL Server make any changes at the database level, etc...)

So I don't need to create the database before hand and I can put the .MDF and .LDF files whereever I want ?

(By the way, this is a SQL Server 7.0 Database with Select Into/Bulk Copy enabled.)

So whenever there is a Bulk Insert, BCP....any non-logged transaction, a Log Backup will fail ???

The...