+1 for DTS on migration, that's why I still have 2000,2005,2008 running for different projects

I've always had a problem with heap tables: The basic rule is don't do it. So you have to find something to use as a proper key. If the key...

I think the reason you can't access the internal ID is that it can change when a reorganization takes place. So you'd break any integrity that relied on the key....

You are correct, and I agree. Identity columns should not be used for business data in that way. My point was that the transaction responsible for assigning the "gapless" sequence...

Does your solution really solve the issue?

What if the requirement was for no gaps in the key sequence? Doesn't using identities in this way lead to gaps in the key...

Your comment concerning Access is a bit unfair. Everyone starts somewhere. Just because a person started badly you can't judge the rest of their career on it.

Personally, I have an...

Sorry, I'm not suggesting low quality of code or application. I'm suggesting a lack of quality in the decision making process for the user experience, look and feel, and direction...

Gavin Reid (10/22/2008)

---

My concern with this number of releases to production would be alienating the audience. Every time they visited the site there could be new features to learn and...