As a side note, since I work for Redgate, we've added our data tools (Prompt, Search, ReadyRoll) to Visual Studio 2017 Enterprise.
Any feedback appreciated if you try them.

It says after triggers on a table. These would be DML triggers.

I don't have an R2 instance handy, but there are some queries in here to examine all events: https://technet.microsoft.com/en-us/library/dd822788(v=sql.100).aspx

From Microsoft, Triple-DES is the algorithm. I hope they update BOL soon.

OK, if you're going up from 2000, do that first. Go to 2005 and get there.

Then what I'd do is clear up your VLFs first. You can do...

Ah, some sort of SMS or Ops Manager inventory, right?

The problem I've seen with these is that the data isn't always clean. What you should check is some...

Really it's an article that talks a bit about the history of containers and how they differ from VMs. Essentially  a container reuses much of the host kernal and base...

Is this SQL 2000 or 2008?

When you restore, you get the settings from the database backed up, but you can change your growth settings.

Was v_r_user in the join before? Or you added the column and the table?

I don't see the documentation anywhere, but I've asked MS for clarification.

It does say symmetric key, which in this day and age I'd hope would be AES, preferably...