What I'm thinking of is I'm going to do the database users article, a primer on crypto (what a DBA needs to know), and then go into the encryption within...

No, you are most certainly right. Good catch. I had a couple of guys around the office proofread and none of saw that....

I can look at doing that. I prefer to manage the security on my servers through the T-SQL instead of through the SSMS interface, but you make a good point.

I would take a look at the script. The method of authentication shouldn't matter. The login's rights within SQL Server and how it maps to a user in the database...

Are they connecting through the application to do the upgrade? Or is the upgrade being run from a separate program, such as an installer?

This looks like the linked tables were connected using SQL Server authentication, not Windows authentication... otherwise you'd see Login failed for Domain\User, or are you leaving out the domain?

Start a local PASS chapter... I believe one registration is free. I'm trying to start one in Columbia, SC, not for that reason,...

You'll get more out of PASS than any MOC course. By a long shot. Same thing was true of TechEd a couple of weeks back. I got more out of...

And I'm guessing a restart didn't fix it. You may want to call Microsoft Support and inquire if you need to unregister/register sqlctr90.dll (usually located in C:\Windows\System32). I know this...

In the SQL Server event log it'll tell you what it's listening on. For instance...

Named Pipes:

Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$NamedInstance\sql\query ]

TCP/IP:

Server is listening...

You can set what processors SQL Server uses and you can use query hints to tell SQL Server to either parallel queries or not, but other than that, SQL Server...

SQL Server is a multithreaded application. It can use the multiple processors just like any multithreaded application can. In addition, for costly queries, SQL Server can use parallelism, the ability...

Nope, those don't work. Already tried them, especially the AD and Exchange are both Jet-based databases (at the time Exchange was on 5.5). ...

As Ward indicates, tt requires dynamic SQL. You can't use a query to define the column names, unfortunately.

Here I gave some sources:

SSC Message Thread on Capacity Planning