Brilliant.

It's just the safety net I was looking for.

Great article.

I liked the technique of using the parameter in the connection string.

Didn't think that was possible,

Nice hack!

Just a couple of small problems though:

1) Your creation script does not match...

I was clipping the article to paste to the Linux Admin!  Touche', you got me man!  Nice job!  And I was being so...

It makes sense to consolidate, especially in the light of service hardening, such as clustering or mirroring technology.  It's expensive, but can be better justified by hardening several instances prone...

Kudos on the use of openrowset to test the userid/password combination.  Always great to check your work, especially if you can automate that check!

Ya know, there are always two ways of looking at a problem.  One person's push is another's pull. 

Another version of the solution is to have server A publish the...