DTS doesn't always do a good job of figuring out which objects need to be moved in what order based on dependencies.  If this is going to be a repeating...

To further explain...the backup file contains a list of all the files that comprise the database along with their paths.  If you just use RESTORE DATABASE SQL Server assumes that...

use RESTORE FILELISTONLY to get the logical file names in the backup file.  Then use

RESTORE DATABASE dbname

FROM DISK = 'backupFileName'

WITH MOVE 'FirstlogicalFileName' TO 'NewLocationAndName',

    MOVE ''SecondlogicalFileName' TO 'NewLocationAndName',

etc...

Yes, DDL can be placed in a transaction, and yes, it is prudent to do so.  Just make sure that you are doing adequate error checking or else your transaction...

linked servers can be a real Godsend.  You should exercise great care in setting up the security between them.  I have seen several cases where the linked server login mapping leaves...

Not a stupid suggestion at all.  I try to do test restores on a regular basis, both to maintain my skills and to ensure the validity of our process and media.

There are several variables that have to be taken into consideration here.  Are you retiring the old server (meaning specifically the SQL Server instance(s) on it) completely or will it remain in...

Thanks, that makes my point that whether or not the Person table is in 1NF depends on the business rules.

When you use a phrase like "it's more hypothesis and theory than law..." it sounds to me like you are equating the two; placing hypothesis and theory on one side...

Since sp_change_users_login does not work on Windows Logins the service account and it's privs should not make any difference.

I think Date, Darwen, and Pascal would only make the argument that your Person table is normalized if there were a rule that stated that a person must have 4...

OK, I tried, but I couldn't resist...

I totally agree with point A, but I think on B you missed the boat.

The science behind the Relational Model IS NOT evolving. ...

I largely agree with Jeremy's thoughts (and of course totally agree with his final conclusion) but would add a couple of things.

The Relational Model of Data IS based on science,...

We use ER Studio, and I have used ERWin in the past.  First, ER Studio is not Java based.  Second, as you stated, neither one is capable of being an...

DELETE

TableName

WHERE

ColumnName <= dateadd(d,