Please feel free to nicely tell people you are not doing their work for them. Or ask them to post more information. Or skip over them.

This has become quite a...

Please tell me you are looking to hire a DBA and not looking to copy someone's resume.

Your post is fairly inappropriate and not in the right forum. Please do not...

That should work fine, however once you fail over, you won't be able to fail back. The limits the usability here.

Do you mean your server has a trace file running?

This doesn't mean profiler is running. You can kill the trace.

Or examine connections to your instance.

What's the error?

Moved to Reporting Services forum.

But we'd be happy to have Gail write a book if she would 🙂

A book is a long project, and it's tough. Many, many people struggle with it. I've been...

First you need to post in the correct forum, one of the connecting or programming ones. I'll move this.

Are the settings being changed or is it just a disconnect? If...

I have a few notes on this based on PASS this past week, but SQL Server is definitely part of the cloud. I don't think MS is going to fight...

Congrats!

Or perhaps they knew there'd be fewer answers with so many people at PASS!

Service Broker sends messages back and forth. I think it's more designed for a notification of some sort, or an update of some values, not really moving result sets back...

Not recommended. The temp table will go away and the view will persist (And error out).

Why not a CTE?

We are talking about this, but we really want the forum software vendor to do this so that we can upgrade without losing work.

What are you running sqlsdiag for? It gathers information from the run, and if you run it multiple times without rebooting/restarting, I suppose they could be larger files, but I...

You need a driver from the source system. Is this stuff running on the mainframe?

Also, please post in the appropriate forum. I have moved this to 2005 development.