Likely you would need multiple passes to find typos. Duplicates would be exact matches. typically that's a

select dupfield

, count (*)

from mytable

group by dupfield

having count(*) > 1

If...

Excellent job, Gail!

We're publishing part 2 in a couple weeks and part 3 as soon as possible after that.

I think Gail is leaving tomorrow for her 400 hour, round-the-world-across-the-hemispehere trip to PASS 🙂

I don't think I said that virtualization is the preferred method for consolidation. I am pro-virtualization, and it's worth considering. As I mentioned, it's not for everyone or every instance....

I don't think the service account needs to be a local admin. If I remember correctly, we ran lots of SQL 2000 instances under a domain account that was not...

Interesting points, Tom.

I think you have hit some good thoughts here, though I'd disagree that most people can't learn to program better. I do think many are lazy, but I...

I don't see a problem for decimal for money. In fact, I've never used the money data type. I don't trust that business rules are really that set, especially with...

I haven't done a lot of this, but when we had salespeople across the US, we used UTC as a standard. That way we were sure of the timing of...

I don't think there's a best. Not sure for that level of precision that decimal v numeric matters. I wouldn't pick float or real, as it's not necessary.

You might want to read this: http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm

This is hard to do in 2000. Easier in 2005 with CTEs and recursion.

happycar59 is correct. You need to do these between servers of the same version. Even if it were possible (you could log ship), one you failed over, you couldn't fail...

Have you setup replication before? If not, be sure you read about it in Books Online.

The publisher and distributor should be on 2000, but if you are just sending data,...

I'm with ALZDBA. Use Enterprise Manager and don't worry about it.

The SQL Server error log doesn't necessarily contain something to help you here. It might, but not necessarily.

Open Control Panel, data sources, create a new data source and see if...

Thanks for the updated code.