exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

Turns them back on.

exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

Maybe it's just me on a Friday afternoon, but this schema is more complex than necessary. It would work. A consideration would be that you must use joins for everything....

There are third-party applications that can help - SQL Data Compare 3.

There is a t-sql reserved word - readtext - that might help.

I posted a script here that did just that. I had to do it so that the scripts created by developers would run in the test environment.

Laughing.

Your boss is not a DBA; he just plays one in his office. Thanks for the laugh - "because you can just send the customer a new .exe. instead...

Ok...

Wie gehts - isn't that "how are you?" or something like that?

I usually use google.fr, and I know what you mean.

I just coalesce when I'm in meetings with clients. It makes me sound important and dba-ish.

Laughing...

I kept jumping to German sites...then I realized, ah, they are Frank's links. Where else would they be?

Deutschland, Deutschland, uber alles.... Wie gehts?

Yes, I have used the camel notation....

From BOL (ERROR message severity levels):

When a level 17, 18, or 19 error occurs, you can continue working, although you might not be able to execute a particular statement.

Severity...

Laughing....

Ciao means goodbye in Italian.

Yes, my copy of Kalen's book is beaten, stained (probably coffee) and worn. It is always within arm's reach.

I checked my shelves at home,...

When you talk of the wolf, you will see it's tail.

Laughing - the Venkman quote is from Ghostbuster I -

[Dana has described seeing a terror dog in her refrigerator]

Dr....

Laughing. "Product exposure" would be a better term.

Yes, the best option is to work with the system. Understand your tools - EM, QA, Profiler, etc.

Learn T-SQL. My mentor...

Laughing. No sense getting frustrated about it. It's how we learn. You don't know how many times I've been quizzed by developers when I tell them a SQL integer is...

I agree with Frank - moving columns by changing syscolumns sounds vaguely suicidal (or is that datacidal?).

You are better off with the solution of copying the data to a...