Hi there.

If you are getting these sort of errors, with no physical errors deteced, check out this article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

It mentions Lost Writes and Stale Reads which could be causing the...

Thanks, this server is a headache, its got around 8 databases, 4 of which are replicating to 4 different servers, in differen't manners and its getting a bit of a...

DTS does cause problems, particularly on large databases. You can have problems with permissions on DTS, and a host of other scripting problems. As a general rule the larger the...

simplest way to sort out the problem.

Just use

order by o.requireddate desc

not

order by requireddate desc

by specifying the table name the query will use the field in the...

Are you sure the error isn't provider specific? Why aren't you using the SQLOLEDB provider?

I've written many apps designed to work on both SQL and Access using ADO, the...

It moved the mdf correctly. In fact it restored all the files as they should have been. The file sizes were the correct size when compared to the backup, and...

Here's the full log for the failed restore:

#***************************************************************************

#* $VRTScprght: Copyright 1993 - 2004 VERITAS Software Corporation, All Rights Reserved $ *

#***************************************************************************

#

OPERATION RESTORE

OBJECTTYPE DATABASE

DATABASE "MDDQA"

MOVE  "Mdd3"

TO  "F:\MSSQL\Data\MDD3_log2.ldf"

MOVE "AIO_NEw"

TO "E:\MSSQL\Data\Mdd3.mdf"

NBIMAGE "cpxjeprod.MSSQL7.CPXJEPROD.db.MDD3.~.0.001of001.20050607220844..C"

SQLHOST...