First, please post in the version appropriate area. This was in 2000, I'll move to 2005.

Second, I'm assuming there is no connectivity, so some manual method is needed to move...

Have you profiled if anything else is happening or is this from a trace?

Why kill SPID2 if it's blocked by 1? Or am I not understanding. It would appear that...

Here is a KB for setting up mail and a few issues:

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

Walk through the procedure from MS exactly.

You have to loop somewhere, either in the client code or the stored procedure code. There's no good way to split the string up and insert the values in one...

You need to create a login on the SQL Server instance, meaning go to the security tab in SSMS and then logins. Grant access to Windows accounts or set up...

I don't think there is a step by step for completely cloning a server. For a database, typcially you would restore a backup and then fix the logins/users. You can...

mirroring was not supported in the RTM version. You must have at least SP1 to use and it works great, though it has limitations.

The snapshot on mirror works well, but...

1 - as often as you can, NEVER auto repair.

2 - I'd set up a job to check fragmentation and automatically fix those tables when they get too high. High...

What does the purging job do? Is is one transaction or multiples? Many tables? Some larger? There might be an issue related to scale here. I'd actually profile where in...

I think I might want to go work with the major if I look for a new job. Maybe convince them to open up a branch in the US 🙂

I've...

Or use a DDL trigger

I think any of them will work well. Hyperbac is interesting in that the developers originally wrote Litespeed and this is an evolution for them in terms of lessons learned...

If you plan on lots of VM work, get an external USB drive. Makes a big difference with performance.

Where did you get this value? If you run something like sp_configure, you'll see the configured value in the third column, meaning someone has changed it. by default, I think...

You can run VFP against SQL. I built an app years ago, 96-97 timeframe, and it was way ahead of VB in it's OOP capabilities.

These days I'd be more...