The link points to an article that discusses using the BeginExecuteNonQuery command. In my opinion, while this is techincally a means to execute a stored procedure asynchronously, in a practical...

If I understand you correctly:

We use views extensively and every view in each reporting DB uses fully qualified names. Creating new views or modifying views is a royal pain because...

I like it. I'm experimenting with it now.

One thing that does not seem obvious to me is this: Do I need to include the SYNONYM in each SQl object (View,...

Hmmm..I see where you are going, but I don't think it's what we need. At the very least it woulid require a collosal re-write and I'm not at all sure...