i dont think "nice adventure" is quite the term i'd use ...!!

I think what's happened with the "MyDatabase" is that it was created on a different SQL Server with the slighlty different default collation, and has then been detached and re-attached...

i think you've completely missed the spirit of the posting! the fact that it is "something different", and the fact that after 7 years of dealing with SQL Server this...

MY ... that IS a high horse!?

From the "lookup table madness" article, the overiding factor for me was the data integrity issue.

eg. You have CustomerType and ProductType ... these get merged into a single "Types" table!...

Have a search on the site, as someone else asked the same question a week or so ago. Basically though, my understanding from the answers to that article was that...

Jeez, English as well as SQL lessons now!?

"Gob" is an English (as in, FROM England!) slang term for Mouth!

Demo >>

CROSS THREADING :

GPF ... ru a Christian by any chance!??

I should keep your gob shut next time Steve ... the response has started a bigger uproar than the original article!?

Anyway ... bring back the romans, that's what i say ......

maybe he's got summat to worry about!??

Not as good as the Email / Text vote that Sky News did just after the London bombings ... the question being, more or less, "Do you agree with the...

think you might have been lost before that ... seeing as by the time you came into the thread, it had already been answered twice!? ... and lo and behold,...

what ... rather than to copy and paste you did from copy and paste before that!??

http://dave.exsoft.com.au/blog/index.php?/archives/27-Outsourced-Santa.html

Just to close the thread off ... from someone whole got made redundant because i was outsourced to India!?

Is there an echo in here!????