What is GP10?

What client are you using to connect? If you are not using the SNAC client, which comes with SS2KL5 and later, it will not automatically connect. The previous...

Vista should exceed W2K3 in what is support, if I remember correctly. I don't have a W2K3 server to check on at the moment, but I'll try to later.

DTS will script this, which should handle constraints. Or you can just do the scripting, move the structure of the tables and use DTS without the drop/create.

You said you are...

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?