Go with SQLMail, it's better, nuff said.

Seriously though, configuration is simple with both, however SQL Mail give you options like @query that you just don't get with smtp mail. The...

Are you running Windows 2003?

You are not dropping the server, rather re-registering it with the correct name rather than (local)

When we did the migration we used a tool from BindView called bv-Admin. This migrated all user accounts along with their profiles, mailboxes etc, and saved us from running into...

I've not experienced any problems with this. Presumably you will be migrating the users as a part of the changeover? If so the users sids will be consistent and you...

Are you getting an error saying that the proc can't be created or that no rows will be added to sysdepends?

The easiest way to figure out the correct '',''' thing...

In Enterprise Manager try right clicking and Deleting the SQL Server Registration, then re-register the server this time using the servername rather than (local) and then try setting up replication...

Again personal opintion, but I would move all of the database objects (system, db, logs) on to the SAN and just leave the OS, pagefile and binaries on the local...

What was the initial size of the log (as you won't be able to shrink the filesize below that)?

Have you tried..

BACKUP LOG <DBNAME> WITH NO_LOG

GO

USE <DBNAME>

GO

DBCC SHRINKFILE ('<FILENAME>', 1, TRUNCATEONLY)

GO

If you actually go into the properites of the publication, to the Snapshot tab it allows you to specify locations for scripts to execute before and after the snapshot is...

It depends on what you are including in the database migration. Check your logins and check that you have removed the database if you are going to import the whole...

Did you drop the logins from server (b) before retrying the copy?

How about using an IF...ELSE with 2 different select statements?

I've found that you always throw at them the optimal solution, that way when you finally get the hardware it might possibly be something you could actually use...