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.

It could work, but IMHO, it's a bad move. At least to move everything. You could move some stuff, but I'd like someone nearby I could call in a pinch....

jgrubb,

nice synopsis and I think you've hit it. It works well in places, just be aware of what you're getting (and missing).

There are definitely people posting interview or homework questions. Please feel free to call them on it if you don't want to answer.

And participate where you can. Don't feel bad...

Sorry for the late note.

Seeing the paper result, but not holding it is interesting. And it's a good compromise, perhaps the best we'll ever get.

I read in one place that...

Gail has it correct. It will use more space, because it rebuilds things, but MDF files will grow only if you run out of space inside the current MDF files...

I'd agree with Michael. Go through the maintenance plan wizard for a start.