Ah, than you DouglasH.

I laughed out loud, thanks.

I'm actually one of those rare birds who doesn't even...

Thanks for those suggestions, Bill.

Anyone else?

Thank you, Dan.

Yes, Jason. The schema and the login have the same name and they were in the old database, everything worked fine.

Thanks Perry and Koen.

I was able to get BIDS and Management Studio installed on the desktops by using the full product install files.

It successfully installed on an XP machine (32...

Thanks for your reply, Perry.

When I ran setup.exe it immediately failed with a message saying "This file cannot be ran on a 32 bit machine" (or some similar wording)

Are you...

Thanks for the tip, Jeff. I'll look into computed columns - never used them. Yes always position 1.

Ah, I got it.

Update Table1

Set ColB = (Select Substring(ColA, 1, 1));

This worked.

Thanks.

Stewart. thanks for your ideas and for the post about SS 2012 and its' new features for updating stats.

My instance is 2008 so I'll probably leave the UPDATE STATISTICS in...

Thank you Jason and Abu! I will explore your ideas.

"There's no shortage of technology workers, especially good ones."

The way this is worded, it implies there are lots of good tech workers available.

And Miles, I'm one the "gray-hairs." 🙂

Thanks for your suggestions, Jared.

I solved it. We use Kaspersky Anti-virus software.

I uninstalled Kaspersky on my desktop. Then the Security Update for .Net 2.0 SP2 installed successfully. And my SQL...

Thanks, SQLKnowItAll,

Actually, XP wants to install this Security Update for .Net 2.0 SP2

KB2686828 but it fails during the update.

I'm thinking this may be causing Mgmt Studio to not work.

What...

Thanks SQLKnowItAll and everyone who contributed some ideas.

I'll start developing an SSIS package. I'm hoping it's possible to have a connection manager for my "2005" node of managed servers. This...