There will still be downtime with the cluster. Or there might be. As people try to connect, they'll get moved to the new cluster, but if you failover, those connected...

I got a note from someone that said my old picture was very unprofessional with a T-shirt on. They said they were in HR and it sent a bad impression...

There definitely seem to see more jobs in the BI sector, especially SSIS in the US. Not sure about the UK.

I think anything you can do to broaden your skills...

You do not need to install the server, just the client tools.

Thanks for the update, hadn't seen that.

For others, essentially a deletion of the SSMS shell key in the registry fixed this.

Why not detach and attach on the new server?

This set in the server properties as a default. For each user, you can see the properties of each user.

First you need to research this a bit yourself. What information are you looking for? There is lots of stuff about replication.

Second, most of this is documented in Books Online,...

Yep, that's how I do it for the site. VPN in, run SSMS locally on my desktop, connect to the server.

You just install the client tools from setup, but for...

Glad to help, happy you found it. I've been stymied by these before, and usually only catch them after digging through lots of data.

In that case, what I'd do is set up a script that

a) creates a table after recovery in some database, could be tempdb if needed

b) populates this with code, each...

I'd agree with Brian here that you ought to examine if you really need to do this.

If you go my route, I'd be sure that you don't allow the code...

Did you check both tables? Are you sure there aren't any other characters in there?

Do a select where you check the join fields as well, CAST the field as a...

The tools are part of the 2008 media. I'm not sure they are distributed separately.

You need admin rights for some things. no way around it.

What you could do, however, is put the commands in a stored proc, or even a table somewhere. Allow your...