My preference when upgrading from SQL 7 has actually been to:

1.  Make a backup of all the databases.

2.  Script out the logins.

3.  Move all the user databases and the msdb...

EXEC sp_rename 'table.old_column','new_column'

Generally, this is a permissions issue.  Does the owner of the job have permissions to do everything the DTS package needs to do?

Can a user have more then one set of contact information?  Do you need to keep history when they change their contact information?  Will you want to search by last...

Can you explain what MySqlDump is???

You can right-click on the database, go to All Tasks...Generate SQL Script.  Select all the options.  Preview it.  Is that what you want?

The EMC Clariion is a downgrade from the Symmetrix line.  What are you trying to accomplish by this.  What is this test server compared to the production server (hardware)?  Have...

You need to call your hardware vendor. It sounds like you have faulty hardware somewhere.  I would take the server down at night and run a complete diagnostic on it.

That's very possible.  What kind of indexes do you have on the table?

From Books Online:

Permissions

Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner.

The easiest thing to do would be to add an update_script column to the table.  You can then just put the script that updated it in there.  Triggers won't capture...

Can we set it at the database level and coerce the collation in each SQL statement or is there an easier way?

You can, however that won't solve your problem.  Why...

You can find the script here:

http://www.nigelrivett.net/

Bookmarks are a great thing to have. 

We use SolarWinds software to monitor our SQL Servers physical counters.  I get alerts if the drive capacity falls below a certain amount (20%), the CPU goes above 95%, network...

I also have used it for ......   well, anyway.    One of the problems with SQL Mail is that it's not the most reliable...

Just make sure you set up some other account with the same permissions as BUILTIN/administrators before deleting it.  It's definitely a recommended best practice though to get rid of this...